Chat now with support
Chat mit Support

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

Querying the NetVault Backup media name

For RMAN CLI backups performed via the plug-in, you can use SQL*Plus to determine the physical media on which the RMAN backup pieces are stored. The following example shows how to query the media information using Oracle SQL*Plus.
Example
SQL> select handle, media from v$backup_piece;
HANDLE
-----------------------------------------------------------------
MEDIA
-----------------------------------------------------------------
NVBU_Server:#642:NVBU_Server:1_692655825:RMAN INCRMTAL LVL 0 SALESDB_1248060220 MMS NetVault Backup Tape
NVBU_Server:#642:NVBU_Server:2_692655843:RMAN INCRMTAL LVL 0 SALESDB_1248060220 MMS NetVault Backup Tape
NVBU_Server:#642:NVBU_Server:3_692655935:RMAN INCRMTAL LVL 0 SALESDB_1248060220 MMS NetVault Backup Tape
SQL*Plus uses the following format to display the media information:
•
If the media has a barcode identified by NetVault Backup, the format is:
(tape_barcode) tape_media_label
Sample Output from RMAN CLI
SQL> select handle, media from v$backup_piece;
[…]
HANDLE
----------------------------------
MEDIA
----------------------------------
oml4dtid_1_1
(05A999L3) medialabel
•
If the media does not have a bar code identified by NetVault Backup, the format is:
tape_media_label
Sample Output from RMAN CLI
SQL> select handle, media from v$backup_piece;
[…]
HANDLE
-----------------------------------------------------
MEDIA
-----------------------------------------------------
okl4dri2_1_1
(NONE) medialabel
Note the following traits regarding the string shown in the media field:
•
The tape_barcode is shown in parentheses.
•
If there is no tape_media_label, the media label will default to “MMS NetVault Backup Tape”.
•
If a backup piece spans multiple tapes, only the information from one tape is presented.
•
The string is truncated to 60 bytes (60 characters in English). Barcodes are usually 6 or 8 bytes, but the media label can be of variable length. By keeping the media label to a reasonable length, you can ensure that the entire string is shown.
•
If you perform RMAN backups from the NetVault Backup WebUI, the format is:
MMS NetVault Backup Tape
Sample output:
SQL> select handle, media from v$backup_piece;
[…]
HANDLE
-----------------------------------------------------
MEDIA
-----------------------------------------------------
NVSERVER:#376:NVCLIENT:792_709294286:RMAN INCRMTAL LVL 0 ORCL_1264468284
MMS NetVault Backup Tape

Performing CLI-based restores

This form of restore is performed using the RMAN CLI Utility. Through this utility, you can perform restores of backups, regardless of how they were created (that is, either through the plug-in or from the command line). For more information on the RMAN commands, refer to the Oracle Database Backup and Recovery Reference Guide.
 
 
*IMPORTANT: Even though this form of restore is initiated locally from a terminal session on the Oracle Database Server, you can monitor job progress from the Jobs Status page in the NetVault Backup WebUI. However, this applies only to data restores from the media contained in devices controlled by the NetVault Backup Server.

Using the Plug-in with Oracle RAC

•
Oracle RACs – an overview
•
Recommended additional reading
•
Defining a deployment strategy
•
Licensing
•
Installing the plug-in in a RAC environment
•
Configuring the plug-in
•
Backing up data
•
Restoring data in a RAC environment

Oracle RACs – an overview

Oracle Corporation defines Oracle's Real Application Clusters (RAC) option as “support for the transparent deployment of a single database across a cluster of servers, providing fault tolerance from hardware failures or planned outages. Oracle RAC running on clusters provides Oracle’s highest level of capability in terms of availability, scalability, and low-cost computing. Oracle RAC supports mainstream business applications of all kinds. This includes OLTP, DSS, and Oracle’s unique ability to effectively support mixed OLTP/DSS environments. This also includes popular packaged products such as SAP, PeopleSoft, Siebel, and Oracle E*Business Suite, as well as custom applications.”
Plug‑in for Oracle provides support for a limited number of Oracle versions and platforms in a RAC environment. The installation, configuration, backup, and restore procedures differ in a multi-instance RAC environment. This section of the guide offers specifics on how the plug-in operates in an Oracle RAC environment. It only points out the differences between the setup and usage of the plug-in in a multi-instance RAC environment vs. a single-instance or traditional non-RAC environment.
 
 
*IMPORTANT: Unless outlined in the sections that follow, backups and restores performed with the plug-in for multi-instance RAC databases are the same as those performed with single-instance databases.
For a list of supported Oracle versions and platforms in a RAC environment, refer to the Dell NetVault Backup Plug-in Compatibility Guide.
Verwandte Dokumente

The document was helpful.

Bewertung auswählen

I easily found the information I needed.

Bewertung auswählen