SQL> select * from gv$logfile;
INST_ID GROUP# STATUS TYPE MEMBER IS_
---------- ---------- ------- ------- --------------------------------------------- ---
2 2 ONLINE +DG1/prod/onlinelog/group_2.262.833306667 NO
2 2 ONLINE +RCY1/prod/onlinelog/group_2.258.833306669 YES
2 1 ONLINE +DG1/prod/onlinelog/group_1.261.833306659 NO
2 1 ONLINE +RCY1/prod/onlinelog/group_1.257.833306665 YES
2 3 ONLINE +DG1/prod/onlinelog/group_3.266.833307071 NO
2 3 ONLINE +RCY1/prod/onlinelog/group_3.259.833307075 YES
2 4 ONLINE +DG1/prod/onlinelog/group_4.267.833307079 NO
2 4 ONLINE +RCY1/prod/onlinelog/group_4.260.833307081 YES
1 2 ONLINE +DG1/prod/onlinelog/group_2.262.833306667 NO
1 2 ONLINE +RCY1/prod/onlinelog/group_2.258.833306669 YES
1 1 ONLINE +DG1/prod/onlinelog/group_1.261.833306659 NO
1 1 ONLINE +RCY1/prod/onlinelog/group_1.257.833306665 YES
1 3 ONLINE +DG1/prod/onlinelog/group_3.266.833307071 NO
1 3 ONLINE +RCY1/prod/onlinelog/group_3.259.833307075 YES
1 4 ONLINE +DG1/prod/onlinelog/group_4.267.833307079 NO
1 4 ONLINE +RCY1/prod/onlinelog/group_4.260.833307081 YES
16 rows selected.
SQL> select * from gv$log;
INST_ID GROUP# THREAD# SEQUENCE# BYTES BLOCKSIZE MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIM NEXT_CHANGE# NEXT_TIME
---------- ---------- ---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- --------- ------------ ---------
1 1 1 39 52428800 512 2 YES INACTIVE 1661715 11-MAY-14 1661754 11-MAY-14
1 2 1 40 52428800 512 2 NO CURRENT 1662349 11-MAY-14 2.8147E+14 11-MAY-14
1 3 2 25 52428800 512 2 NO CURRENT 1634834 11-MAY-14 2.8147E+14 11-MAY-14
1 4 2 24 52428800 512 2 YES INACTIVE 1630120 11-MAY-14 1634779 11-MAY-14
2 1 1 39 52428800 512 2 YES INACTIVE 1661715 11-MAY-14 1661754 11-MAY-14
2 2 1 40 52428800 512 2 NO CURRENT 1662349 11-MAY-14 2.8147E+14 11-MAY-14
2 3 2 25 52428800 512 2 NO CURRENT 1634834 11-MAY-14 2.8147E+14 11-MAY-14
2 4 2 24 52428800 512 2 YES INACTIVE 1630120 11-MAY-14 1634779 11-MAY-14
SQL> shutdown abort;
ORACLE instance shut down.
二，rac2 查看告警日志信息
Sun May 11 13:34:01 2014
Reconfiguration started (old inc 12, new inc 14)
List of instances:
2 (myinst: 2)
Global Resource Directory frozen
* dead instance detected - domain 0 invalid = TRUE
Communication channels reestablished
Master broadcasted resource hash value bitmaps
Non-local Process blocks cleaned out
Sun May 11 13:34:01 2014
LMS 0: 0 GCS shadows cancelled, 0 closed, 0 Xw survived
Set master node info
Submitted all remote-enqueue requests
Dwn-cvts replayed, VALBLKs dubious
All grantable enqueues granted
Post SMON to start 1st pass IR
Submitted all GCS remote-cache requests
Post SMON to start 1st pass IR
Fix write in gcs resources
Reconfiguration complete
Sun May 11 13:34:01 2014
Instance recovery: looking for dead threads
Beginning instance recovery of 1 threads
Started redo scan
Completed redo scan
read 396 KB redo, 34 data blocks need recovery
Started redo application at
Thread 1: logseq 38, block 78416
Sun May 11 13:34:14 2014
Recovery of Online Redo Log: Thread 1 Group 2 Seq 38 Reading mem 0
Mem# 0: +DG1/prod/onlinelog/group_2.262.833306667
Mem# 1: +RCY1/prod/onlinelog/group_2.258.833306669
Completed redo application of 0.14MB
Completed instance recovery at
Thread 1: logseq 38, block 79208, scn 1661662
34 data blocks read, 54 data blocks written, 396 redo k-bytes read
Thread 1 advanced to log sequence 39 (thread recovery)
Redo thread 1 internally disabled at seq 39 (SMON)
Sun May 11 13:34:27 2014
Archived Log entry 44 added for thread 1 sequence 38 ID 0xe9c629a dest 1:
Sun May 11 13:34:28 2014
ARC0: Archiving disabled thread 1 sequence 39
Archived Log entry 45 added for thread 1 sequence 39 ID 0xe9c629a dest 1:
注：当一个节点异常关闭时，另外的节点会自动进行实例恢复。