Chat now with support
Chat with Support

NetVault Plug-in for Oracle 12.2 - User Guide

Introducing Quest® NetVault® Backup Plug-in  for Oracle Defining a backup strategy Installing and removing the plug-in Configuring the plug-in Backing up data Using the Oracle Flashback Database Restoring data
Restoring and recovering data: an overview Performing User Managed restores Using advanced User Managed restore procedures Performing RMAN restores Using RMAN types of recovery in a non-RAC environment Using advanced procedures with RMAN restores
Maintaining the Recovery Catalog Using the RMAN CLI Using the Plug-in with Oracle RAC Using the Plug-in in a failover cluster environment Using the plug-in with Oracle Data Guard Using the plug-in with Oracle Container Databases (CDBs) and Pluggable Databases (PDBs) Troubleshooting

Recovering individual datafiles and tablespaces to the same server

This type of recovery is performed when the database is open, but some of the datafiles are damaged. This recovery is useful when you want to recover the damaged tablespace, while leaving the database open so that the rest of the database remains available. You can only perform Complete Recovery when restoring and recovering individual datafiles or tablespaces. PIT Recovery is not available for individual datafiles or tablespaces. Enabling PIT Recovery causes the restore job to fail. Following is an overview of the process to recover individual datafiles or tablespaces:

1
On the Create Selection Set page, select the damaged datafiles or tablespaces from the latest available backup of the tablespace, and click Edit Plugin Options.
2
Click the Restore Options tab, and select the Alter Tablespaces Offline Before Restore and the Alter Tablespaces Online After Restore options.
3
On the Perform Recovery tab, select the applicable options:
•
To recover the tablespace to the current time, that is, last committed transaction available in the archive and online redo logs, select the Perform Complete Recovery option.
•
If you do not want to perform any recovery, select the Do Not Perform Recovery option.
 
* 
NOTE: If you select the Perform Database Point in Time Recovery option, the restore job fails.
•
To delete the restored archive logs that Oracle deems unnecessary, select the Delete Restored Archive Logs No Longer Needed option.
4
Complete the Target Client, Schedule, and Advanced Options tabs, and submit the job.
RMAN automatically chooses the best available Full, Incremental, or Archive Log backups and restore and recover the tablespace.

Recovering Whole Database to same server

This type of recovery is performed when the current Control File and SPFILE are intact but all the datafiles are damaged or lost. You can perform a Complete Recovery or recover the database to a specific point. Following is an overview of the process to recover the whole database, which must be performed when the database is in a MOUNT state:

1
On the Create Restore Job — Choose Saveset page, find the latest available backup that included all the tablespaces, and click Next.
2
On the Create Selection Set page, navigate to the source NetVault Backup Client and database, select the Whole Database node, and click Edit Plugin Options.
3
Click the Restore Options tab, and select the applicable options:
•
To mount the database before the performing the restore, select Mount Database Before Restore.
•
To shut down the database automatically before mounting the database, select Shutdown Abort Database First.
•
To include read-only datafiles in the restore, select Check Read-Only Datafiles and Restore if Necessary.
4
To perform recovery on the database, that is, to reconstruct the database up to the current or specified point, select one of the following options on the Perform Recovery tab:
•
Perform Complete Recovery: Recovers the database to the current time, that is, to the last committed transaction available in the archived and online redo logs.
•
Perform Point-in-Time Recovery: Recovers the database to a specific point whether it be a specific time, log sequence number, or SCN.
5
On the Perform Recovery tab, select these additional options, if applicable:
•
To include read-only datafiles in the recovery process, select Check Read-Only Datafiles and Recover if Not Current. The read-only files are included only if they are needed to complete recovery. If they are not damaged, RMAN omits them.
•
To delete the restored archive logs that Oracle deems unnecessary, select Delete Archive Logs No Longer Needed.
6
On the Post Recovery tab, select Open Database after Recovery and Read Write and Reset Logs to open the database automatically in read-write mode and reset the online logs.
7
Complete the Target Client, Schedule, and Advanced Options tabs, and submit the job.
RMAN automatically chooses the best available full, incremental, or Archived Log backups and restore and recover the database.
 
* 
IMPORTANT: After completing a restore of the Whole Database, Quest recommends that you perform a Full or Incremental Level 0 backup with the database selected on the Create Selection Set page.

Performing disaster recovery with RMAN

Disaster recovery includes the restore and recovery of a database after the loss of the entire target database, all current Control Files, all online redo log files, and all parameter files. It is also assumed that the FRA has been lost. To perform a disaster recovery, the minimum required set of backups includes backups of all the datafiles, some archived redo logs generated after the time of the backup, and at least one Autobackup of the Control File.

If your goal is to create a copy of your target database for ongoing use on a new host, do not use these procedures. Instead, use the Duplicate Database backup type, which is designed for this purpose. For more information, see Duplicate Database backup.

 
* 
CAUTION: To avoid overwriting the database and losing data, use caution when selecting any of the options described in the following topics and before performing disaster recovery.

The following methods are available for performing a disaster recovery:

