--数据库启动时报错
SQL> startup
ORACLE instance started.Total System Global Area 264241152 bytes
Fixed Size 1218868 bytes
Variable Size 176162508 bytes
Database Buffers 83886080 bytes
Redo Buffers 2973696 bytes
Database mounted.
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
SQL> conn cms0412_cn/cms0412_cn;
ERROR:
ORA-01033: ORACLE initialization or shutdown in progress
Warning: You are no longer connected to ORACLE.
--查看日志
SQL> select * from v$log; GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS
---------- ---------- ---------- ---------- ---------- --- ----------------
FIRST_CHANGE# FIRST_TIME
------------- --------------
1 1 0 52428800 1 NO UNUSED
114362466 26-4?? -10 3 1 25 52428800 1 NO INACTIVE
114342189 26-4?? -10 2 1 27 52428800 1 NO CURRENT
114393211 28-4?? -10--归档日志文件恢复时出错
alter database clear logfile unarchived group 1;
*
ERROR at line 1:
ORA-02236: invalid file name
希望大家帮忙分析以上错误原因!
SQL> startup
ORACLE instance started.Total System Global Area 264241152 bytes
Fixed Size 1218868 bytes
Variable Size 176162508 bytes
Database Buffers 83886080 bytes
Redo Buffers 2973696 bytes
Database mounted.
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
SQL> conn cms0412_cn/cms0412_cn;
ERROR:
ORA-01033: ORACLE initialization or shutdown in progress
Warning: You are no longer connected to ORACLE.
--查看日志
SQL> select * from v$log; GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS
---------- ---------- ---------- ---------- ---------- --- ----------------
FIRST_CHANGE# FIRST_TIME
------------- --------------
1 1 0 52428800 1 NO UNUSED
114362466 26-4?? -10 3 1 25 52428800 1 NO INACTIVE
114342189 26-4?? -10 2 1 27 52428800 1 NO CURRENT
114393211 28-4?? -10--归档日志文件恢复时出错
alter database clear logfile unarchived group 1;
*
ERROR at line 1:
ORA-02236: invalid file name
希望大家帮忙分析以上错误原因!
alter database open resetlogs/noresetlogs
的方式打开。alter database clear unarchived logfile group n;
是用来处理未归档的在线日志损坏,
不知道你情况怎么样,用在这里适不适合
alter database open resetlogs;
以后启动数据库的时候只要startup就行了吗?
不用再:startup mount;
alter database open resetlogs; 了吧!
oracle QQ群:54775466
期待您的一起探讨
欢迎爱好者入群学习