| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Methods for testing RMAN backups?
Do you have autobackup controlfile on for Netbackup, if you can. Also did
tell Netbackup to "backup incremental level 0
( database include current controlfile );" If it is not specified it won't back it up. I am not familiar with Netbackup so I am just thinking of possible reasons.
HTH,
Ruth
-----Original Message-----
From: Smith, Ron L. [mailto:rlsmith_at_kmg.com]
Sent: Tuesday, October 25, 2005 2:24 PM
To: rgramolini_at_tax.state.vt.us; premjhere_at_gmail.com
Cc: oracle-l
Subject: RE: Methods for testing RMAN backups?
Just a note about a recent experience. I had tested RMAN recovery using an RMAN production backup that I FTP'ed from our production server to a test server. Everything went great. Did it several times with no problems.
Then I had the Unix admins restore a production backup from Netbackup to the same test server. This time the recovery failed because it did not copy the control file as it should have. I tried it several times with the same result. I haven't had time to try a backup from another day, but it does have me concerned.
Ron
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Ruth Gramolini
Sent: Tuesday, October 25, 2005 11:59 AM
To: premjhere_at_gmail.com
Cc: oracle-l
Subject: RE: Methods for testing RMAN backups?
I do this on all of my backups, production and other. It doesn't hurt anything. But you should also try to do a real restore and recovery from a dropped table for example to make sure you know how to do this.
HTH,
Ruth
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Prem
Sent: Tuesday, October 25, 2005 10:21 AM
To: Thomas.Mercadante_at_labor.state.ny.us; oracle-l_at_freelists.org
Subject: RE: Methods for testing RMAN backups?
Hi Tom,
RMAN>restore database validate;
Hope you do this on your production systems. Just wanted to confirm that it doesn't mess up anything :) I have long wanted to do this, but don't know whether there is any other issue doing this ?
I am on 9.2.0.6 / Solaris 8.
What's the version you do it on ? Have you tried it on 8i systems ?
Thanks in advance.
Regards,
Prem Khanna J
Vanessa,
A good first test is to validate your backup. Simply allocate a channel and issue a "restore database validate;". This does everything that a restore would do except it does not touch the database. Validate both your database and archivelog backups. This will prove that you can get the backups off of tape or from disk, depending on the type of backup you are doing. I run a validate backup every week for all of our databases.
After this, I would insist on performing a complete restore just so that you know it can be done.
Good Luck!
Tom
-- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-l Important Notice!! If you are not the intended recipient of this e-mail message, any use, distribution or copying of the message is prohibited. Please let me know immediately by return e-mail if you have received this message by mistake, then delete the e-mail message. Thank you. -- http://www.freelists.org/webpage/oracle-lReceived on Tue Oct 25 2005 - 14:22:31 CDT
 |
 |