ORA-00265: instance recovery required, cannot set ARCHIVELOG mode，restorearchivelog

ORA-00265: instance recovery required, cannot set ARCHIVELOG mode，restorearchivelog
問題現象：

我在執行開啟歸檔命令後報錯誤ORA-00265

    SQL> alter database archivelog;    alter database archivelog    *    ERROR at line 1:    ORA-00265: instance recovery required, cannot set ARCHIVELOG mode

問題分析：
     從如上錯誤我們可以看到是因為datafile，controlfile，redolog中的SCN號不一致導致無法開啟歸檔，那麼導致該問題的原因是因為我重啟資料庫到mount的時候採用的是startup force mount;因為這個命令實際上是做了兩步操作，分別如下:
1、shutdown abort    ---強制關閉資料庫
2、startup mount

      既然我們隱含的做了shutdown abort操作之後，也就意味著datafile，controlfile，redolog這裡面的SCN號肯定不一致，需要在open資料庫的過程中做recover，由於他們的SCN號不一致，所以會導致無法在mount狀態下開啟archivelog,如下:

    SQL> startup mount force;    ORACLE instance started.    Total System Global Area 2505338880 bytes    Fixed Size 2255832 bytes    Variable Size 620758056 bytes    Database Buffers 1862270976 bytes    Redo Buffers 20054016 bytes    Database mounted.    SQL> alter database archivelog;    alter database archivelog    *    ERROR at line 1:    ORA-00265: instance recovery required, cannot set ARCHIVELOG mode

問題解決辦法:
針對該問題，最簡單的解決辦法是，將資料庫open，這個時候會進行recover操作，完成之後再進行shutdown immediate後啟動到statup mount就可以開啟歸檔了，詳細見如下：

    SQL> alter database open;    Database altered.    ####recover日誌資訊如下    alter database open    Beginning crash recovery of 1 threads     parallel recovery started with 3 processes    Started redo scan    Completed redo scan     read 1522 KB redo, 175 data blocks need recovery    Started redo application at     Thread 1: logseq 7, block 10941    Recovery of Online Redo Log: Thread 1 Group 1 Seq 7 Reading mem 0      Mem# 0: /DBData/woo2/redo01.log    Completed redo application of 0.44MB    Completed crash recovery at     Thread 1: logseq 7, block 13985, scn 991198     175 data blocks read, 175 data blocks written, 1522 redo k-bytes read    Wed Sep 03 22:39:35 2014    Thread 1 advanced to log sequence 8 (thread open)    Thread 1 opened at log sequence 8      Current log# 2 seq# 8 mem# 0: /DBData/woo2/redo02.log    Successful open of redo thread 1    MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set    Wed Sep 03 22:39:35 2014    SMON: enabling cache recovery    [13499] Successfully onlined Undo Tablespace 2.    Undo initialization finished serial:0 start:3565124 end:3565194 diff:70 (0 seconds)    Verifying file header compatibility for 11g tablespace encryption..    Verifying 11g file header compatibility for tablespace encryption completed    SMON: enabling tx recovery    Database Characterset is AL32UTF8    No Resource Manager plan active    replication_dependency_tracking turned off (no async multimaster replication found)    Starting background process QMNC    Wed Sep 03 22:39:36 2014    QMNC started with pid=23, OS id=16119    Completed: alter database open    Wed Sep 03 22:39:37 2014    db_recovery_file_dest_size of 4182 MB is 0.00% used. This is a    user-specified limit on the amount of space that will be used by this    database for recovery-related files, and does not reflect the amount of    space available in the underlying filesystem or ASM diskgroup.    Wed Sep 03 22:39:37 2014    Starting background process CJQ0    Wed Sep 03 22:39:37 2014    CJQ0 started with pid=24, OS id=16134    Starting background process SMCO    Wed Sep 03 22:39:43 2014    SMCO started with pid=30, OS id=16149

#####immediate關閉資料庫，重新開啟歸檔,即可。

    SQL> shutdown immediate    Database closed.    Database dismounted.    ORACLE instance shut down.    SQL> startup mount;    ORACLE instance started.    Total System Global Area 2505338880 bytes    Fixed Size 2255832 bytes    Variable Size 620758056 bytes    Database Buffers 1862270976 bytes    Redo Buffers 20054016 bytes    Database mounted.    SQL> alter database archivelog;    Database altered.    SQL> alter database open;    Database altered.    SQL>    ###開啟歸檔alert日誌資訊如下    ALTER DATABASE MOUNT    Successful mount of redo thread 1, with mount id 3606990310    Database mounted in Exclusive Mode    Lost write protection disabled    Completed: ALTER DATABASE MOUNT    Wed Sep 03 22:45:06 2014    alter database archivelog    Completed: alter database archivelog    alter database open    Wed Sep 03 22:45:12 2014    LGWR: STARTING ARCH PROCESSES    Wed Sep 03 22:45:12 2014    ARC0 started with pid=20, OS id=16867    ARC0: Archival started    LGWR: STARTING ARCH PROCESSES COMPLETE    ARC0: STARTING ARCH PROCESSES    Wed Sep 03 22:45:13 2014    ARC1 started with pid=21, OS id=16871    Wed Sep 03 22:45:13 2014    ARC2 started with pid=22, OS id=16873    Wed Sep 03 22:45:13 2014    ARC3 started with pid=23, OS id=16875    ARC1: Archival started    ARC2: Archival started    ARC1: Becoming the \