Forum Discussion

sym_biosis's avatar
sym_biosis
Level 4
12 years ago
Solved

Oracle database recovery

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 ?

7.1.x and Earlier
Agent for Oracle on Windows or Linux Servers
Agents
Backing Up
Backup and Recovery
Linux
NetBackup
Recovering
Restore
  • Yasuhisa_Ishika's avatar
    Yasuhisa_Ishika
    12 years ago

    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

4 Replies

  • Marianne's avatar
    Marianne
    Level 6
    12 years ago

    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's avatar
    sym_biosis
    Level 4
    12 years ago

    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's avatar
    jim_dalton
    Level 6
    12 years ago

    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's avatar
    Yasuhisa_Ishika
    Level 6
    12 years ago

    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