rac下的实例恢复

rac日志情况
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

一，rac1异常关闭
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:

注：当一个节点异常关闭时，另外的节点会自动进行实例恢复。

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

转载于:http://blog.itpub.net/29108064/viewspace-1158473/