11g RAC 归档与非归档的切换

千家信息网最后更新 2025年02月02日11g RAC 归档与非归档的切换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 mount SYS@rac1> alter database archivelog;
4.打开数据库 SYS@rac1> alter database open;
5。两个节点验证 节点1 SYS@rac1> archive log list Database log mode Archive Mode Automatic archival Enabled Archive destination +FRA Oldest online log sequence 25 Next log sequence to archive 26 Current log sequence 26
节点2 SYS@rac2> archive log list Database log mode Archive Mode Automatic archival Enabled Archive destination +FRA Oldest online log sequence 29 Next log sequence to archive 30 Current log sequence 30
6.查看归档文件 ASMCMD [+FRA/rac/archivelog/2018_03_23] > ls thread_1_seq_26.263.971545091 thread_2_seq_29.261.971544421 thread_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 list Database log mode No Archive Mode Automatic archival Disabled Archive destination +FRA Oldest online log sequence 26 Current log sequence 27
SYS@rac2> archive log list Database log mode No Archive Mode Automatic archival Disabled Archive destination +FRA Oldest online log sequence 31 Current log sequence 32
使用rman 删除归档 [oracle@rac1 ~]$ rman target / RMAN> delete archivelog all;
ASMCMD [+fra/rac] > ls CONTROLFILE/ ONLINELOG/ 已经删除