[Oracle][OnlineREDO]資料庫無法啟動時的對應策略:

weixin_33912246發表於2017-10-04

[Oracle][OnlineREDO]資料庫無法啟動時的對應策略:

1. Start with mount.

  SQL> conn / as sysdba
  SQL> startup mount

 2. Check the redo log in which v $ log failed.

  SQL> select * from v $ log;

   ===> If STATUS = 'INACTIVE', perform step 3.
        If STATUS = 'INACTIVE', do step 4.

 3. Clear the redo log file.

  SQL> alter database clear logfile group X;
  SQL> alter database open;

 4. Execute the recover statement.

  SQL> recover database until cancel;
  SQL> alter database open resetlogs;
   
If you can not deal with the above method, the following actions are required.

 a) In the archive log mode

  Apply the created archive log and recover.

 b) In case of no archive log mode

  Please restore the acquired cold backup.

相關文章