-
Hi guys
Could you tell me, how can I test my backup? I mean how
to check the validity of Backup? My database is running in
nonarchive log mode. I am taking Cold backup daily.
Thanks
Rekha
-
Hi Rekha,
Try to restore ur datafiles from ur cold backup will also test your recover skills.
You also have a dbverify utility which you can execute from command prompt to check the validity of the backup data file.The file name differs from version to version so find out the file for your Oracle version
Regards
Santosh
-
The best way to verify your backup is to do a rebuild exercise on a test/development box. It will make sure that you can rely on your backup and will also boost your confidence in case of a real recovery need.
Hope it helps..
Cheers...
-
Dear Snajay & Santosh
Can u tell me the exact steps or commands, How to test that cold backup.
Thanks in advance
Paresh
-
Hi Guys
Please tell me the exact steps how to do it?
(Solaris8, Oracle8.0.5) (Windows98, Oracle8.1.6)
Thanks
Rekha
-
If you use Rman, there is a command called
'validate backupset backupset number ' it will show you whether you will be able to restore your database based on the set you have. Anyway, it is better to do an actual restore to make a peace of mind plus you practice your recovering skills.
Dragon
-
Originally posted by SANJAY_G
The best way to verify your backup is to do a rebuild exercise on a test/development box. It will make sure that you can rely on your backup and will also boost your confidence in case of a real recovery need.
Take a look at the thread. It deals with restoring a full cold backup on a different node.
http://www.dbasupport.com/forums/sho...threadid=10013
Hope it Helps
Anurag
Appreciation is a wonderful thing;
It makes what is excellent in others belong to us as well.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|