立即与支持人员聊天
与支持团队交流

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

Retrieving a Control File manually

1
On the Create Restore Job - Choose Saveset page, find the latest available backup that is marked with “Controlfile Included.”
('<destination PathAndNameOfControlFile>');
('<backupSegment NameIdentifiedEarlier>',done=>done);
3
Use the replicate controlfile command to copy the restored Control File.
SET DBID <Source_DBID>;
'<sourcePathAndNameOfControlFile>';

Using advanced procedures with RMAN restores

2
In the Navigation pane, click Create Restore Job, select Plug‑in for Oracle from the Plugin Type list.
4
On the Create Selection Set page, select the datafile or Control File to be restored.
5
From the Actions list, select Rename.
6
In the Rename/Relocate dialog, enter the applicable information.
Rename – Enter the new name.
Relocate – Enter the new path.
The plug-in uses the set newname RMAN command to restore/rename RMAN backups. The set newname command has precedence over the DB_CREATE_FILE_DEST parameter. If the full path is not specified for a restore or rename, the plug-in behaves as follows:
SPFILE – The file is restored to the “$ORACLE_HOME/dbs” directory with the new name.
7
Click Ok to apply changes.

Duplicating a database in a non-RAC environment

For more information on duplicating a multi-instance RAC database, see Duplicating a database in a RAC environment. For more information on Oracle’s Duplicate Database functionality, refer to Duplicating a Database in the Oracle Database Backup and Recovery User’s Guide.

Restoring a Duplicate Database to the same server

Same version of Oracle Database software – The version and edition of Oracle for the destination database must be identical to the version and edition of Oracle being used for the source database. This includes identical patch levels.
Duplicate Database backup available – A Duplicate Database backup must be completed successfully and made available.
Source database in open state – The source database must remain in an OPEN READ WRITE state during the entire Duplicate Database restore process.
Auxiliary instance prepared – RMAN’s backup-based Duplicate Database process requires the preparation of an auxiliary instance:
1
Oracle password file for auxiliary instance created – Required if you want to use a password file versus OS authentication for the auxiliary connection when duplicating to the same host as the source database. For more information on creating a password file, refer to Creating and Maintaining a Password File in the Oracle Database Administrator’s Guide.
2
Oracle Net connectivity established to auxiliary instance – The auxiliary instance must be available through Oracle Net by adding the instance to the “tnsnames.ora” file. Additionally, on Windows platforms, perform the following command to start the instance:
3
Auxiliary instance destination directories exist – The following destination directories for the auxiliary instance must be created on the server where the destination database will reside. If the destination database will store its datafiles in ASM, the ASM instance name for the destination database must exist.
4
PFILE created for auxiliary instance – A client-side PFILE for the Auxiliary Database must be created from the SPFILE of the source database.
Start SQL*Plus, and connect with administrator privileges to the source database.
sqlplus sys/<password>@<source_connect_identifier> AS SYSDBA
create pfile = '<PFILE_destination_directory>/
init<auxiliary_sid>.ora' from spfile;
5
PFILE updated with auxiliary values – The PFILE created for the auxiliary instance must be updated with the parameter values specific to the auxiliary instance.
Update the *.db_name= entry to reflect the name of the destination database.
*.db_file_name_convert='<source_db_create_file_dest>/<source_sid>',
'<destination_db_create_file_dest>/<destination_sid>'
*.log_file_name_convert='<source_db_create_file_dest>/
<source_sid>', '<destination_db_create_file_dest>/
<destination_sid>'
6
Auxiliary instance started in NOMOUNT state – The auxiliary instance must be started in NOMOUNT state with the PFILE that has been updated with the parameter values specific to the auxiliary instance.
Start SQL*Plus, and connect with administrator privileges to the auxiliary instance.
sqlplus sys/<password>@<auxiliary_connect_identifier> AS SYSDBA
startup nomount pfile = '<PFILE_destination_directory>/
init<auxiliary_sid>.ora'
create spfile from pfile='<PFILE_destination_directory>/
init<auxiliary_sid>.ora';
8
Exit SQL*Plus.
You must exit SQL*Plus for the Duplicate Database restore to complete successfully.
1
On the Create Restore Job - Choose Saveset page, find the applicable Duplicate Database backup, 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 Clone Database tab, and select the Duplicate Database option.
4
In the Destination Database section:
Specify the Oracle Home for the auxiliary instance.
Specify the Oracle SYSDBA User Name that will be used by the plug-in to connect to the auxiliary instance.
Specify the Oracle SYSDBA Password.
5
In the Duplicate From Database section:
Specify the Oracle SID for the source database.
Specify the Oracle Home for the source database.
Specify the Oracle SYSDBA User Name that will be used by the plug-in to connect to the source database.
Specify the Oracle SYSDBA Password.
相关文档

The document was helpful.

选择评级

I easily found the information I needed.

选择评级