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

Restoring data to an alternate server in a Data Guard environment

When performing restores in a Data Guard environment where the backup is restored to an alternate Database Server, the process is identical to restoring to the same Database Server except for the differences described in the following sections.
To restore a backup that used the User Defined Backup Tag option
On the Restore Options tab, select the Restore/Recover from User Defined Backup Tag check box, and complete the associated field by specifying the tag that corresponds to the backup set for the Database Server from which you want to restore.
To ensure that the backup is restored to an alternate Database Server
On the Create Restore Job page, use the Target Client list to select the NetVault Backup Machine Name of the alternate or target Database Server for the restore.

Recovering Whole Database to Primary Database Server

This type of recovery is performed when the current Control File and SPFILE are intact but all the datafiles are damaged on the Primary Database Server, and the backup from the Standby Database Server is used for the recovery. You can perform a Complete Recovery or recover the database to a specific point-in-time.
An overview of the process to recover the whole database from a backup of the Standby to the Primary Database Server follows.
1
On the Create Restore Job - Choose Saveset page, find the latest available backup on the Standby Database Server that included all the tablespaces, and click Next.
2
On the Create Selection Set page, select the Whole Database node, and click Edit Plugin Options.
3
Click the Restore Options tab, and then select the following:
•
In the Pre-Restore Options section, select Whole Database Restore.
•
In the Restore Options section, select Restore/Recover from User Defined Backup Tag, and specify the User Defined Backup Tag for the Standby Database Server.
4
To perform recovery on the database, that is, reconstruct the database up to the current or specified point-in-time, select one of the following options in the Recovery Type section on the Perform Recovery tab:
•
Perform Complete Recovery – Recovers the database to the current time, that is, to the last committed transaction available in the archived and online redo logs.
•
Perform Database Point in Time Recovery – Recovers the database to a specific point-in- time, whether it is a specific time, log sequence number, or SCN.
5
On the Recovery Catalog tab, select the Use Catalog option, and specify the Recovery Catalog connection details.
6
If the Oracle SID of the Primary Database Server is different from the Oracle SID in the standby database, select the Destination Details tab, and complete all fields.
Enter the Target Service of the Primary Database Server, the Oracle SYSDBA User Name, and the Oracle SYSDBA Password.
 
 
*IMPORTANT: In a Data Guard environment, the primary database and standby database have the same database name and the same DBID. However, the Oracle SID might not be the same for the purpose of differentiating the database servers.
7
In the Target Client list, select the NetVault Backup Client Name of the Primary Database Server.
8
Continue with the restore procedure, including completion of the Schedule and Advanced Options lists.
For more information, see Finalizing and submitting a job.
RMAN will automatically choose the best available Full, Incremental, or Archived Log backups and restore and recover the database.

Troubleshooting

•
NetVault Backup 10.x service (netvault-pgsql) will not start on Windows
•
Unable to add a database
•
Backup fails
•
Backup job hangs
•
Restore fails

NetVault Backup 10.x service (netvault-pgsql) will not start on Windows

Check the Windows Event Viewer to see if it displays the following message: PDT FATAL: lock file “postmaster.pid” already exists
NetVault Backup 10.x uses a PostgreSQL database. If the PostgreSQL database does not start, NetVault Backup cannot start. To correct this issue, delete the “postmaster.pid” file from the location referenced in the log and restart the NetVault Backup Server. For more information, refer to https://support.quest.com/netvault-backup/kb/122475.
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating