RE: RMAN backup piece validation
- From: "Hariharan, Abhishek" <AHariharan@xxxxxxxxx>
- To: Brent Day <coloradodba@xxxxxxxxx>
- Date: Sun, 22 Sep 2013 23:51:34 +0000
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,
Abhishek
From: Brent Day [mailto:coloradodba@xxxxxxxxx]
Sent: Monday, September 23, 2013 5:11 AM
To: Hariharan, Abhishek
Cc: oracle-l@xxxxxxxxxxxxx
Subject: Re: RMAN backup piece validation
Abhishek,
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.
Brent
On Sun, Sep 22, 2013 at 12:47 PM, Hariharan, Abhishek
<AHariharan@xxxxxxxxx<mailto:AHariharan@xxxxxxxxx>> 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.
Thanks!
Abhishek
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
