问题描述:
1、删除redo所有日志,数据库无法启动: http://blog.itpub.net/28939273/viewspace-1070222/
今天,在网上看到一篇文章《删除redo所有日志,数据库无法启动》,于是自己也在测试环境上验证了一下。
删除redo日志后,重新启动后出现以下错误:
SQL> startup
Total System Global Area 1653518336 bytes
Database mounted.处理方式:
ORA-03113: end-of-file on communication channel
Process ID: 23592
Session ID: 237 Serial number: 7
SQL> exit
[oracle@zmotm003 racdb]$ sqlplus "/as sysdba"
SQL*Plus: Release 11.2.0.3.0 Production on Tue Jan 14 21:27:16 2014
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup mount;
ORACLE instance started.
Total System Global Area 1653518336 bytes
Database mounted.
SQL> select member from v$logfile;
MEMBER
--------------------------------------------------------------------------------
/u01/app/oracle/oradata/racdb/redo03.log
/u01/app/oracle/oradata/racdb/redo02.log
/u01/app/oracle/oradata/racdb/redo01.log
/u01/app/oracle/oradata/racdb/RACDB/onlinelog/o1_mf_4_9doqn8tf_.log
/u01/app/oracle/flash_recovery_area/RACDB/onlinelog/o1_mf_4_9doqn964_.log
/u01/app/oracle/oradata/racdb/RACDB/onlinelog/o1_mf_5_9doqn9tz_.log
/u01/app/oracle/flash_recovery_area/RACDB/onlinelog/o1_mf_5_9doqnbh5_.log
7 rows selected.参考
SQL> alter database clear unarchived logfile group 1;
SQL> alter database clear unarchived logfile group 2;
SQL> alter database clear unarchived logfile group 3;
SQL> alter database open;
Database altered.
SQL> select status from v$instance;
STATUS
------------
OPEN
SQL> exit
1、删除redo所有日志,数据库无法启动: http://blog.itpub.net/28939273/viewspace-1070222/
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/29439655/viewspace-1070383/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/29439655/viewspace-1070383/