In Oracle : How to validate a backup in an Oracle database

Oracle Applications EBS 11i, R12      Oracle Database      Data Warehouse & BI      Oracle Middleware      PL/SQL      Linux ...

Oracle DBA

Real Application Cluster (RAC) Maintenance tasks Backup and Recovery Database Architecture Replication Oracle Performance Tuning Oracle DBA - Other articles Oracle scripts/ Selects for DBA Oracle Errors (ORA-nnnnn)

The last articles in the site (HOT)

The most visited articles in the site

In-Oracle.com  -> Oracle DBA -> Oracle Database Backup and Recovery

-> How to validate a backup in an Oracle database

 

 How to validate a backup in an Oracle database

 

 

Here are the main topics for this article:

 

1. Validating a logical export (taken using exp utility)

2. Validate a physical backup (taken using RMAN "image copy" option or by copying the files at the OS level)

3. Validating a RMAN backup (using the Backup Sets)

 

 

1. Validating a logical export (taken using exp utility)

 

First we have to take a look to the export log file. Also, we can import the data in another database to see if the import is done without errors. 

2. Validate a physical backup (taken using RMAN "image copy" option or by copying the files at the OS level)

 

In this case we have to validate the .dbf files. This is done by using DBVERIFY Utility. 

 

 

How to validate an Oracle database backup

 

Total Pages Examined: Number of blocks in the file

Total Pages Processed: Number of blocks verified

Total Pages Failing: Number of blocks that failed the data/ index/ segment block check

Total Pages Marked Corrupt: Number of corrupted blocks 

Total Pages Influx: Number of blocks being read and written to in parallel.

 

 

3. Validating a RMAN backup (using the Backup Sets)

 

a) RMAN>  RECOVER DATABASE VALIDATE;  

 

How to validate an Oracle database backup

 

If there are no errors during the recovery ... validate, the backup is good. This command (recovery database validate) doesn't recover the database; only the check is done.

 

b) RMAN> VALIDATE BACKUPSET <backupset_nr>

 

How to validate an Oracle database backup

 

To find the backup set of the backups we can run the RMAN command LIST BACKUP;

 

c) using RMAN report options, like REPORT UNRECOVERABLE DATABASE; (examine all datafiles, but not the archivelog files !!!)

 

 

In-Oracle.com  -> Oracle DBA -> Oracle Database Backup and Recovery

-> How to validate a backup in an Oracle database

Oracle Applications EBS 11i, R12      Oracle Database      Data Warehouse & BI      Oracle Middleware      PL/SQL      Linux ...

 

     Copyright (c) 2011-2015  www.in-oracle.com  |  Disclaimer: The views expressed on this web site are my own and do not reflect the views of Oracle Corporation. You may use the information from this site only at your risk.