oracle归档停用,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;