Chat now with support
Chat with Support

NetVault Plug-in for Oracle 10.0.5 - 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-in in a failover cluster environment Using the plug-in with Oracle® Data Guard Troubleshooting Glossary

Installing and removing the plug-in

•
Prerequisites
•
Prerequisites for RMAN backups
•
Recommended configuration for a single-instance non-RAC environment
•
Installing the plug-in
•
Removing the plug-in

Prerequisites

Before installing the plug-in, verify that the following prerequisites are met on the machine designated as the Oracle® Database Server.
NetVault Backup Server and Client software
At a minimum, the Client version of NetVault Backup must be installed on the machine where the plug-in is installed. In a single-instance non-RAC environment, the plug-in is installed on the server where the Oracle® database resides. In a multi-instance RAC environment, the plug-in is installed on one of the nodes that hosts one of the instances for the RAC-enabled database.
Database in ARCHIVELOG mode
Verify that the database is running in ARCHIVELOG mode. For instructions on enabling the archiving of filled groups of redo log files, see the Oracle® Administrator’s Guide.
To verify that the database is properly set in this mode:
1
Start SQL*Plus, and connect with administrator privileges to the database.
sqlplus SYS/<password>@<connect_identifier> AS SYSDBA
2
From the SQL> prompt, enter:
ARCHIVE LOG LIST
The output shows the current mode. If the Automatic archival property displays an Enabled status, the database is properly configured. The following example shows that the Database log mode is set to Archive Mode.
SQL> archive log list
Database log mode                 Archive Mode
Automatic archival                Enabled
Archive destination               e:\oraclelogs
Oldest online log sequence        11
Next log sequence to archive      13
Current log sequence              13
SQL>

Prerequisites for RMAN backups

The following sections identify the requirements for performing RMAN backups:
•
Adding the Oracle user to the local administrator group on Windows
•
Determining the Oracle SID and Home directory in a non-RAC environment
•
Creating the RMAN repository
•
Registering the target database
•
Enabling Control File Autobackups
•
Enabling Flashback Database
•
Enabling Block Change Tracking
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, you must 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.
To add the user on Windows Server 2008 R2
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