OraFAQ Forum: Backup & Recovery » Database not Open

Home » RDBMS Server » Backup & Recovery » Database not Open (Windows )

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

Database not Open [message #490462]

Tue, 25 January 2011 04:00

maniatniit
Messages: 49
Registered: June 2010
Location: Mumbai

Member

SQL> alter database mount;

Database altered.

SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01139: RESETLOGS option only valid after an incomplete database recovery
===============================================================

Please Help...

Thanks
Manish H

Report message to a moderator

Re: Database not Open [message #490467 is a reply to message #490462]

Tue, 25 January 2011 04:13

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

Senior Member
Account Moderator

Remove "resetlogs".

Regards
Michel

Report message to a moderator

Re: Database not Open [message #490471 is a reply to message #490467]

Tue, 25 January 2011 04:19

maniatniit
Messages: 49
Registered: June 2010
Location: Mumbai

Member

SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open

SQL> alter database open NORESETLOGS;
alter database open NORESETLOGS
*
ERROR at line 1:
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: 'D:\ORACLE\ORADATA\RBC10\SYSTEM01.DBF'
==============================================================

Please Help

Report message to a moderator

Re: Database not Open [message #490481 is a reply to message #490471]

Tue, 25 January 2011 05:02

jayraj
Messages: 11
Registered: January 2011
Location: Mumbai

Junior Member

alter database mount;
recover database;
alter database open;

Report message to a moderator

Re: Database not Open [message #490488 is a reply to message #490481]

Tue, 25 January 2011 05:11

maniatniit
Messages: 49
Registered: June 2010
Location: Mumbai

Member

This is not working

Report message to a moderator

Re: Database not Open [message #490491 is a reply to message #490488]

Tue, 25 January 2011 05:14

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

Senior Member
Account Moderator

Quote:

This is not working

This is very useful to help you.
As well was very useful your first post to know that you were in the middle of a recovery.
Keep hiding the information and you will keep to be on your own.

Regards
Michel

Report message to a moderator

Previous Topic:	Rman backup status
Next Topic:	Restore RMAN backup of database to a new database (merged)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Nov 21 21:13:40 CST 2024