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>