Entering or editing credentials for Oracle databases
Before performing this procedure, you must first add an Oracle database server to protection on your Core.
To enter or edit Oracle database credentials:
- The Windows user account of the Rapid Recovery user performing this procedure must have SYSDBA privileges on the protected database server.
- The database must be accessible to the Rapid Recovery Core server, and a connection must be successfully established.
|
NOTE: SYSDBA is an Oracle systems database administrative privilege required to perform high-level administrative operations. These functions include creating, starting up, shutting down, backing up, or recovering an Oracle database. |
After protecting your Oracle database server, you cannot access database metadata or view database details until you enter credentials for each database. This one-time step caches your database credentials securely and provides the Core Console with access to status information about all protected transaction log files, control files, and data files that comprise your Oracle databases.
For example, on the Summary page for the protected Oracle machine, before entering credentials, you cannot expand details about any of the protected databases in the Oracle Server Information pane.
|
NOTE: This is a one-time step required for each new protected Oracle database. |
Complete the steps in this procedure to provide the Rapid Recovery Core Console with access to the required metadata for your protected Oracle databases.
- Navigate to the protected Oracle machine in the Rapid Recovery Core Console.
The Summary page displays for the protected machine.
- On the Summary page, scroll down to the Oracle Server Information pane.
- For the first database in the table, click the (More options) drop-down list and select Edit Credentials.
The Edit Instance Credentials dialog box displays.
- Two connection types are supported: basic, and Transparent Network Substrate (TNS, a proprietary Oracle networking technology). Do one of the following:
- To connect using a basic connection, enter the information in the following table:
Connection Type |
Basic |
Host Name |
Enter the host name or IP address. |
Port |
Enter the appropriate port. The default port open for this purpose is 1521. |
SID or Service Name |
Select the appropriate connection method. You can use one of the following:
- SID. The Oracle System Identifier (SID) is a unique ID that uniquely identifies your database instance.
- Service Name. The service name is the TNS alias used to remotely connect to your database.
|
NOTE: The service name can be found in the TNSNAMES.ORA file. | |
Service Name |
The service name is the TNS alias that you give when you remotely connect to your database and this Service |
- To connect using TNS, enter the information in the following table:
Connection Type |
TNS |
Network Alias |
Select this drop-down menu to view database aliases available to the network, and select the appropriate alias. |
- Two credential types are supported: Oracle, and Operating System. Do one of the following:
- To connect with Oracle credentials, enter the user name and password for the Oracle database in the relevant text fields.
|
NOTE: Your Windows user account must have SYSDBA privileges. |
- To connect using cached credentials from the operating system, select Operating System.
|
NOTE: Your Windows user account must be a member of the ORA_DBA local group, which ensures the user has SYSDBA privileges. |
- To verify credentials, click Verify.
A dialog box displays, indicating if the test connection was successful.
- Do one of the following:
- If the verification succeeded, click OK to close the message dialog box.
- If not successful, close the dialog box and revise the instance credentials until connection is verified. Consult your system administrator if you have questions about credentials.
- In the Edit Instance Credentials dialog box, after successful verification, click OK.
The dialog box closes, and Rapid Recovery Core Console immediately applies and caches the credentials. Very soon afterward, metadata is available in the Core Console, and the status indicator for the selected database displays a green (online) status.
- Repeat step 3 through step 8 for each database listed in the Oracle Server Information pane.
After entering and caching credentials for all databases on this protected Oracle machine, perform the procedures described in the topic Enabling archive log mode and adding VSS writer for protected Oracle databases.
Enabling archive log mode and adding VSS writer for protected Oracle databases
Before performing this procedure, you must first add an Oracle database server to protection on your Core, and enter credentials for each database into the Core Console.
Database applications require the presence of a combination of specific files (such as configuration, log, and control files), each set to a specific state, to be able application-consistent. In Rapid Recovery Core release 6.2 and later, Oracle databases require archive log mode to be enabled. Until you perform this procedure, your snapshots of the database server will be crash-consistent, but not application-consistent.
Oracle VSS writer captures snapshots using Volume Snapshot Service. This writer must be enabled.
|
NOTE: These are one-time steps required for each new protected Oracle database. |
Complete the steps in this procedure to verify if archive log mode is enabled; to enable that mode if required; and to add VSS writer to your Core.
- Navigate to the protected Oracle machine in the Rapid Recovery Core Console.
The Summary page displays for the protected machine.
- On the Summary page, scroll down to the Oracle Server Information pane.
- In the Oracle Server Information pane, if you see a warning notification that archive log mode is disabled, click Enable archive log mode for these databases and then click to confirm restart of the database instances.
|
NOTE: Enabling archive mode causes the relevant database instances to restart. This could take a few minutes. |
- In the Oracle Server Information pane, if you see a warning notification that the Oracle VSS writer is excluded from snapshots, click Include Oracle VSS Writer and then click to confirm.
The warning message closes, and the VSS writer is added to your Core.
- Optionally, you can track the progress towards enabling archive log mode or adding a VSS writer. For more information, see Viewing tasks.
About truncating Oracle logs
Currently, protection of Oracle 12c databases in Rapid Recovery Core release 6.2 and later is limited to using Volume Snapshot Service (VSS) in the ARCHIVELOG mode. In this mode, the database is configured to archive all online redo logs using the ARCH (archive) process. The Oracle VSS writer calls the Oracle service to archive the existing re-do logs to Oracle's fast_recovery_area folder, and creates a new archive log file.
ARCHIVELOG mode causes a substantial number of log files to accumulate on the database server, using valuable storage space. Each time a recovery point of the Oracle server is captured, the new Oracle logs generated since the last snapshot are included. This renders the local copies of the logs superfluous. For this reason, Rapid Recovery Core includes several methods for truncating Oracle logs.
- Enable Oracle log truncation on the Core as a nightly job. Rapid Recovery Core includes a nightly job setting called Log truncation for Oracle.This nightly job is disabled by default. If you enable this nightly job, Oracle ARCHIVELOGS are truncated according to the deletion policy specified in the settings for this job.
- Enable and customize Oracle log truncation as a nightly job. For each specific Oracle server protected on your Core, you can customize the Oracle log truncation nightly job configuration. As with the Core nightly job, you can select from any of the three deletion policies, described in the following section.
- Manually truncate logs on demand. Regardless of whether you set a log truncation schedule using nightly jobs, you can manually truncate Oracle ARCHIVELOGS on demand at any time.
Truncation of Oracle logs, by nightly job or on demand manually, occurs without requiring a transfer job.
When you specify truncation of Oracle logs by nightly jobs, truncation occurs according to the deletion policy at the time nightly jobs are scheduled to occur. Conversely, when you elect to manually truncate Oracle logs, a log truncation job queues. If the system is not busy, the job executes immediately and the logs are truncated.
Deletion policies for Oracle log truncation
When configuring log truncation for Oracle database servers, you can choose from one of three deletion policies:
- The Automatic deletion policy truncates all Oracle ARCHIVELOGS stored in the fast_recovery_area folder one time daily when nightly jobs run.
- The Keep newest deletion policy lets you specify the duration of time (n days, weeks, months, or years) to retain the Oracle logs before truncating. When the time period expires, log files past the threshold are then truncated one time daily when nightly jobs run.
- The Keep specified number deletion policy lets you specify a specific number of log files to retain. After that threshold is reached, newer logs are retained, and the older logs are then truncated one time daily when nightly jobs run.
If you need a truncated ARCHIVELOG file, you can obtain it from the latest recovery point captured prior to truncating the logs.
For more information about truncating jobs as a nightly job, see the topic Understanding nightly jobs.
For more information about manually truncating Oracle logs on demand, see Manually truncating Oracle database logs.
Manually truncating Oracle database logs
This procedure is only appropriate for Oracle database severs protected on your Core.
When protecting an Oracle database in ARCHIVELOG mode, substantial log files accumulate on the local database server. To support the protection of Oracle databases in
Rapid Recovery, you can enable a nightly job to truncate Oracle logs.
|
NOTE: Log truncation for Oracle is disabled by default. |
For any protected Oracle server, you can also manually truncate Oracle database logs on demand at any time, as described in this topic. Truncating will delete the logs from the local server. In each recovery point saved to your repository, the database logs persist to reflect the state of the database at the time the backup snapshot was captured.
Complete the steps in this procedure to manually truncate Oracle log files.
- Navigate to the protected Oracle machine in the Rapid Recovery Core Console.
The Summary page displays for the protected machine.
- On the Summary page, scroll down to the Oracle Server Information pane.
- In the table row representing the Oracle database instance for which you want to truncate logs, click the (More options) drop-down list and select Force Log Truncation.
The Force Log Truncation dialog box displays.
- If you want to delete all of the Oracle logs from the local database server, from the Deletion policy drop-down menu, select Automatic, and then click Force.
A log truncation job queues. If the system is not busy, the job executes immediately and the logs are truncated.
- If you want to delete all of the locally stored logs from the Oracle server (copies of which are stored in the most recent recovery point), do the following:
- From the Deletion policy drop-down menu, select Keep newest.
- In the Keep logs for text field, enter a number, and then from the time period drop-down menu, select the relevant a period of time (days, weeks, months, or years).
- Click Force.
A log truncation job queues. If the system is not busy, the job executes immediately and the logs are truncated.
- If you want to keep a specific number of Oracle log files, and truncate the remaining logs, then do the following:
- From the Deletion policy drop-down menu, select Keep specified number.
- In the Number of archive files text field, enter a number representing the amount of the newest database logs to retain.
- Click Force.
A log truncation job queues. If the system is not busy, the job executes immediately and the logs are truncated.
- If you want to truncate logs for other database instances on this server, repeat step 3 through step 6 for each relevant database listed in the Oracle Server Information pane.