Tchater maintenant avec le support
Tchattez avec un ingénieur du 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 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.

Opening the database for use

After recovery terminates, open the database for use by issuing the following command at the SQL*Plus prompt:

ALTER DATABASE OPEN;

Using advanced User Managed restore procedures

With the User Managed backup method, Plug‑in for Oracle lets you rename the Control File, Datafiles, and Archive Log Directory or Individual Archived Log files during restore. Renaming files can be useful if you do not want to overwrite the existing version and want to create a copy of the file. You can also relocate the files to a different directory while restoring it with the plug-in.

 
* 
IMPORTANT: Renaming of data is not supported when restoring Users Managed backups to a raw device. This option can only be used if you are restoring a User Managed backup to file system storage.

The following topics describe advanced User Managed restores and provide more information regarding additional features that are available:

•
Renaming or relocating Control File, Datafile, or individual Archived Log files
•
Renaming or relocating the Archive Log Directory

Renaming or relocating Control File, Datafile, or individual Archived Log files

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 item that you want to rename or relocate.
5
From the Actions list, select Rename.
6
In the Rename/Relocate dialog box, enter the applicable information, and click OK.
•
Rename: Enter the new name.
•
Relocate: Enter the new path.
The item is accompanied by the name and location information in parentheses.
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 the job.
 
* 
IMPORTANT: When renaming individual archive log files during a restore job, perform media recovery with SET AUTORECOVERY OFF, and enter the archive log filenames manually to indicate the revised filenames.
Documents connexes

The document was helpful.

Sélectionner une évaluation

I easily found the information I needed.

Sélectionner une évaluation