Chat now with support
Chat with Support

NetVault Plug-in for Oracle 13.0 - User Guide

Introducing Quest® NetVault® 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 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.
3
In the right pane, right-click the Oracle user, and select Properties.
4
In the Properties dialog box, select the Member Of tab, and click Add.
5
Add the local Administrators group, and click OK.
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.
2
Locate the following registry key:
My Computer\HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE
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:
•
ORACLE_HOME
•
ORACLE_SID
5
Exit the Registry Editor.

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:
more /etc/oratab
2
In the “oratab” file, note the application information.
The file contains entries for each Oracle database running on the server in the following format:
<ORACLE_SID>:<ORACLE_HOME>:<Additional Information>
For example, if “oratab” contains the following:
PROD:/u03/app/oracle/product/10.2.0/db_1:N
It indicates that:
•
“PROD” is the ORACLE_SID
•
“/u03/app/oracle/product/10.2.0/db_1” is the ORACLE_HOME
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating