Chat now with support
Chat with Support

NetVault Plug-in for Oracle 11.3 - 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 Troubleshooting

Preparing the database for recovery

You do not have to take a complete Oracle® Database offline to restore selected tablespaces, but you must take each tablespace that you want to restore offline before performing the restore.

1
Connect to the database with SYSDBA privileges by using the SQL*Plus utility.
SQLPLUS SYS AS SYSDBA
2
If the database is open, take all tablespaces that contain damaged datafiles offline by running the following command:
ALTER TABLESPACE <Tablespace Name> OFFLINE IMMEDIATE;

Selecting data for a 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.
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 the data that you want to restore.
Depending on the items selected for the backup, the saveset includes:
•
Parameter File
•
All Tablespaces
•
Backup Control File
•
Archive Logs
7
Open the applicable items, and select the data that you want to include in the restore.
 
* 
NOTE: For User Managed restores, you do not have to set any other options; the Restore Options tab does not contain any fields.

Finalizing and submitting the job

The final steps include setting additional options on the Schedule, Source Options, and Advanced Options pages, submitting the job, and monitoring the progress through the Job Status and View Logs pages. These pages and options are common to all NetVault Backup Plug-ins. For more information, see the Quest NetVault Backup Administrator’s Guide.

1
Click OK to save the settings, and then click Next.
2
In Job Name, specify a name for the job if you do not want to use the default setting.
Assign a descriptive name that lets you easily identify the job when monitoring its progress. The job name can contain alphanumeric and non-alphanumeric characters, but it cannot contain non-Latin characters. On Linux®, the name can have a maximum of 200 characters. On Windows®, there is no length restriction. However, a maximum of 40 characters is recommended on all platforms.
3
In the Target Client list, select the machine on which you want to restore the data.
 
* 
TIP: You can also click Choose, and then locate and select the applicable client in the Choose the Target Client dialog box.
4
Use the Schedule, Source Options, and Advanced Options lists to configure any additional required options.
5
Click Save or Save & Submit, whichever is applicable.
You can monitor progress on the Job Status page and view the logs on the View Logs page. For more information, see the Quest NetVault Backup Administrator’s Guide.

Recovering the database

After restoring the datafiles, you can choose to recover the database, tablespace, or datafile.

1
Connect to the database with SYSDBA privileges by using the SQL*Plus utility.
SQLPLUS SYS AS SYSDBA
2
Run one of following commands based on the required result:
•
To recover a whole database, enter:
RECOVER DATABASE
•
To recover a specific tablespace, enter:
RECOVER TABLESPACE <Tablespace Name>
•
To recover a specific datafile, enter:
RECOVER DATAFILE '<datafile name with complete path>';
The database notifies you when media recovery is complete:
Media recovery complete.
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating