Prior to using the NMDA Oracle recovery wizard in NMC, you must make sure that you meet the following requirements:
- You have created the NetWorker Client resource for the NMDA client by using NMC wizard.
- The Oracle client has performed backups, and they are in a browse-able state.
- Oracle database is in the appropriate Mount Mode as per Oracle documentation.
To restore and recover Oracle backups using NMC Recovery Wizard, follow the steps provided below:
1. Start the NetWorker Management Console software (NMC).
2. Open the Administration window:
A. In the Console window, click Enterprise.
B. In the left pane, select a NetWorker server in the Enterprise list.
C. In the right pane, select the application.
D. From the Enterprise menu, click Launch Application.
The Administration window appears as a separate application.
3. In the Administration window, click Protection.
4. In the Protection window, click Clients.
5. To start the wizard, right-click the NMDA client in the right pane, and select Recover.
6. On each wizard screen that appears, specify the required values for the RMAN script configuration.
7. Here are some of the main screen that you see: (depending on your selections, you may see other screens that are not covered here.)
A. Select the recovery hosts - This window enables you to select the source and destination hosts for the recovery configuration.
This window has the following elements:
- Source host - Enables you to select a source host for the recovery configuration.
- Destination host - Enables you to select a destination host to receive the recovered data.
- Available recovery types table - Summarizes the different types of recoveries that are available.(Make sure that you select Oracle from this list )
B. Specify the type of Oracle restore and recovery - This window allows you to specify the type of Oracle restore and recovery.
You can perform a restore and recovery to a duplicate database or perform a restore and recovery to the original database (in this example, we use the original database. )
C. Specify the Oracle information This window allows you to specify the oracle installation directory and target database credentials.
D. Select the data Type for the restore and recovery - This window enables you to specify if you want to restore and recover the database, or restore only specific archive redo logs (in this example, we select restore and recover the database. )
E. Select the Database Objects; this is a mandatory field. Specifies a list of database components to be in the restore and recovery.
- For a container database, specifies a list of pluggable databases and datafiles.
- For a non-container database, specifies a list of Oracle database objects in the target database.
Clear the checkboxes of components to be excluded from the restore and recovery.
You are asked at this stage if you want the Wizard to place the database in the Mount mode for you.(in this example, we will manually mount the target database )
And so, we select No and then click Next to continue to the next screen.
- To place the target database in mount mode:
- On the command line of the Database machine, run the following commands in sequence:
rman
connect target /
shutdown immediate;
startup mount;
F. Select the datafile locations(optional) - This window enables you to specify the new locations for the selected datafiles, to relocate the datfiles.
The Datafiles field is an optional field:
- The locations of datafiles in the restore (under New Location) can be either the same as or different from the locations in the original database.
G. Specify the Recovery options window allows you specify the RMAN restore and recovery options:
- Number of restore channels
- Open the database after the recovery
- Recovery Time Options
- Advanced Recovery Options (The NMDA Administration Guide and Release Notes provide the most up-to-date and complete list of the NMDA parameters.)
H. This window enables you to review and edit the RMAN Script (this optional )
This window has the following elements:
- Edit the RMAN recovery script - Optional field. Specifies that the RMAN script is to be modified directly on this page.
- RMAN Script Copy Options - Optional field. Specify the position to store the RMAN script.
- Save a copy of RMAN script - Optional field. If selected, the following two fields become editable to specify the location of the saved RMAN script.
- NetWorker client - Hostname of the NetWorker client to store the RMAN script. Select the hostname from the list.
- Script location and file name - Type a valid path or browse the file system to select and change the path of the RMAN script.
I. Obtain the volume information - This window enables you to determine the way of selecting the volumes required to perform the data recovery.
J. Perform the recovery - This window allows you to save the recovery configuration, start the recovery job immediately, schedule the recover job, and specify how long the recover configuration remains available in the Recovery Wizard.
- After providing the Recovery name of this configuration and making your other selections, click on Run Recovery
8. You can select to start the restore and recovery immediately from the wizard or schedule the operation to start later.
In the wizard, you can access an existing recover configuration later or you can view the recovery results.
In NMC, click Recover on the Administration window toolbar to open the Recover window.
In the Configured Recovers pane, right-click the saved recover configuration and select one of the menu options:
- New Recover Select this option as another way to create a new recover configuration.
- Open Recover Select this option to view the recovery results.
- Recover Again Select this option to access an existing recover configuration. You can make changes and save the configuration with a new name if required.
Refer to this video:
You can also view this video on
YouTube .