rac开启归档

参考大话rac
rac归档：要求执行恢复的节点能读取所有节点的归档，catch fusion需要用到故障节点的归档

1.在节点一、节点二创建相同的归档目录、分配权限

mkdir /arch1 /arch2 
chown -R oracle:dba /arch1 /arch2 
chmod -R 775 /arch1 /arch2 

2.rac公用spfile，在一节点配置即可  
alter system set log_archive_dest_1='location=/arch2' scope=spfile sid='racndb2';  
alter system set log_archive_dest_2='service=racndb1' scope=spfile sid='racndb2';  
alter system set log_archive_dest_1='location=/arch1' scope=spfile sid='racndb1';  
alter system set log_archive_dest_2='service=racndb2' scope=spfile sid='racndb1';  

alter system set standby_archive_dest='/arch2' scope=spfile sid='racndb1';  
alter system set standby_archive_dest='/arch1' scope=spfile sid='racndb2';  

alter system set cluster_database=false scope=spfile sid='*'; 

3.关闭所有实例  
shudown immediate  

4.在一个节点执行  
SQL> startup mount  
ORACLE instance started.  

Total System Global Area 901775360 bytes  
Fixed Size 2100424 bytes  
Variable Size 356516664 bytes  
Database Buffers 536870912 bytes  
Redo Buffers 6287360 bytes  
Database mounted.  
SQL> alter database archivelog;  

Database altered.  

SQL> alter system set cluster_database=true scope=spfile sid='*';  

System altered.  

SQL> archive log list  
Database log mode Archive Mode  
Automatic archival Enabled  
Archive destination /arch1  
Oldest online log sequence 87  
Next log sequence to archive 88  
Current log sequence 88  

SQL> shutdown immediate 
ORA-01109: database not open  


Database dismounted.  
ORACLE instance shut down.  
SQL>  

5.所有节点启动实例  
startup  

6.任一节点切换归档  
SQL> alter system switch logfile;  

7.检查归档：在两节点查看归档目录，发现两节点生成日志完全一样  
[ oracle@racn1  /]$ ls /arch1  
1_88_863886525.dbf 1_91_863886525.dbf 1_94_863886525.dbf 1_97_863886525.dbf  
1_89_863886525.dbf 1_92_863886525.dbf 1_95_863886525.dbf 1_98_863886525.dbf  
1_90_863886525.dbf 1_93_863886525.dbf 1_96_863886525.dbf 1_99_863886525.dbf  
[ oracle@racn1  /]$ ls /arch2  
2_18_863886525.dbf 2_19_863886525.dbf 2_20_863886525.dbf 2_21_863886525.dbf  
[ oracle@racn1  /]$  

节点一：  
SQL> show parameter log_archive_dest  

NAME TYPE VALUE  
------------------------------------ ----------- ------------------------------  
log_archive_dest string  
log_archive_dest_1 string location=/arch1  
log_archive_dest_10 string  
log_archive_dest_2 string service=racndb2  
log_archive_dest_3 string  
log_archive_dest_4 string  
log_archive_dest_5 string  
log_archive_dest_6 string  
log_archive_dest_7 string  
log_archive_dest_8 string  
log_archive_dest_9 string  

NAME TYPE VALUE  
------------------------------------ ----------- ------------------------------  
log_archive_dest_state_1 string enable  
log_archive_dest_state_10 string enable  
log_archive_dest_state_2 string enable  
log_archive_dest_state_3 string enable  
log_archive_dest_state_4 string enable  
log_archive_dest_state_5 string enable  
log_archive_dest_state_6 string enable  
log_archive_dest_state_7 string enable  
log_archive_dest_state_8 string enable  
log_archive_dest_state_9 string enable  
SQL>  
SQL> show parameter standby_archive_dest  

NAME TYPE VALUE  
------------------------------------ ----------- ------------------------------  
standby_archive_dest string /arch2  
SQL>  

节点二：  
SQL> show parameter log_archive_dest  

NAME TYPE VALUE  
------------------------------------ ----------- ------------------------------  
log_archive_dest string  
log_archive_dest_1 string location=/arch2  
log_archive_dest_10 string  
log_archive_dest_2 string service=racndb1  
log_archive_dest_3 string  
log_archive_dest_4 string  
log_archive_dest_5 string  
log_archive_dest_6 string  
log_archive_dest_7 string  
log_archive_dest_8 string  
log_archive_dest_9 string  

NAME TYPE VALUE  
------------------------------------ ----------- ------------------------------  
log_archive_dest_state_1 string enable  
log_archive_dest_state_10 string enable  
log_archive_dest_state_2 string enable  
log_archive_dest_state_3 string enable  
log_archive_dest_state_4 string enable  
log_archive_dest_state_5 string enable  
log_archive_dest_state_6 string enable  
log_archive_dest_state_7 string enable  
log_archive_dest_state_8 string enable  
log_archive_dest_state_9 string enable  
SQL> show parameter standby_archive_dest  

NAME TYPE VALUE  
------------------------------------ ----------- ------------------------------  
standby_archive_dest string /arch1  
SQL>

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/21699095/viewspace-1341650/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/21699095/viewspace-1341650/