Chat now with support
Chat with Support

NetVault Plug-in for Oracle 7.1 - User Guide

Introducing Dell™ 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-inin a failover cluster environment Using the plug-in with Oracle Data Guard Troubleshooting Glossary About Dell

Renaming or relocating the Archive Log Directory

When renaming an Archive Log Directory, all Archived Logs are restored to the directory specified.
To rename or relocate (or both) the Archive Log during restore
1
Complete the steps outlined in Preparing the database for recovery.
2
In the Navigation pane, click Create Restore Job, select Plug‑in for Oracle from the Plugin Type list.
3
In the saveset table, select the applicable item, and click Next.
For more information, see Selecting data for a restore.
4
On the Create Selection Set page, select the Archive Log Directory that you want to rename or relocate.
5
From the Actions list, select Rename.
6
In the Rename/Relocate dialog, enter the applicable information, and click Ok.
•
Rename – Enter the new name.
•
Relocate – Enter the new path.
The item is accompanied by the rename/relocate information in parenthesis.
7
If you want to overwrite existing files of the same name in the new or current location, complete the following steps:
a
On the Create Selection Set page, click Edit Plugin Options.
b
Click the Restore Options tab, select Allow Overwrite Existing Files, and click Ok.
8
Continue with the restore procedure as explained in Finalizing and submitting a job.
 
 
*IMPORTANT: When restoring some or all of the required archived redo log files to an alternate location, specify the location before media recovery by using the LOGSOURCE parameter of the SET statement in SQL*Plus.

Performing RMAN restores

A standard RMAN restore with Plug‑in for Oracle includes the following steps:
•
Selecting data for a restore
•
Setting restore options
•
Finalizing and submitting a job
Selecting data for a restore
To select data to restore
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.
The following table outlines the backup-type identifiers:
 
Table 3. Identifiers
Backup type
Backup type identifier
RMAN Full Database
RMAN FULL DB
RMAN Incremental Level 0
RMAN INCRMTAL LVL 0
RMAN Cumulative Incremental
RMAN CUML INCRMTAL
RMAN Differential Incremental
RMAN DIFF INCRMTAL
RMAN Archive Log
RMAN ARCHIVE LOG
RMAN Control File and Parameter File
RMAN CTRL PARM
RMAN Flash Recovery Area
RMAN FRA
RMAN Duplicate Database
RMAN DUPL DB
All other RMAN Backups
RMAN Backup
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, name of the NetVault Backup Server, name of the client from which the data was backed up, plug-in used to create the saveset, saveset creation date and time, saveset retirement setting, whether it is an Incremental Backup, whether it is an Archive, and saveset size.
5
To continue, click Next.
6
On the Create Selection Set page, with the Whole Database node and the other nodes based on the items selected for the backup displayed, select the applicable items:
•
Whole Database – Select this node if you want to Restore and/or Recover the entire database. With this option selected, you can perform the DBPITR based on SCN, LSN, or time to reconstruct the database up to the required point.
Note that selecting the All Tablespaces node or all the datafiles and tablespaces nodes is not equivalent to selecting this node.
•
Parameter File – Available only if the Control File Autobackup Enabled option is cleared on the Add (or Edit) Oracle Database dialog.
When restoring a parameter file, select the backup that contains the specific version of the Parameter File that you want. For example, the Parameter File is backed up weekly on Sunday night at 11 p.m. Assuming today is Thursday and you need to restore the Parameter File to the state it was on Tuesday at 6 p.m., select the Parameter File from the last backup that occurred before Tuesday at 6 p.m., which would be Sunday night’s backup at 11 p.m.
•
SPFILE – For restore purposes, a node SPFILE is available in the restore selections if the backup contents include the backup of the SPFILE. If selected, it restores the SPFILE using RMAN commands — in particular the RESTORE SPFILE command.
 
 
*NOTE: An SPFILE cannot be restored to overwrite a live SPFILE (for example, if the database was started using the SPFILE). However, it can be restored to a different location. Use the Restore Rename feature of NetVault Backup and input the full path (full directory path and file name) of the location to which to restore the SPFILE.
Unlike the loss of the Control File, the loss of the SPFILE does not cause the Oracle Instance to stop running immediately. The Oracle Instance may continue operating while it is not shut down. You can restore a backed-up SPFILE to an alternate location. After the Oracle Instance is shut down, you must restart the Oracle Instance using the restored SPFILE, or copy the restored SPFILE to the default location and then restart the Oracle Instance.
•
Control File – You cannot open this node further. Secondly, if a Recovery Catalog is not in use, you cannot restore it from the NetVault Backup WebUI. The restore will fail if you try to include Control File in a restore job, unless Use Catalog is enabled on the Recovery Catalog tab.
When restoring the Control File from Manual Backup, select the backup that contains the specific version of the Control File that you want. For example, Manual Backups of the Control File are performed nightly at 11 p.m. Assuming today is Thursday and you need to restore the Control File to the state it was on Tuesday at 6 p.m., select the Control File from the last backup that occurred before Tuesday at 6 p.m., which would be Monday night’s backup at 11 p.m.
•
All Tablespaces – Select this node to perform an All Tablespace restore where all the tablespaces are restored consecutively with the RMAN RESTORE DATAFILE command. Performing an All Tablespace restore requires the database to be in a MOUNT state.
•
Individual Tablespaces/Datafiles – Open the All Tablespaces node to reveal the tablespaces available for restoration. You can select individual or multiple tablespaces, or open the tablespace node and select individual datafiles. Restoring individual tablespaces or datafiles requires the tablespace to be OFFLINE during the restore and recovery process.
•
External Configuration Files – You can expand this node to reveal the Oracle Network Configuration and Oracle Password files available for restore. Select this node to restore all the available External Configuration Files, or open it and select individual files. The plug-in uses the Plug-in for FileSystem functionality to restore the Oracle Network Configuration and Oracle Password files.