•
Using the Stepwise Disaster Recovery process
•
Disaster recovery to same server
•
Retrieving a Control File manually
Important notes

When performing a disaster recovery of any kind, be aware of the following:

•
When performing a test recovery, do not connect to the Recovery Catalog during datafile restoration. Otherwise, RMAN records information about the restored datafiles to the Recovery Catalog. This recording interferes with future attempts to restore and recover the primary database. If you must use a Recovery Catalog because the Control File is not large enough to contain the RMAN repository data on all the backups that you need to restore, export the catalog. After exporting the catalog, import it into a different schema or database, and use the copied Recovery Catalog for the test restore. Otherwise, the catalog considers the restored database as the current target database.
•
Using a disaster recovery procedure in an Oracle Database environment that is not intended for disaster recovery might result in data loss in the database. Do not use a disaster recovery procedure to restore or recover individual datafiles or archive logs, or if you only intend to restore an Oracle Database SPFILE or a Control File.
•
Perform a disaster recovery only when it involves the whole database, SPFILE, and Control File. Existing data might be lost in the database, because a disaster recovery procedure overwrites it.
•
The Stepwise Disaster Recovery feature issues commands that include a small subset of the options available in an Oracle Database Server to perform a disaster recovery. For more advanced options, or a targeted disaster recovery, Quest recommends that you use the plug-in's documented RMAN CLI procedures. Because the Stepwise Disaster Recovery feature does not use the full range of recovery options, it might not complete successfully. If not, use the RMAN CLI process to perform the recovery.

Using the Stepwise Disaster Recovery process

This process runs a restore of the Control File from an Autobackup and restores the database datafiles using the same restore task. If you use this process, be aware of the following:

•
Objects selected on the Create Selection Set page are ignored.
•
All other restore- and recovery-related options are ignored.
•
Only the options selected on the Stepwise Disaster Recovery tab are run.
To use Stepwise Disaster Recovery
1
In the Navigation pane, click Create Restore Job.
2
On the Create Restore Job — Choose Saveset page, select Plug‑in for Oracle from the Plugin Type list.
3
To filter the items displayed in the saveset table further, use the Client, Date, and Job ID lists.
The table displays the saveset name (job title and saveset ID), creation date and time, and size. By default, the list is sorted alphabetically by saveset name.
4
In the saveset table, select the applicable item.
When you select a saveset, the following details are displayed in the Saveset Information area: Job ID, job title, server name, client name, plug-in name, saveset date and time, retirement setting, Incremental Backup or not, Archive or not, and saveset size.
5
Click Next.
6
On the Create Selection Set page, select any item.
As explained earlier, selections on this page are ignored for this process.
7
Click Edit Plugin Options, and then click the Stepwise Disaster Recovery tab.
8
Select the Perform the following Step-by-Step Disaster Recovery option, and then select the applicable suboptions:
•
Set Dbid: If you want to specify the DBID, select this option. The plug-in automatically enters the DBID of the Oracle Database for which the backup was taken in this field. The DBID is needed when a parameter file or SPFILE is not available to start the Oracle Database in a NOMOUNT state.
•
Restore Spfile from Autobackup; Look Back Max Days: If the Oracle Control File Autobackup option was enabled in your scheduled backups and you want to restore the SPFILE from an Autobackup, select this option. If Oracle Control File Autobackup was not enabled, you cannot restore the SPFILE from an Autobackup; for more information, see Enabling Control File Autobackups. By default, this option looks for Autobackups in the last seven days; update it as applicable. This option issues the following RMAN commands:
STARTUP NOMOUNT;
restore spfile from autobackup maxdays <NumberOfDays>;
•
Restore Controlfile from Autobackup; Look Back Max Days: If the Oracle Control File Autobackup option was enabled in your scheduled backups and you want to restore the Control File from an Autobackup, select this option. If Oracle Control File Autobackup was not enabled, you cannot restore the Control File from an Autobackup; for more information, see Enabling Control File Autobackups. By default, this option looks for Autobackups in the last seven days; update it as applicable. This option issues the following RMAN commands:
STARTUP FORCE NOMOUNT;
restore controlfile from autobackup maxdays <NumberOfDays>;
•
Restore Database: If you want to restore all datafiles included in the Oracle Database, select this option. A RESTORE DATABASE command attempts to restore all the datafiles in the Oracle database. This option issues the following RMAN command:
RESTORE DATABASE;
•
Recover Database: If you want to recover all datafiles included in the Oracle Database, select this option. A RECOVER DATABASE command attempts to recover all the datafiles in the Oracle database. This recovery might include automatically restoring and applying archived transaction logs. This option issues the following RMAN command:
RECOVER DATABASE;
•
Alter Database Open Resetlogs: If you want to open the database with the RESETLOGS option, select this option. This option issues the following SQL*Plus command:
ALTER DATABASE OPEN RESETLOGS;
 
* 
NOTE: With the database restored, you have the option of opening an RMAN CLI prompt and issuing the recovery commands from the prompt. This option eliminates the need to select the Recover Database and Alter Database Open Resetlogs options and lets you issue advanced recovery options.
9
Complete the steps in Finalizing and submitting the job.
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating