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

Duplicating a database in a non-RAC environment

A Duplicate Database backup lets you create a duplicate or clone of a source database for special purposes that does not affect the backup and restore procedures for the source database. RMAN supports duplicating databases to increase a DBA’s flexibility when performing the following tasks:

•
Testing backup and recovery procedures.
•
Testing an upgrade to a new release of Oracle Database.
•
Testing the effect of applications on database performance.
•
Generating reports.

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, see Duplicating a Database in the Oracle Database Backup and Recovery User’s Guide.

The plug-in provides the following restore scenarios for the Duplicate Database backup:

•
Restoring a Duplicate Database to the same server
•
Restoring a Duplicate Database to an alternate server with the same directory structure
•
Restoring a Duplicate Database to an alternate server with an alternate directory structure

Restoring a Duplicate Database to the same server

The following procedure details the steps to restore a Duplicate Database backup to the local or same server where the source database resides. Because the duplicated database or destination database resides on the same physical server as the source database, the destination database must use a different directory structure.

•
Prerequisites
•
Restoring the Duplicate Database
Prerequisites

To restore a Duplicate Database backup to the same server, the following prerequisites must be met:

•
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 requirement 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, see 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:
oradim -new -sid <sid_name>
3
Auxiliary instance destination directories exist: The following destination directories for the auxiliary instance must be created on the server where the destination database resides. If the destination database stores its datafiles in ASM, the ASM instance name for the destination database must exist.
•
Control_Files
•
DB_Create_File_Dest
•
Audit_File_Dest
•
Background_Dump_Dest
•
User_Dump_Dest
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 a PFILE from the SPFILE.
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.
•
Remove all entries that begin with: <source_sid>.__
•
Update the *.db_name= entry to reflect the name of the destination database.
•
Update the following entries to reflect the destination directory for the auxiliary instance. This directory must exist; however, if the source database stores the datafiles in ASM, the ASM instance name for the destination database should be specified for each of the following control_files and db_create_file_dest parameters:
*.audit_file_dest=
*.background_dump_dest=
*.control_files=
*.user_dump_dest=
*.db_create_file_dest=
*.db_recovery_file_dest=
•
Comment out the following entry by inserting a “#” (number sign) at the beginning of the following entry:
*.dispatchers='(PROTOCOL=TCP) (SERVICE=<source_sid>XDB)'
•
Add the following line to specify the pairs of strings for converting the names of datafiles and tempfiles.
*.db_file_name_convert='<source_db_create_file_dest>/<source_sid>',
'<destination_db_create_file_dest>/<destination_sid>'
For example:
*.db_file_name_convert=' C:\oracle\oradata\prod',
'c:\oracle\oradata\test'
•
Add the following line to specify the pairs of strings for naming online redo log files:
*.log_file_name_convert='<source_db_create_file_dest>/
<source_sid>', '<destination_db_create_file_dest>/
<destination_sid>'
For example:
*.log_file_name_convert=' C:\oracle\oradata\prod',
'c:\oracle\oradata\test'
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
•
Start the instance in NOMOUNT state.
startup nomount pfile = '<PFILE_destination_directory>/
init<auxiliary_sid>.ora'
7
Auxiliary instance created from SPFILE from the PFILE
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.
Restoring the Duplicate Database

To restore the Duplicate Database, perform the following steps.

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 Net Service name of the auxiliary instance in the Target Service field.
•
Specify the Oracle Home for the auxiliary instance.
•
Specify the Oracle SYSDBA User Name that is 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 is used by the plug-in to connect to the source database.
•
Specify the Oracle SYSDBA Password.
6
Continue with the restore procedure, including completion of the Schedule and Advanced Options lists, as explained in Finalizing and submitting the job.

Restoring a Duplicate Database to an alternate server with the same directory structure

The following procedure details the steps to restore a Duplicate Database backup to an alternate or remote server — other than where the source database resides — and use the same directory structure as the source database.

•
Prerequisites
•
Restoring the Duplicate Database
Prerequisites

To restore a Duplicate Database backup to an alternate or remote server, the following prerequisites must be met:

•
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 requirement 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, see 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 of both the source server and the alternate server. Additionally, on Windows platforms, perform the following command to start the instance:
oradim -new -sid <sid_name>
3
Auxiliary instance destination directories exist: The following destination directories for the auxiliary instance must be created on the server where the destination database resides. If the destination database stores its datafiles in ASM, the ASM Instance name for the destination database must exist.
•
Control_Files
•
DB_Create_File_Dest
•
Audit_File_Dest
•
Background_Dump_Dest
•
User_Dump_Dest
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 a PFILE from the SPFILE.
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.
•
Remove all entries that begin with: <source_sid>.__
•
Update the *.db_name= entry to reflect the name of the destination database.
•
Update the following entries to reflect the destination directory for the auxiliary instance. This directory must exist; however, if the source database stores the datafiles in ASM, the ASM instance name for the destination database should be specified for each of the following control_files and db_create_file_dest parameters:
*.audit_file_dest=
*.background_dump_dest=
*.control_files=
*.user_dump_dest=
*.db_create_file_dest=
*.db_recovery_file_dest=
•
Comment out the following entry by inserting a “#” (number sign) at the beginning of the following entry
*.dispatchers='(PROTOCOL=TCP) (SERVICE=<source_sid>XDB)'
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
•
Start the instance in NOMOUNT state.
startup nomount pfile = '<PFILE_destination_directory>/
init<auxiliary_sid>.ora'
7
Auxiliary instance created from SPFILE from the PFILE.
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.
•
NetVault Backup software and the Plug‑in for Oracle installed: The same version of NetVault Backup software and the plug-in must be installed and configured on the alternate server where the destination database resides.
When configuring the plug-in on the alternate server, ensure that the following Default Attributes are defined:
•
NetVault Backup: Specify the name of the NetVault Backup Server where the source database server was added as a NetVault Backup Client.
•
Do Restore From NetVault Backup Server: Specify the name of the NetVault Backup Server where the source database server was added as a NetVault Backup Client.
•
Restore Backup taken from NetVault Backup Client: Specify the NetVault Backup Machine Name for the source database server.
For more information, see Configuring default settings.
•
Source database added to Plug‑in for Oracle installed on alternate server: The source database must be added to the plug-in that is installed on the alternate (standby) server where the destination database resides.
For example, the production Oracle Server is named salesdb. On the alternate server that has the plug-in installed, add a database named salesdb. You complete this step even though the existing database has not yet been cloned to the alternate server. This step forces the plug-in to create a placeholder that can then be accessed during the cloning process when the Oracle database is restored to the alternate (standby) server.
For more information on adding a database, see Adding a database. These instructions work for the original database, as well as the placeholder that you create on the alternate server.
Restoring the Duplicate Database
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 Net Service name of the auxiliary instance in the Target Service field.
•
Specify the Oracle Home for the auxiliary instance.
•
Specify the Oracle SYSDBA User Name that is used by the plug-in to connect to the auxiliary instance.
•
Specify the Oracle SYSDBA Password.
•
Select the Use nofilenamecheck option.
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 is used by the plug-in to connect to the source database.
•
Specify the Oracle SYSDBA Password.
6
In the Target Client list, select the NetVault Backup Machine Name of the alternate server where the destination database resides.
7
Continue with the restore procedure, including completion of the Schedule and Advanced Options lists.
For more information, see Finalizing and submitting the job.

Restoring a Duplicate Database to an alternate server with an alternate directory structure

The following procedure details the steps to restore a Duplicate Database backup to an alternate or remote server — other than where the source database resides — and use a different directory structure.

•
Prerequisites
•
Restoring the Duplicate Database
Prerequisites

To restore a Duplicate Database backup to an alternate or remote server with an alternate directory structure, the following prerequisites must be met:

