[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
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.
本文转自健哥的数据花园博客园博客，原文链接：http://www.cnblogs.com/gaojian/p/7625781.html，如需转载请自行联系原作者
