To begin using the plug-in for backup and restore, first add the target Oracle database to the plug-in. To add a database, perform the following steps for each database running on the Oracle server that is protected with the plug-in.
1 |
2 |
3 |
4 |
On the Oracle Instance Details tab, set the following parameters: |
• |
Oracle SID: Enter the SID for the target Oracle database. For help on determining the Oracle SID, see Determining the Oracle SID and Home directory in a non-RAC environment. |
• |
Oracle Home: Enter the complete path to the installation directory of the target database. For help on determining the Oracle Home, see Determining the Oracle SID and Home directory in a non-RAC environment. |
IMPORTANT: To prevent an Oracle error from occurring, do not include a forward slash at the end of the ORACLE_HOME directory on Linux and UNIX. Using a backward slash on Windows does not generate an error. |
• |
Oracle SYSDBA User Name: Specify an Oracle user with SYSDBA privileges that is used by the plug-in to connect to the database. |
• |
Oracle SYSDBA Password: Enter the password associated with the name specified in the preceding field. |
NOTE: You can also configure the authentication details for Plug‑in for Oracle later by accessing the Set Database Password functionality. For more information, see Setting the database password. |
IMPORTANT: If the plug-in’s authentication details are not configured on the Add Oracle Database dialog box or by using Set Database Password, a prompt appears each time a connection to the database is required. |
• |
For Linux and UNIX only: Configure these parameters: |
• |
Oracle Software Owner: Specify the name of the Linux or UNIX user that owns all the Oracle software. This user must have the Oracle Inventory group as its primary group and the OSDBA and OSOPER groups as secondary groups. The usual name chosen for this user is oracle. |
• |
Oracle Software Group: Specify the name of the Linux or UNIX group that owns the Oracle inventory, which is a catalog of all Oracle software installed on the system. The usual name chosen for this group is oinstall. |
• |
NLS_LANG: Select the character set that matches the NLS Language or NLS_LANGUAGE parameter for the databases residing on this Oracle Database Server. The NLS_LANGUAGE specifies the default language of the database. This language is used for messages, day and month names, symbols for AD, BC, a.m., and p.m., and the default sorting mechanism. |
• |
Parameter File(s) Path: When an Oracle Instance is started, the parameters specified within the initialization parameter file establish the characteristics of the Instance. These initialization parameters are either stored in the PFILE or SPFILE. |
• |
Enabling Control File Autobackups, which include Autobackups of the SPFILE by selecting the Control File Autobackup Enabled option on the RMAN Details tab. |
• |
Disabling Control File Autobackups and using RMAN commands to back up the SPFILE when the Use RMAN Commands to Backup SPFILE option on the RMAN Details tab is selected. |
• |
initSID.ora where the SID represents the ORACLE_SID |
|||
spfileSID.ora where SID represents the ORACLE_SID |
|||
spfileSID.ora where SID represents the ORACLE_SID |
• |
Auto Discover: To complete the remaining database-configuration fields automatically, click this button after you have completed the Oracle SID, Oracle Home, Oracle SYSDBA User Name, and Oracle SYSDBA Password fields. |
IMPORTANT: When using the Auto Discover option, Quest recommends that you review all database-configuration fields for accuracy. |
5 |
On the RMAN Details tab, set the following parameters if you intend to use the RMAN backup method. |
• |
Control File Autobackup Enabled (Disables Manual Control File and SPFILE Backups): Select this option if the Control File Autobackups have been enabled for this database. Control File Autobackups are required for disaster recovery and multi-instance RAC environments. When this option is selected, Manual Control File backups are disabled and the Control File node is not available on the NetVault Backup Selections page. For more information on Control File Autobackups in a multi-instance RAC environment, see Enabling Control File Autobackups in a RAC environment. |
• |
Use RMAN Commands to Backup SPFILE: Available only when Control File Autobackup Enabled is not selected. When this option is selected, the RMAN commands are used to back up the SPFILE. When this option is not selected, a File System-based backup of the SPFILE is performed of the SPFILE that is specified in the Parameter File(s) Path field on the Instance Details tab. |
• |
Use Catalog for RMAN Based Backups: Select this option if the RMAN repository for this database is stored in a Recovery Catalog database, and then configure the following parameters: |
• |
Catalog Instance Name: Enter the Oracle Instance name, which might differ from the Oracle Net Service name, for the Recovery Catalog database. This instance name must be defined in the “tnsnames.ora” file on the Oracle Database Server so that the plug-in can connect to the Recovery Catalog database. |
• |
Catalog Owner: Specify the user that was specified as the owner of the Catalog and was granted the RECOVERY_CATALOG_OWNER role. |
• |
Catalog Password: Provide the password associated with the Catalog owner name specified in the preceding field. |
• |
CLI Backup/Autobackup Advanced Options Set: If you are using CLI-based backups, specify the name of the Backup Advanced Options Set that you want to use for this database. |
• |
CLI Backup/Autobackup Target Set: If you are using CLI-based backups, specify the name of the Backup Target Set that you want to use for this database. |
• |
CLI Database Name (optional): If you are using CLI-based backups, enter the database name used by the CLI. |
6 |
On the User Managed Details tab, set the following parameters: |
NOTE: The User Managed backup method can only back up File System objects; it cannot back up archive logs saved in ASM storage. You can leave the Archive Log Destination Directory field on the User Managed Details tab blank. Backing up databases in ASM storage is only available using the RMAN backup method. |
• |
Control File Save Filename (Full Path): When the plug-in uses the User Managed backup method, backups and restores of the Control File are not performed using the active Control File. A snapshot of the Control File is created in the file named by the Control File Save Filename (Full Path), and the snapshot or copy of the Control File is backed up. This step ensures that a consistent copy of the Control File is protected. |
• |
Archive Log Destination Directory: Enter the complete path to the archive log directory as set in the LOG_ARCHIVE_DEST or LOG_ARCHIVE_DEST_n parameters in the parameter file. If you archive the redo logs to multiple locations, specify only the primary destination directory in this field. |
• |
Archive Log Format: Specify the extension of the archive log files. The archive file pattern depends on what is established for the LOG_ARCHIVE_FORMAT setting in the parameter file. The following list provides some examples: |
7 |
On the External Configuration tab, set the following parameters: |
• |
Directory Path: If you enter a directory path, the plug-in scans the directory for filenames that might correspond to an Oracle Network Configuration File or an Oracle Password File. The rest of the files in the directory are ignored. |
• |
Fully Qualified Path to a File: The path includes directory and filename. |
• |
Oracle Network Configuration Directory or File(s) Path: Enter the directory where the Oracle Network Configuration files reside, or the list of Oracle Network Configuration files. |
• |
Oracle Password Directory or File(s) Path: Enter the directory where the Oracle Password files reside, or the list of Oracle Password files. |
8 |
On the Optional OS Authentication Details tab (for Windows-based OS only), set the following parameters: |
• |
Windows Administrator User Name: Enter the Windows Administrator user name for the account under which the plug-in should run. The name specified in this field must have been already created in the Windows OS. |
• |
Password: Enter the password associated with the name specified in the preceding field. |
• |
Windows Domain: Specify the domain to which the user belongs. If it is the Local domain, leave this field blank. |
10 |
If you are using Oracle Multitenant Architecture with Oracle Database 12c or later and your CDB includes one or more PDBs, make sure that an entry is included for each PDB in the “tnsnames.ora” file and that the status of the PDB is in read-write mode. |
1 |
2 |
3 |
Click the name of the applicable database to highlight it; do not select the check box. |
4 |
IMPORTANT: The password fields on the Edit Oracle Database dialog box are blank. Set the passwords again, even if there are no changes. If this step is not done, the existing values are reset to blank when you save the updated information. To update only the authentication details for the plug-in, select the Set Database Password option instead of Edit Database. |
Plug‑in for Oracle lets you save the Oracle authentication details that are used to connect to the database automatically. Saving the authentication information eliminates the need to enter the details each time a connection to the database is required. You can save these details either at the time of adding a database or any time later using the Set Database Password option.
1 |
3 |
4 |
• |
Account Name: Enter an Oracle user name with SYSDBA privileges. |
• |
Password: Enter the password associated with the name specified in the preceding field. |
1 |
3 |
4 |
5 |
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Términos de uso Privacidad Cookie Preference Center