OraFAQ Forum: Backup & Recovery » ORA-01033 - Oracle Initialization in Progress

Home » RDBMS Server » Backup & Recovery » ORA-01033 - Oracle Initialization in Progress (Oracle 9i)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-01033 - Oracle Initialization in Progress [message #349205]

Fri, 19 September 2008 05:51

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

Report message to a moderator

Re: ORA-01033 - Oracle Initialization in Progress [message #349212 is a reply to message #349205]

Fri, 19 September 2008 06:06

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: ORA-01033 - Oracle Initialization in Progress [message #349508 is a reply to message #349212]

Mon, 22 September 2008 02:08

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.

Report message to a moderator

Re: ORA-01033 - Oracle Initialization in Progress [message #349533 is a reply to message #349508]

Mon, 22 September 2008 02:44

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Try:
alter database clear logfile 2;
alter database open reset logs;

If you are lucky this will work.

Regards
Michel

Report message to a moderator

Previous Topic:	Script for Backup
Next Topic:	Extract archivelog from backupset.

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 22 12:52:04 CST 2024