Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: RMAN-NetBackup without an RMAN Catalog
Hemant,
Why does the last part seem self-contradictory? If I read the response correct, they are saying that you can't restore a control file from a point in time that does not exist (that you do not have a backup for).
I agree that there should probably be a logical syntax check. But I'm guessing that they will leave it up to error reporting to tell you that the backup does not exist from the 5-year-old time-frame.
Does this make sense?
Tom Mercadante
Oracle Certified Professional
-----Original Message-----
From: Hemant K Chitale [mailto:hkchital_at_singnet.com.sg]
Sent: Wednesday, October 13, 2004 10:52 AM
To: Smith, Ron L.
Cc: oracle-l_at_freelists.org
Subject: RE: RMAN-NetBackup without an RMAN Catalog
Ron,
Hmm. I saw the reference in the RMAN User Guide to a limit of 366 days when restoring an AUTOBACKUP CONTROLFILE without a CATALOG.
However, the Reference Guide on the syntax of the SET UNTIL command does not specify any restriction.
In response to my TAR where I stated :
"I am using RMAN with Veritas NetBackup with NO Catalog. CONTROLFILE
AUTOBACKUP ON is configured and the controlfile is being backed up. I can
restore the latest controlfile. However, I wish to be able to restore
*older* control files -- going as far back as 5 years. Is that possible ?
Does the SET UNTIL clause with RESTORE CONTROLFILE have any limits ?"
I got this from the Support Analyst :
"UPDATE:
At 11:15 PM Tuesday, you wrote:
I thought the limit on RMAN backup retention was 365 days without a Catalog?
Ron
-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
On Behalf Of Hemant K Chitale
Sent: Tuesday, October 12, 2004 10:10 AM
To: oracle-l_at_freelists.org
Subject: RMAN-NetBackup without an RMAN Catalog
When using RMAN and Netbackup without a RMAN Catalog database, how do you set retention for 5 years -- eg if the controlfile is backed-up as autobackup.
How do you restore a database as of a specific day [e.g. 3 months ago] ?
Hemant K Chitale
Hemant K Chitale
http://web.singnet.com.sg/~hkchital
-- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-lReceived on Wed Oct 13 2004 - 09:55:57 CDT
![]() |
![]() |