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

Choosing the restore source

When FRA is enabled, the plug-in lets you define a media destination strategy that balances requirements while speeding up restores by specifying the Destination Backup Options on the Backup Options tab. These options let you select the destination for the backup. They include:
The plug-in provides you with the option during the restore process to define the Restore Source or location that RMAN should use as the source for the restore. This option lets you speed up restores by ensuring that RMAN restores from the FRA or from the NetVault Backup media. With this option, you can:
Additionally, you can use these same Restore Source options when you have performed CLI-based backups to Disk by allocating a channel to Disk but you want to use the plug-in to perform the restore.
Tape (Restore from NetVault Backup Media: When selected, RMAN opens an “SBT_TAPE” channel and reads the backup files from the backup media that is managed by NetVault Backup and specified in the Device options section of the Target tab. Select this option if an FRA-backup-destination strategy has not been implemented or the Backup Destination of Tape was selected for all backups.
Disk (Restore from FRA or Disk): When selected, RMAN only opens a DISK device type and restores the backup files from the FRA or the OS-specific directory specified when configuring RMAN’s DISK device type. This option is the default.
Both Tape and Disk (Restore from both NetVault Backup Media and (FRA or Disk)): When selected, RMAN opens an “SBT_TAPE” channel and a DISK channel, which allows RMAN the flexibility to choose the best source for the recovery files. Select this option if your backup destination strategy includes the Both Tape and Disk option or you have chosen to store backup recovery files in the FRA while performing Flash Recovery Area Backups on a different, independent schedule.

Datafile media recovery

System Change Number (SCN) Based Point-in-Time Recovery: When an SCN is specified during PIT Recovery, RMAN recovers up to, but not including, the specified SCN. For example, if SCN 1000 is specified, recovery up to SCN 999 is performed.
Log Sequence Number (LSN) Based Point-in-Time Recovery: When the exact time of the data corruption or failure is not known, specifying a Log Sequence Number that contains the target SCN is a viable option. RMAN recovers through the specified log. V$LOG_HISTORY can be queried to view the logs that have been archived to identify the appropriate log sequence number and thread.
Time Based Point-in-Time Recovery: Time-based PIT Recovery is useful when the time that the data corruption occurred is known. For example, if a developer dropped a table at 6:00 a.m., PIT Recovery can be performed with a stop time of 5:55 a.m. The plug-in recovers up to, but not including, the specified time.
For more information on PIT Recovery and database incarnations, see Performing Database Point-in-Time Recovery in the Oracle® Database Backup and Recovery Basics guide.

Block Media Recovery

Block Media Recovery is only available in the Oracle® Enterprise Edition. This feature reduces downtime by letting you recover only the blocks that were corrupted instead of restoring and recovering the entire datafile. Block Media Recovery is most useful for physical corruption problems that involve a small, well-known number of blocks. Block-level data loss usually results from intermittent, random I/O errors that do not cause widespread data loss, and memory corruptions that get written to disk. Block Media Recovery is not intended for cases where the extent of data loss or corruption is unknown and the entire datafile requires recovery. In such cases, Datafile Media Recovery is the best solution.
In addition to running the Oracle® Enterprise Edition, Oracle requires the following prerequisites for Block Media Recovery to be met as defined in Performing Block Media Recovery of the Oracle Database Backup and Recovery User’s Guide.
The target database must run in ARCHIVELOG mode and be open or mounted with a current Control File.
The V$DATABASE_BLOCK_CORRUPTION view displays blocks marked corrupt by database components such as RMAN commands, ANALYZE, and SQL queries. Physical corruption, sometimes called media corruption, results in rows being added to this view. For example, the database does not recognize the block: the checksum is invalid, the block contains all zeros, or the block header is fractured.
In addition to being reported in V$DATABASE_BLOCK_CORRUPTION, block corruption is also reported in the following locations:
Results of the LIST FAILURE, VALIDATE, or BACKUP … VALIDATE command
Oracle® Alert Log
Results of the SQL commands ANALYZE TABLE and ANALYZE INDEX
Results of the DBVERIFY utility

Performing User Managed restores

You do not have to take a complete Oracle® Database offline to restore selected tablespaces, but you must take each tablespace that you want to restore offline before performing the restore.
ALTER TABLESPACE <Tablespace Name> OFFLINE IMMEDIATE;
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating