ITPub博客

首页 > 数据库 > Oracle > rac开启归档

rac开启归档

原创 Oracle 作者:ming270004540 时间:2014-11-21 15:09:56 0 删除 编辑
参考大话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博客 ” ,链接:https://blog.itpub.net/21699095/viewspace-1341650/ ,如需转载,请注明出处,否则将追究法律责任。

下一篇: 添加votedisk
请登录后发表评论 登录
全部评论

注册时间:2011-06-18

  • 博文量
    8
  • 访问量
    48233