Setting restore options

In this step, you specify whether you want to perform complete or PIT Recovery, and set the other restore options.
On the Create Selection Set page, click Edit Plugin Options, and then follow the steps outlined in the following sections:
•
Viewing the contents of backup pieces
•
Setting the Pre-Restore and general Restore Options
•
Setting recovery options
•
Setting Block Media Recovery options
•
Setting Post Recovery options
•
Setting Destination Details
•
Setting the Recovery Catalog details
•
Setting the Clone Database options
•
Setting Generate RMAN Script options
Viewing the contents of backup pieces
Before proceeding, you can view the contents of the various backup pieces in the selected backup set and see what each piece contains, the backup start and end time, datafile names, SCN range (including the low and high SCN), and the log sequence number of the archived redo logs. These details are displayed on the first tab, Backup Contents.

Setting the Pre-Restore and general Restore Options

To continue, click the Restore Options tab.
•
Pre-Restore Options – These options let you automatically prepare the database or tablespaces for the restore process during the plug-in’s restore job.
•
Whole Database Restore – Select this option if a complete database is being restored.
•
Tablespace/Datafile Restore – Select this option if individual or multiple tablespaces or datafiles are being restored.
•
Startup Database Nomount Before Restore – When restoring a Control File, the database must be in a NOMOUNT state. Select this option if you want the plug-in to put the database in a NOMOUNT state automatically before issuing the RMAN run block.
•
Mount Database Before Restore – When performing Whole Database or All Tablespaces restores, the database must be in a MOUNT state. Select this option if you want the plug-in to mount the database automatically before performing the restore and recovery. If this option is not selected, you must manually put the database in a MOUNT state before submitting the restore job to prevent the job from failing.
•
Shutdown Abort Database First – Available only when Mount Database Before Restore is selected. If the database is currently in an OPEN state, the database must be shut down before it can be opened in a MOUNT state. Select this option if you want the plug-in to execute a SHUTDOWN ABORT automatically before starting the database in a MOUNT state. If this option is not selected and the Mount Database Before Restore option is selected, the restore job will fail if you do not manually shut down the database before submitting the job.
•
Alter Tablespaces Offline Before Restore – When restoring individual tablespaces or datafiles, the tablespace must be offline before the restore is performed. Select this option if you want the plug-in to execute the ALTER TABLESPACE OFFLINE command automatically for each tablespace that is being restored.
•
Restore Options – These options pertain to the restore phase of Oracle’s restore and recovery process.
•
Alter Tablespaces Online After Restore – When restoring individual tablespaces and datafiles, the tablespace must be returned to an online state after the restore and recovery is completed. Select this option if you want the plug-in to execute the ALTER TABLESPACE ONLINE command automatically after the selected tablespaces are restored and recovered. Note that this option enforces a recovery of the selected tablespace regardless of whether Perform Recovery is selected.
•
Include Recover Tablespace Clause – If you selected the Alter Tablespaces Online After Restore option, this option is selected by default, which ensures that the tablespaces are included in the recovery and brought online. Clear this option if you want to recover the tablespaces manually.
•
Check Read-Only Datafiles and Restore if Necessary – Select this option to include read-only datafiles in the restore. The read-only files are included only if they are needed to complete recovery. If they are not damaged, RMAN will omit them.
•
Number of Channels – You can control the degree of parallelism within a restore job by allocating the desired number of channels. Allocating multiple channels simultaneously allows a single restore job to restore multiple backup sets in parallel. The number of channels should be less than or equal to the number of channels that was specified for the backup job.
•
Restore/Recover from User Defined Backup Tag – Select this option and enter a tag name to select backup sets from which to restore. Selecting this option is equivalent to the RMAN restore option FROM TAG="<tag_name>". This option overrides the default RMAN restore selection of the most recent backups or file copy available, and it restricts the automatic selection to back up sets or file copies that were created with the specified tag. If multiple backup sets or file copies have a matching tag, RMAN selects the most recent backup set or file copy. Note that tag names are not case-sensitive.
 
 
*IMPORTANT: In a Data Guard environment, Dell recommends that you use the Restore/Recover from User Defined Backup Tag option to restrict the restore to backups taken from a particular Oracle Database Server. For more information, see Restoring data to an alternate server in a Data Guard environment.
•
Restore Source – Select the location that RMAN should use as the source for the restore. This option provides the flexibility to speed up restores by ensuring that RMAN restores from the FRA even if the backup is also available on NetVault Backup media (that is, disk-based media, VTL, or tape).
Alternately, the Restore Source option can ensure that RMAN restores from the NetVault Backup media when the FRA is suspected to have a media failure or data corruption. This is useful when you do not want to risk restarting the restore and recovery process due to RMAN’s inability to restore from the FRA.
Additionally, you can use these same options even if you originally performed CLI-based backups to disk by allocating a channel to disk.
The following Restore Source options are available:
•
Tape (Restore from NetVault Backup Media)
•
Disk (Restore from FRA or Disk)
•
Both Tape and Disk (Restore from both NetVault Backup Media and (FRA or Disk))
For more information, see Choosing the restore source.
•
Validate Restore – Validates the restore without restoring any data. The plug-in tells RMAN to select and confirm that the existing available backupsets are sufficient for the selected operation (such as an entire database restore or a single tablespace restore), thus ensuring that the necessary backupsets are not corrupted and are usable. The following Validate Restore options are available:
•
Validate Restore Only – If this option is selected, only validation is performed.
•
Perform Restore if Validate Completes Without Errors – If this option is selected and the Validate Restore completes without errors, the restore is also performed.
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating