Chat now with support
Chat with Support

NetVault Backup Plug-in for Oracle 12.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 Using the plug-in with Oracle Container Databases (CDBs) and Pluggable Databases (PDBs) Troubleshooting

Adding the Oracle user to the local administrator group on Windows

If you are using Oracle 12.x or later and you created an Oracle administrative user as part of your installation, add this user to the local administrator group on Windows. This step ensures that RMAN backups have access to the NetVault Backup Process Manager (nvpmgr).

The following steps describe how to add the user on Windows Server 2008 R2. For information for your environment, see the applicable system documentation.

1
Click Start > Administrative Tools > Computer Management.
2
In the Computer Management window, open System Tools, select Local Users and Groups, and select Users.
4
In the Properties dialog box, select the Member Of tab, and click Add.
6
Click OK again.

Determining the Oracle SID and Home directory in a non-RAC environment

To identify the Oracle system ID (SID) and home directory, use one of the following procedures, based on the OS running on the Oracle Database Server.

Windows

On Windows, the SID and Oracle Home can be determined from the Registry.

1
Start the Registry Editor on the Oracle Database Server.
a
On the taskbar, click Start, and then click Run.
b
On the Run dialog box, type regedit, and then click OK.
Various directories are displayed. Each folder prefaced with “KEY_” represents an installation of Oracle on the target machine, if multiple installations of Oracle exist on the machine.
3
Open the folder entitled “KEY_<Oracle_Home>” that represents the target installation of Oracle to list the registry items in the frame on the right.
4
In the Name column, locate the following items, and make note of the associated entry in the Data column:

Linux and UNIX

On Linux and UNIX, you can use the “oratab” file to identify the SID and Oracle Home.

1
Open the “oratab” file by issuing the following command in a terminal window:
2
In the “oratab” file, note the application information.
<ORACLE_SID>:<ORACLE_HOME>:<Additional Information>
For example, if “oratab” contains the following:
“PROD” is the ORACLE_SID
Related Documents