Review Of Alter System Archive Log Ideas. If you are using archivelog but have disabled automatic archiving, the last three lines might look like: From the above output you can see that database is in archive log mode and automatic archival is also enabled.
Sql> alter system set log_archive_dest_1=’location=xxxxxxx/reports valid_for=(all_logfiles,all_roles) db_unique_name=report’ scope=both;. Specify the alternative location within sql*plus for the. Oldest online log sequence 222 next log sequence to archive 222 current log.
