ERROR: ORA-01033:ORACLE initialization or shutdown in progress. $ lsnrctl statusConnecting to (ADDRESS=(PROTOCOL=tcp)(PORT=1521))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
HPUX Error: 239: Connection refused
SQL> startup
ORACLE instance started.Database mounted.
ORA-00368: checksum error in redo log block
ORA-00353: log corruption near block 55216 change 834662786 time 01/10/2010
19:10:10
ORA-00312: online log 1 thread 1: '/qscaria_3/arial1a.log
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
HPUX Error: 239: Connection refused
SQL> startup
ORACLE instance started.Database mounted.
ORA-00368: checksum error in redo log block
ORA-00353: log corruption near block 55216 change 834662786 time 01/10/2010
19:10:10
ORA-00312: online log 1 thread 1: '/qscaria_3/arial1a.log
Cause: The redo block indicated by the accompanying error, is not vaild. It has a checksum that does not match the block contents.
Action: Restore correct file or reset logs.
ORA-00353: log corruption near block string change string time string
Cause: Some type of redo log corruption has been discovered. This error describes the location of the corruption. Accompanying errors describe the type of corruption.
Action: Do recovery with a good version of the log or do incomplete recovery up to the indicated change or time.
reset 一下redo log 看看...
还有你的监听也有问题..------------------------------------------------------------------------------
Blog: http://blog.csdn.net/tianlesoftware
网上资源: http://tianlesoftware.download.csdn.net
相关视频:http://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx
Q Q 群:62697716
STATUS of the LISTENER
------------------------
Alias aaaTrace Level off
Security OFF
SNMP OFF
Listener Parameter File /qscora/product/9.2.0/network/admin/listener.ora
Listener Log File /qscora/product/9.2.0/network/log/arial.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=aaa.world)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=aaa)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=host)(PORT=1526)))
Services Summary...
Service "aaa.world" has 1 instance(s).
Instance "aaa", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
1.
先做一下冷备份。
2。
设置一下参数 _allow_resetlogs_corruption = true ;
如果是spfile 修改spfile 就行了
3.
startup mount
4.
recover database using backup controlfile until cancel ;
接着cancel
5.
alter database open resetlogs;
如果能打开数据库就行。还不行。
shutdown immediate;
startup;