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>

oracle归档模式,布布扣,bubuko.com

oracle归档模式

上一篇:Mysql的相关命令


下一篇:winform DataGridView 组件数据绑定