RE: RMAN backup piece validation

From: Hariharan, Abhishek <>
Date: Sun, 22 Sep 2013 23:51:34 +0000
Message-ID: <3988DC0AA8B69D4FA85804032870CD6C0EF8998B_at_CDC-EXUSMBP4.ciber.CBR.INC>

Ok. But just keeping the backup pieces in mind, it can be checked up to a 100% using the restore...validate command right? Kind Regards,

From: Brent Day [] Sent: Monday, September 23, 2013 5:11 AM To: Hariharan, Abhishek
Subject: Re: RMAN backup piece validation


You are not just testing validate of the backup files but the procedures and process along with brining a database up after a restore. This is part of due diligence we have asked you to perform. The worst thing for any DBAs career is lost data/invalid backups and a need to restore and unable to do so. Companies often go out of business when they have a catastrophic event and are unable to recover databases, etc.


On Sun, Sep 22, 2013 at 12:47 PM, Hariharan, Abhishek <<>> wrote: I thought and still think that restore validate command is good enough for us to make sure that all the blocks in the RMAN backups are intact. Is there really a need to physically restore the DB instead of using the restore validate command JUST and JUST to make sure the backups are intact?

From the Oracle Docs.. below
Validating Backups Before Restoring Them You can run RESTORE ... VALIDATE to test whether RMAN can restore a specific file or set of files from a backup. RMAN chooses which backups to use. The database must be mounted or open for this command. You do not have to take datafiles offline when validating the restore of datafiles, because validation of backups of the datafiles only reads the backups and does not affect the production datafiles. When validating files on disk or tape, RMAN reads all blocks in the backup piece or image copy. RMAN also validates offsite backups. The validation is identical to a real restore operation except that RMAN does not write output files.



-- Received on Mon Sep 23 2013 - 01:51:34 CEST

Original text of this message