Home » RDBMS Server » Backup & Recovery » ORA-01033 - Oracle Initialization in Progress (Oracle 9i)
ORA-01033 - Oracle Initialization in Progress [message #349205] Fri, 19 September 2008 05:51 Go to next message
mohib123
Messages: 2
Registered: September 2008
Junior Member
Please tell me the solution. I am using oracle 9i. When I go to sqlplus to connect database, so message occurs as "ORACLE initialization or shutdown in progress".
I did following steps as:

sqlplus
SQL>connect sys/manager as sysdba;
SQL>shutdown

ORA-01109: database not open

Database dismounted.
ORACLE instance shut down.

SQL>startup

ORACLE instance started.

Total System Global Area 118255568 bytes
Fixed Size 282576 bytes
Variable Size 83886080 bytes
Database Buffers 33554432 bytes
Redo Buffers 532480 bytes
Database mounted.
ORA-00322: log 2 of thread 1 is not current copy
ORA-00312: online log 2 thread 1: 'D:\ORACLE\ORADATA\CLIENTS\REDO02.LOG'


Can anyone help me that why the errors mentioned in bold text are appearing and why isn't the database opened. Please tell me the steps of its resolution so that I can connect database, because it has precious and important data. I would appreciate and be thankful for your help and guidance.


Thanks

Mohib
Re: ORA-01033 - Oracle Initialization in Progress [message #349212 is a reply to message #349205] Fri, 19 September 2008 06:06 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ORA-00322: log %s of thread %s is not current copy
 *Cause:  Check of log file header at database open found that an online
          log appears to be an incorrectly restored backup.
 *Action: Restore correct file or reset logs.

Regards
Michel
Re: ORA-01033 - Oracle Initialization in Progress [message #349508 is a reply to message #349212] Mon, 22 September 2008 02:08 Go to previous messageGo to next message
mohib123
Messages: 2
Registered: September 2008
Junior Member
Thanks for reply.

Please tell me the steps how to reset logs ?

I have no backup of log file.
Re: ORA-01033 - Oracle Initialization in Progress [message #349533 is a reply to message #349508] Mon, 22 September 2008 02:44 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Try:
alter database clear logfile 2;
alter database open reset logs;

If you are lucky this will work.

Regards
Michel
Previous Topic: Script for Backup
Next Topic: Extract archivelog from backupset.
Goto Forum:
  


Current Time: Sun Dec 04 10:49:17 CST 2016

Total time taken to generate the page: 0.06390 seconds