Home » RDBMS Server » Backup & Recovery » Database not Open (Windows )
Database not Open [message #490462] Tue, 25 January 2011 04:00 Go to next message
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
Re: Database not Open [message #490467 is a reply to message #490462] Tue, 25 January 2011 04:13 Go to previous messageGo to next message
Michel Cadot
Messages: 67743
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Remove "resetlogs".

Regards
Michel
Re: Database not Open [message #490471 is a reply to message #490467] Tue, 25 January 2011 04:19 Go to previous messageGo to next message
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
Re: Database not Open [message #490481 is a reply to message #490471] Tue, 25 January 2011 05:02 Go to previous messageGo to next message
jayraj
Messages: 11
Registered: January 2011
Location: Mumbai
Junior Member
alter database mount;
recover database;
alter database open;

Re: Database not Open [message #490488 is a reply to message #490481] Tue, 25 January 2011 05:11 Go to previous messageGo to next message
maniatniit
Messages: 49
Registered: June 2010
Location: Mumbai
Member

This is not working
Re: Database not Open [message #490491 is a reply to message #490488] Tue, 25 January 2011 05:14 Go to previous message
Michel Cadot
Messages: 67743
Registered: March 2007
Location: Nanterre, France, http://...
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
Previous Topic: Rman backup status
Next Topic: Restore RMAN backup of database to a new database (merged)
Goto Forum:
  


Current Time: Sat Feb 27 01:25:30 CST 2021