•
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 requirement 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, see 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 of both the source server and the alternate server. Additionally, on Windows platforms, perform the following command to start the instance:
oradim -new -sid <sid_name>
3
Auxiliary instance destination directories exist: The following destination directories for the auxiliary instance must be created on the server where the destination database resides. If the destination database stores its datafiles in ASM, the ASM instance name for the destination database must exist.
•
Control_Files
•
DB_Create_File_Dest
•
Audit_File_Dest
•
Background_Dump_Dest
•
User_Dump_Dest
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 a PFILE from the SPFILE.
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.
•
Remove all entries that begin with: <source_sid>.__
•
Update the *.db_name= entry to reflect the name of the destination database.
•
Update the following entries to reflect the destination directory for the auxiliary instance. This directory must exist; however, if the source database stores the datafiles in ASM, the ASM instance name for the destination database should be specified for each of the following control_files and db_create_file_dest parameters:
*.audit_file_dest=
*.background_dump_dest=
*.control_files=
*.user_dump_dest=
*.db_create_file_dest=
*.db_recovery_file_dest=
•
Comment out the following entry by inserting a “#” (number sign) at the beginning of the following entry:
*.dispatchers='(PROTOCOL=TCP) (SERVICE=<source_sid>XDB)'
•
Add the following line to specify the pairs of strings for converting the names of datafiles and tempfiles.
*.db_file_name_convert='<source_db_create_file_dest>/
<source_sid>', '<destination_db_create_file_dest>/
<destination_sid>'
For example:
*.db_file_name_convert=' C:\oracle\oradata\prod',
'c:\oracle\oradata\test'
•
Add the following line to specify the pairs of strings for naming online redo log files:
*.log_file_name_convert='<source_db_create_file_dest>/
<source_sid>', '<destination_db_create_file_dest>/
<destination_sid>'
For example:
*.log_file_name_convert=' C:\oracle\oradata\prod',
'c:\oracle\oradata\test'
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
•
Start the instance in NOMOUNT state.
startup nomount pfile = '<PFILE_destination_directory>/
init<auxiliary_sid>.ora'
7
Auxiliary instance created from SPFILE from the PFILE.
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.
•
NetVault Backup software and the Plug‑in for Oracle installed: The same version of NetVault Backup software and the plug-in must be installed and configured on the alternate server where the destination database resides.
When configuring the plug-in on the alternate server, ensure that the following Default Attributes are defined:
•
NetVault Backup: Specify the name of the NetVault Backup Server where the source database server was added as a NetVault Backup Client.
•
Do Restore From NetVault Backup Server: Specify the name of the NetVault Backup Server where the source database server was added as a NetVault Backup Client.
•
Restore Backup taken from NetVault Backup Client: Specify the NetVault Backup Machine Name for the source database server.
For more information, see Configuring default settings.
•
Source Database Added to Plug‑in for Oracle Installed on Alternate Server: The source database must be added to the plug-in that is installed on the alternate (standby) server where the destination database resides.
For example, the production Oracle Server is named salesdb. On the alternate server that has the plug-in installed, add a database named salesdb. Complete this step even though the existing database has not yet been cloned to the alternate server. This step forces the plug-in to create a placeholder that can then be accessed during the cloning process when the Oracle database is restored to the alternate (standby) server.
For more information on adding a database, see Adding a database. These instructions work for the original database, as well as the placeholder that you create on the alternate server.
Restoring the Duplicate Database
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 Net Service name of the auxiliary instance in the Target Service field.
•
Specify the Oracle Home for the auxiliary instance.
•
Specify the Oracle SYSDBA User Name that is used by the plug-in to connect to the auxiliary instance.
•
Specify the Oracle SYSDBA Password.
•
Select the Use nofilenamecheck option.
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 is used by the plug-in to connect to the source database.
•
Specify the Oracle SYSDBA Password.
6
In the Target Client list, select the NetVault Backup Machine Name of the alternate server where the destination database resides.
7
Continue with the restore procedure, including completion of the Schedule and Advanced Options lists.
For more information, see Finalizing and submitting the job.
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating