Sunday, April 12, 2020

NetBackup - Performing ORACLE Database restores using RMAN Client




Overview of using NetBackup for Oracle

The NetBackup graphical user interfaces and command line interfaces let you perform Oracle backup and recovery operations using Oracle RMAN utilities. You can also use the Oracle Enterprise Manager to perform Oracle backup and recovery operations. The Oracle RMAN command line interface is also used to maintain and query the RMAN repository.


About NetBackup for Oracle restores

NetBackup for Oracle includes a recovery wizard that solicits information from the user about the desired RMAN restore and recovery operations. The wizard uses the information to create a template.
The recovery wizard saves a recovery template locally in a user-specified location on the NetBackup client. Recovery templates are not stored on the master server because recovery is always user directed, not scheduled.

Because recovery can be a complex process, it might be necessary to perform manual steps as part of the operation.

The wizard does not restore control files.

Before going for restore, ensure the backup has completed with status code 0.


In this example I have created OIP (ex: orap1).

For further information click :  ORACLE RMAN BACKUP

Run a manual backup to test the restore.




Oracle database backup job started successfully.




In a Detailed job status, you can see RMAN commands are using to take a backup of oracle database.




Backup job completed successfully.






Performing Restore:

You can use NetBackup Client restore wizard to restore the Oracle DB.







Restoring DB using RMAN Client:

Use the bplist command to list oracle backups for the particular client.

You can use this command in NetBackup Master server or Client.
 






For testing oracle restore scenario, I had shutdown the ORCL database and rename the control file.





Start the database with nomount option.




Using RMAN Client, connect to Target and Catalog Databases.


> rman target sys/password catalog rman/password@catalogdb
Connected to both the databases successfully.




Run the following RMAN command to restore the Control file.

Master Server Name: nbumaster
Ora_client : windbsr



It is restoring the control file.


Control file restored successfully.





Use the following command to restore the database and recover the database.




Reading from the backup piece and restore starts.




Restore job completed successfully.




Then open the Database to access.




Now you can login to sqlplus and access the database.




Same as you can run a backup also using RMAN Client.

You need Default Application schedule is mandatory.

In this example I have used the following:


Master : nbumaster  

ORA_Client: windbsr   

ORA_Policy: orap2








Backup job completed successfully.






No comments:

Post a Comment