Oracle database recovery

[sym_biosis]

Situation -

1. We backed up an Oracle DB using RMAN and NB Oracle agent.

2. RMAN catalog got deleted.

3. Backup is still there under Netbackup as corresponding NB catalog images are not expired yet.

Problem -

How do I recover the oracle database now ? Is there at all a way ?

[Marianne]

Hopefully you have protected the RMAN catalog with an offline backup of the database.

I cannot see any way to restore without the RMAN catalog.

Best to contact Oracle for assistance if you cannot recover the RMAN catalog.

[sym_biosis]

Is there a way I can restore the corresponding backup images to any disk path ?

We take disk backups, I hope I can copy them from there atleast if can't restore.

[jim_dalton]

Should be possible I reckon: you got a good idea whats what , just need to get it off the media server.

Use bplist on the server they were carried out on (makes life simpler) to work your way to the images ( -t 4 is Oracle type) , narrow it down with dates, policy etc and then give it / as the path.The files for Oracle are internally generated hence / (eg control files are done via /ctrl-sxxxxxx-p1-tyyyy, archived redos via /arch.....blahblah: Im sure the names are meaningful to someone)

Then I think you should be able to run a bprestore along similar lines. Never tried it but thats where I'd head.

Dont forget to extend the images to infinite or somesuch otherwise you might end up with them expiring ...oops!

Jim

[Yasuhisa_Ishika · Accepted solution]

As per this Oracle doc, you can recover DB with RMAN repository in the control files. If these are alive, yoi can recover DB as normal.

http://docs.oracle.com/cd/B19306_01/backup.102/b14192/maint001.htm

otherwise, if control files have gone, identify backup handle of control file backup using bplist command(as above), and restore control file from this backup handle.

I wrote some relevant comments here. Have a look for assistance.

https://www-secure.symantec.com/connect/forums/oracle-restore-file-system#comment-7106611

https://www-secure.symantec.com/connect/forums/restore-sp-file-auto-backup-oracle#comment-8584951