11g RAC 归档与非归档的切换
非归档------->归档1.设置归档路径SYS@rac1> alter system set log_archive_dest_1='LOCATION=+fra' scope=both sid='rac1';SYS@rac2> alter system set log_archive_dest_1='LOCATION=+fra' scope=both sid='rac2';
2.关闭所有实例shutdown immediate
3.设置归档SYS@rac1> startup mountSYS@rac1> alter database archivelog;
4.打开数据库SYS@rac1> alter database open;
5。两个节点验证节点1SYS@rac1> archive log listDatabase log mode Archive ModeAutomatic archival EnabledArchive destination +FRAOldest online log sequence 25Next log sequence to archive 26Current log sequence 26
节点2SYS@rac2> archive log listDatabase log mode Archive ModeAutomatic archival EnabledArchive destination +FRAOldest online log sequence 29Next log sequence to archive 30Current log sequence 30
6.查看归档文件ASMCMD [+FRA/rac/archivelog/2018_03_23] > lsthread_1_seq_26.263.971545091thread_2_seq_29.261.971544421thread_2_seq_30.262.971545055
归档------->非归档1关闭数据库[oracle@rac1 ~]$ srvctl stop database -d rac
2.其中一个节点操作SYS@rac1> startup mount;SYS@rac1> alter database noarchivelog;SYS@rac1> alter database open;
3.验证SYS@rac1> archive log listDatabase log mode No Archive ModeAutomatic archival DisabledArchive destination +FRAOldest online log sequence 26Current log sequence 27
SYS@rac2> archive log listDatabase log mode No Archive ModeAutomatic archival DisabledArchive destination +FRAOldest online log sequence 31Current log sequence 32
使用rman 删除归档[oracle@rac1 ~]$ rman target /RMAN> delete archivelog all;
ASMCMD [+fra/rac] > lsCONTROLFILE/ONLINELOG/已经删除