Home » RDBMS Server » Backup & Recovery » Database needs recovery (3 merged)
Database needs recovery (3 merged) [message #280950] Thu, 15 November 2007 04:26 Go to next message
Toti
Messages: 6
Registered: November 2007
Junior Member

When I start my database , I have this message ORA 01033
ORA [message #280954 is a reply to message #280950] Thu, 15 November 2007 04:29 Go to previous messageGo to next message
Toti
Messages: 6
Registered: November 2007
Junior Member

When I startup my database,I take this message:
ERROR at line 1:
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: 'C:\ORACLE\PRODUCT\10.2.0\ORADATA\PRI1\SYSTEM01.DBF'

Re: ORA [message #280969 is a reply to message #280954] Thu, 15 November 2007 05:03 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
So do recovery.

Regards
Michel
Re: Ora 01033 [message #280970 is a reply to message #280950] Thu, 15 November 2007 05:04 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ORA-01033: ORACLE initialization or shutdown in progress
 *Cause: An attempt was made to log on while Oracle is being started up
         or shutdown.
 *Action: Wait a few minutes. Then retry the operation.

Wait for the database is open.

Regards
Michel
Re: ORA [message #280993 is a reply to message #280969] Thu, 15 November 2007 06:19 Go to previous messageGo to next message
Toti
Messages: 6
Registered: November 2007
Junior Member

Can you explain how can I do recovery,


Thanks...
Re: Ora 01033 [message #280994 is a reply to message #280970] Thu, 15 November 2007 06:23 Go to previous messageGo to next message
Toti
Messages: 6
Registered: November 2007
Junior Member

I wait 1 day but nothing,

ora00283,00322,00312 [message #280998 is a reply to message #280950] Thu, 15 November 2007 06:29 Go to previous messageGo to next message
Toti
Messages: 6
Registered: November 2007
Junior Member

SQL> RECOVER DATABASE , I take this message

ORA-00283:recovery session canceled due to errors
ORA-00322:log 3 of thread 1 is not current copy
ORA-00312:online log 3 thread 1:'C:\ORACLE\PRODUCT\10.2.0\ORADATA\PRI1\REDO03.LOG'


What to do now , can you explain because I am new in oracle.

Thanks
Re: Ora 01033 [message #281002 is a reply to message #280994] Thu, 15 November 2007 06:38 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
What does it say in the Alert.log file?
Re: Ora 01033 [message #281007 is a reply to message #280994] Thu, 15 November 2007 06:53 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
This is because (from your other post) your database wait for recovery to open.

Time to merge the three posts.

Regards
Michel

[Updated on: Thu, 15 November 2007 06:58]

Report message to a moderator

Re: ora00283,00322,00312 [message #281012 is a reply to message #280998] Thu, 15 November 2007 07:00 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
If you are so new either find a DBA or drop and recreate the database, this one is crambling.

Regards
Michel
Re: Database needs recovery (3 merged) [message #281527 is a reply to message #280950] Sat, 17 November 2007 22:28 Go to previous message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Do an incomplete recovery. Smile
Previous Topic: backup archivelog all delete input
Next Topic: Oracle Rman Incremental Backup
Goto Forum:
  


Current Time: Wed Dec 07 20:14:17 CST 2016

Total time taken to generate the page: 0.18398 seconds