oracle 9i資料庫歸檔的啟用與停用總結

啟用歸檔模式
SQL> shutdown immediate;

SQL> startup mount;

SQL>alter system set log_archive_dest_1="LOCATION=d:\oracle\oradata\archivelog" scope=spfile;

SQL> alter system set log_archive_start=true scope=spfile;

重啟資料庫使以上兩個參數生效。

SQL> shutdown immediate;

SQL> startup mount;

SQL> alter database archivelog;

SQL> archive log start;

SQL> archive log list;

SQL> alter database open;
檢看狀態
SQL> archive log list;

停止歸檔模式
SQL> shutdown immediate;

SQL> startup mount;

SQL> alter database noarchivelog;

SQL> alter system set log_archive_start=false scope=spfile;

SQL> alter database open;
檢看狀態
SQL> archive log list;