oracle归档模式

1、开启oracle归档模式：

su - oracle

export ORACLE_SID=TEST

sqlplus / as sysdba;

shutdown immediate;

startup mount;

alter archive log start;

alter database open;

quit;

2、关闭归档模式：

su - oracle

export ORACLE_SID=TEST

sqlplus / as sysdba;

shutdown immediate;

startup mount;

alter archive log stop

alter database open;

quit;

 

3、删除归档日志：

su - oracle

rman target sys/system@TEST ;

delete archivelog all;

exit;

 

4、查看归档状态：

SQL> archive log list;
Database log mode        No Archive Mode
Automatic archival        Disabled
Archive destination        /oradata/wfm/archive
Oldest online log sequence     482
Current log sequence        484
SQL>