SQL> shutdown immediate
SQL> startup mount
SQL> alter system set log_archive_dest_1='LOCATION=/u01/app/oracle/archive/ mandatory';
SQL> alter system set log_archive_dest_2='LOCATION=/u02/app/oracle/archive/ optional';
SQL> alter database archivelog;
SQL> alter database open;
SQL> select dbid,name,log_mode from v$database;
DBID NAME LOG_MODE
---------- --------------------------- ------------------------------------
1081616855 KING ARCHIVELOG
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /u02/app/oracle/archive/
Oldest online log sequence 39
Next log sequence to archive 41
Current log sequence 41
SQL> show parameter log_archive_dest_1;
NAME TYPE VALUE
------------------------------------ --------------------------------- ------------------------------
log_archive_dest_1 string LOCATION=/u01/app/oracle/archi
ve/ mandatory
SQL> show parameter log_archive_dest_2;
NAME TYPE VALUE
------------------------------------ --------------------------------- ------------------------------
log_archive_dest_2 string LOCATION=/u02/app/oracle/archi
ve/ optional
SQL> shutdown immediate
SQL> startup mount
SQL>
阅读背景：
Oracle Database 归档管理
来源：互联网
分享到：
