OraFAQ Forum: Backup & Recovery » How to recover DB using RMAN if my target and catalog both are lost?

Home » RDBMS Server » Backup & Recovery » How to recover DB using RMAN if my target and catalog both are lost? (Oracle 11.2.0.1)

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

How to recover DB using RMAN if my target and catalog both are lost? [message #461400]

Thu, 17 June 2010 13:18

ridhi_sundar
Messages: 184
Registered: November 2007
Location: Bangalore

Senior Member

Hi Friends

I lost my target and catalog DB both. But I have the rman full backup with controlfile backup and archive logs. Is it possible to recover the DB using this backup?

Thanks
Ridhi Sundar

Report message to a moderator

Re: How to recover DB using RMAN if my target and catalog both are lost? [message #461401 is a reply to message #461400]

Thu, 17 June 2010 13:22

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Yes. Required information would be still available in controlfile.
First restore the controlfile and proceed.
http://download.oracle.com/docs/cd/B12037_01/server.101/b10734/rcmrecov.htm#1006329

[Updated on: Thu, 17 June 2010 13:54]

Report message to a moderator

Re: How to recover DB using RMAN if my target and catalog both are lost? [message #461413 is a reply to message #461401]

Thu, 17 June 2010 14:49

ridhi_sundar
Messages: 184
Registered: November 2007
Location: Bangalore

Senior Member

Thanks a lot Mahesh. I got the point.

Instead of
RESTORE DATABASE UNTIL SEQUENCE 13243;
RECOVER DATABASE UNTIL SEQUENCE 13243;

can I use

RESTORE DATABASE;
RECOVER DATABASE;

without scn?

How can I know the scn to be given there?

Thanks
RIdhi Sundar

Report message to a moderator

Re: How to recover DB using RMAN if my target and catalog both are lost? [message #463401 is a reply to message #461400]

Thu, 01 July 2010 03:20

rk44
Messages: 18
Registered: June 2010

Junior Member

u can restore and recover DB even though your target bckps r lost.

go to target side:

keep your DB in mount stage

come to os.level and type the following

rman target /

rman>restore controlfile from 'path';

path:u've to give location of you are controlfile and last conrolfile bckup.

rman>restore database
rman>recover database

Report message to a moderator