Re: Oracle: how to demonstrate successful restore?

On 2006-01-28, Mladen Gogala <gogala_at_sbcglobal.net> wrote:
> On Fri, 27 Jan 2006 21:46:23 +0100, Frank van Bortel wrote:
>
>> But you will be surprised how few companies actually
>> test their DR plan...
>
> It's a business decision. What surprises me is how few people
> actually verify their backups. Here is it all it takes:
> RMAN> restore database validate;
>
> Starting restore at 27-JAN-06
> allocated channel: ORA_DISK_1
> channel ORA_DISK_1: sid=64 devtype=DISK
>
> channel ORA_DISK_1: starting validation of datafile backupset
> channel ORA_DISK_1: reading from backup piece /oradata/back/back_01h9uj59_1_1.bkp
> channel ORA_DISK_1: restored backup piece 1
> piece handle=/oradata/back/back_01h9uj59_1_1.bkp tag=TAG20060127T232632
> channel ORA_DISK_1: validation complete, elapsed time: 00:01:06
> Finished restore at 27-JAN-06
>
> My database wasn't actually restored, only the backup was validated.

        You trust Oracle far too much. The backup isn't validated until that database is running again and the users applications are successfuly using it. There's nothing like actually doing something to prove that it can be done.

[deletia]

-- 
     If you think that an 80G disk can hold HUNDRENDS of           |||
hours of DV video then you obviously haven't used iMovie either.  / | \

 Posted Via Usenet.com Premium Usenet Newsgroup Services
----------------------------------------------------------
    ** SPEED ** RETENTION ** COMPLETION ** ANONYMITY **
----------------------------------------------------------        
                http://www.usenet.com