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.
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: nbumasterOra_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
No comments:
Post a Comment