Home » RDBMS Server » Backup & Recovery » Fail to open database after incomplete media recovery (oracle 11.2.0,1,0, windows 7)
Fail to open database after incomplete media recovery [message #587256] Thu, 13 June 2013 09:00 Go to next message
zeeshan047
Messages: 57
Registered: June 2010
Location: PAKISTAN
Member

hi,

i am using oracle 11.2.0.1.0. We have configured rman using repository catalog configure in another database. We have perform incomplete recovery to restore database to previous scn, but the database fail to open shown error message, how to open the database?

RMAN-00571, RMAN-00569,RMAN-03002,

ORA-01139: RESETLOGS option only valid after an incomplete database recovery

[code]

sql ) startup mount;

RMAN> run {

set until scn 1812690;

restore database;

recover database;

}

[code]
Re: Fail to open database after incomplete media recovery [message #587258 is a reply to message #587256] Thu, 13 June 2013 09:10 Go to previous messageGo to next message
Michel Cadot
Messages: 58612
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Post the log of the RMAN session including the commands you executed.

Regards
Michel
Re: Fail to open database after incomplete media recovery [message #587261 is a reply to message #587258] Thu, 13 June 2013 09:36 Go to previous messageGo to next message
zeeshan047
Messages: 57
Registered: June 2010
Location: PAKISTAN
Member

Please find attach file.

Thanks.
  • Attachment: rman.log
    (Size: 15.34KB, Downloaded 35 times)
Re: Fail to open database after incomplete media recovery [message #587269 is a reply to message #587261] Thu, 13 June 2013 09:59 Go to previous message
Michel Cadot
Messages: 58612
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You cannot open, the restore operation failed.

Regards
Michel
Previous Topic: RMAN Error..
Next Topic: Backup and restore on different server
Goto Forum:
  


Current Time: Tue Jul 29 17:07:56 CDT 2014

Total time taken to generate the page: 0.11491 seconds