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>