RAC环境下修改归档模式(二)
estination USE_DB_RECOVERY_FILE_DEST -->归档位置为参数DB_RECOVERY_FILE_DEST的值
Oldest online log sequence 60 -->下面是sequence相关信息
Next log sequence to archive 61
Current log sequence 61
SQL> show parameter db_recovery_file
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest string +REV
db_recovery_file_dest_size big integer 2G
4、归档验证
SQL> select inst_id,name,thread#,sequence#,status from gv$archived_log; -->当前无任何归档日志
no rows selected
SQL> alter system switch logfile; -->在实例1上进行归档
System altered.
SQL> col name format a65
SQL> select inst_id,name,thread#,sequence#,status from gv$archived_log; -->查看到sequence为61的日志已经归档
INST_ID NAME THREAD# SEQUENCE# S
---------- ----------------------------------------------------------------- ---------- ---------- -
1 +REV/ora10g/archivelog/2012_12_24/thread_1_seq_61.459.802892953 1 61
SQL> select name,thread#,sequence#,status from v$archived_log; -->下面是从实例级别的视图来查看
NAME THREAD# SEQUENCE# S
----------------------------------------------------------------- ---------- ---------- -
+REV/ora10g/archivelog/2012_12_24/thread_1_seq_61.459.802892953 1 61 A
SQL> conn system/oracle@ora10g2 -->连接到实例2
Connected.
SQL> show parameter instance_name;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
instance_name string ora10g2
SQL> alter system switch logfile; -->在实例2上进行归档
System altered.
SQL> select inst_id,name,thread#,sequence#,status from gv$archived_log;
-->可以看到sequence为43的日志已经归档
-->注意这个视图查询时同一个归档日志除了出现在自身实例中外,对另外的实例也是可见的
INST_ID NAME THREAD# SEQUENCE# S
---------- ----------------------------------------------------------------- ---------- ---------- -
1 +REV/ora10g/archivelog/2012_12_24/thread_1_seq_61.459.802892953 1 61 A
1 +REV/ora10g/archivelog/2012_12_24/thread_2_seq_43.458.802893283 2 43 A
2 +REV/ora10g/archivelog/2012_12_24/thread_1_seq_61.459.802892953 1 61 A
2 +REV/ora10g/archivelog/2012_12_24/thread_2_seq_43.458.802893283 2 43 A
-->查看日志的状态
-->注意这个v$log视图将两个实例上的组及状态都显示出来了
-->在这里用thread#来区分，thread#为1表示实例1上的日志组有1,2,且1处于current状态.thread#2类似.
SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIM
---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- ---------
1 1 62 52428800 2 NO CURRENT 4314741 24-DEC-12
2 1 61 52428800 2 YES ACTIVE 4312116 24-DEC-12
3 2 43 52428800 2 YES ACTIVE 4312300 24-DEC-12
4 2 44 52428800 2 NO CURRENT 4315097 24-DEC-12