[Oracle][OnlineREDO]数据库无法启动时的对应策略:

转载于 2017-10-04 16:34:00 发布 · 93 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/gaojian/p/7625781.html

文章标签：

#数据库

本文提供了一套详细的Oracle数据库启动故障排除方案，包括使用mount模式启动数据库、检查redo日志状态、清除redo日志文件及执行数据库恢复等步骤。对于不同情况给出了具体的SQL指令，并针对归档模式和非归档模式提供了不同的解决方案。

[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.