cancel
Showing results for 
Search instead for 
Did you mean: 

Oracle Backup Questions

BTLOMS
Level 5

Netbackup 7.5.05

 

If I backup Oracle using an RMAN script, why am I not able to browse the individual files for restore? I need to be able to browse and choose the files I want to restore, but I am unable to. However I can restore the entire backup using the RMAN script.

 

thanks,

 

 

1 ACCEPTED SOLUTION

Accepted Solutions

RamNagalla
Moderator
Moderator
Partner    VIP    Certified

hi ,

check the below (page number 92) from Netbackup 7.5 Oracle admin guide..

Using the recovery wizard
When you are ready to perform a recovery, follow these steps to create and run
a template with the recovery wizard.
To use the recovery wizard
1 Open the Backup, Archive, and Restore interface.
2 Select the Restore operation:
■ On Windows, click Select for Restore
■ On UNIX and Linux, click on the Restore Files tab. In the Restore Type
list, select Normal Backups.
3 In the left pane, select the Oracle instance.
4 In the right pane, select the database object(s) (data files, tablespaces) you
want to recover.
If you select the Oracle instance, the wizard recovers the entire database
using RMAN.
5 Click Actions > Restore.
Enter information about the recovery operation you want to perform in the
screens that the NetBackup for Oracle recovery wizard displays.
The screens are as follows:
■ Welcome
■ Target Database Logon Credentials
■ Recovery Catalog Logon Credentials
■ Recovery Options
■ Restore Options
■ Recover Limits
■ Database State
If you need an explanation of any of the fields on the wizard screens, click
Help on the wizard screen.
6 Whenyou have completed the wizard, the Selection Summary screen displays
the summary of the recovery template. Review this summary. You can choose
to run the template immediately after the wizard finishes or save the template
locally, or both.
If you need an explanation of any of the fields on the wizard panels, click
Help on the wizard panel.
7 Click Finish to run, to save, or to run and save the recovery template

View solution in original post

3 REPLIES 3

RamNagalla
Moderator
Moderator
Partner    VIP    Certified

hi ,

check the below (page number 92) from Netbackup 7.5 Oracle admin guide..

Using the recovery wizard
When you are ready to perform a recovery, follow these steps to create and run
a template with the recovery wizard.
To use the recovery wizard
1 Open the Backup, Archive, and Restore interface.
2 Select the Restore operation:
■ On Windows, click Select for Restore
■ On UNIX and Linux, click on the Restore Files tab. In the Restore Type
list, select Normal Backups.
3 In the left pane, select the Oracle instance.
4 In the right pane, select the database object(s) (data files, tablespaces) you
want to recover.
If you select the Oracle instance, the wizard recovers the entire database
using RMAN.
5 Click Actions > Restore.
Enter information about the recovery operation you want to perform in the
screens that the NetBackup for Oracle recovery wizard displays.
The screens are as follows:
■ Welcome
■ Target Database Logon Credentials
■ Recovery Catalog Logon Credentials
■ Recovery Options
■ Restore Options
■ Recover Limits
■ Database State
If you need an explanation of any of the fields on the wizard screens, click
Help on the wizard screen.
6 Whenyou have completed the wizard, the Selection Summary screen displays
the summary of the recovery template. Review this summary. You can choose
to run the template immediately after the wizard finishes or save the template
locally, or both.
If you need an explanation of any of the fields on the wizard panels, click
Help on the wizard panel.
7 Click Finish to run, to save, or to run and save the recovery template

Marianne
Moderator
Moderator
Partner    VIP    Accredited Certified

Because backup was done with RMAN and Oracle policy type backups, it cannot be browsed like regular filesystem backup.

Please download the NBU for Oracle manual that Nagalla referenced above: 
http://www.symantec.com/docs/DOC5175 

You will also see in this manual how bplist command can be used to list/browse backups.

BTLOMS
Level 5

Thanks, this brings up an interesting observation that I noticed while doing the trials, currently every oracle database has its own individual rman repository stored as part of db, so if the whole database crashes the rman repository is also lost, then though we have backups on tape we will not be able to restore/recover without the rman repository, another option is to manually restore individual backups from tape and do the restore, with what you have mentioned that is also not possible.