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

Datafile media recovery

System Change Number (SCN) Based Point-in-Time Recovery – When an SCN is specified during PIT Recovery, RMAN will recover 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 will recover 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 will recover up to, but not including, the specified time.
For more information on PIT Recovery and database incarnations, refer to Performing Database Point-in-Time Recovery in the Oracle Database Backup and Recovery Basics guide.

Block Media Recovery

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, SQL queries, and so on. 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
Results of the SQL commands ANALYZE TABLE and ANALYZE INDEX
Results of the DBVERIFY utility

Performing User Managed restores

ALTER TABLESPACE <Tablespace Name> OFFLINE IMMEDIATE;

Selecting data for a restore

1
2
On the Create Restore Job - Choose Saveset page, select Plug‑in for Oracle from the Plugin Type list.
When you select a saveset, the following details are displayed in the Saveset Information area: Job ID, Job Title, name of the NetVault Backup Server, name of the client from which the data was backed up, plug-in used to create the saveset, saveset creation date and time, saveset retirement setting, whether it is an Incremental Backup, whether it is an Archive, and saveset size.
6
On the Create Selection Set page, select the data that you want to restore.
*NOTE: For User Managed restores, you do not have to set any other options (the Restore Options tab does not contain any fields).
Verwandte Dokumente

The document was helpful.

Bewertung auswählen

I easily found the information I needed.

Bewertung auswählen