OraFAQ Forum: Backup & Recovery » Fail to open database after incomplete media recovery

Home » RDBMS Server » Backup & Recovery » Fail to open database after incomplete media recovery (oracle 11.2.0,1,0, windows 7)

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

Fail to open database after incomplete media recovery [message #587256]

Thu, 13 June 2013 09:00

zeeshan047
Messages: 99
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]

Attachment: alert_orcl.log
(Size: 300.67KB, Downloaded 2228 times)

Report message to a moderator

Re: Fail to open database after incomplete media recovery [message #587258 is a reply to message #587256]

Thu, 13 June 2013 09:10

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

Senior Member
Account Moderator

Post the log of the RMAN session including the commands you executed.

Regards
Michel

Report message to a moderator

Re: Fail to open database after incomplete media recovery [message #587261 is a reply to message #587258]

Thu, 13 June 2013 09:36

zeeshan047
Messages: 99
Registered: June 2010
Location: PAKISTAN

Member

Please find attach file.

Thanks.

Attachment: rman.log
(Size: 15.34KB, Downloaded 2599 times)

Report message to a moderator

Re: Fail to open database after incomplete media recovery [message #587269 is a reply to message #587261]

Thu, 13 June 2013 09:59

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

Senior Member
Account Moderator

You cannot open, the restore operation failed.

Regards
Michel

Report message to a moderator

Previous Topic:	RMAN Error..
Next Topic:	Backup and restore on different server

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 23 05:58:38 CST 2024