请教关于日志问题导致数据库无法打开
大家好:
我之前为数据库做过 alter database clear unarchived logfile group... 的操作。
现在发现当时数据库序列号是34,下一个归档的日志序列号是0,如下:
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /ora01/oracle/oradata/demo/archivelog
Oldest online log sequence 34
Next log sequence to archive 0
Current log sequence 34
SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARCHIVED STATUS FIRST_CHANGE# FIRST_TIME
------------------ ------------------ ------------------ ------------------ ------------------ --------- ------------------------------------------------ ------------------ ------------------
1 1 34 52428800 2 YES INACTIVE 1644109 23-JAN-13
3 1 0 52428800 2 NO CLEARING_CURRENT 1644161 23-JAN-13
2 1 0 52428800 2 YES UNUSED 0
SQL> alter database clear unarchived logfile group 3;
alter database clear unarchived logfile group 3
*
ERROR at line 1:
ORA-00322: log 3 of thread 1 is not current copy
ORA-00312: online log 3 thread 1: '/ora01/oracle/oradata/demo/redo03_2.log'
ORA-00322: log 3 of thread 1 is not current copy
ORA-00312: online log 3 thread 1: '/ora01/oracle/oradata/demo/redo03.log'
SQL> recover database;
ORA-00283: recovery session canceled due to errors
ORA-00264: no recovery required
SQL> alter database drop logfile group 3;
alter database drop logfile group 3
*
ERROR at line 1:
ORA-01623: log 3 is current log for instance demo (thread 1) - cannot drop
ORA-00312: online log 3 thread 1: '/ora01/oracle/oradata/demo/redo03.log'
ORA-00312: online log 3 thread 1: '/ora01/oracle/oradata/demo/redo03_2.log'
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel
--------
请问我要如何操作才能成功恢复打开数据库?
待复,感谢!
[解决办法]
alter system archive log current这个命令也行 RAC可以用这个归档所有实例 单实例就没差别
[解决办法]
可以尝试,如果不行,再使用其他方法
