RE: RMAN-NetBackup without an RMAN Catalog

What I would like to be able to do is ... 5 years from now, restore _todays_ backup.
Wouldn't I be able to use [then, in 2009], SET UNTIL "13-OCT-04" and RESTORE CONTROLFILE ? The "contradiction" I saw was in the Support Analyst's first point " .. its too far away" and then second point "there's no limit with SET UNTIL ...". Hemant

At 11:00 PM Wednesday, Mercadante, Thomas F wrote:
>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:
>=========
>It seems impossible to restore the backup of 5 years ago without catalog.
>1.Can you list up this backup of 5 years ago? -- it seems impossible
>because it's too far away.
>2.there's no limit with SET UNTIL clause with RESTORE CONTROLFILE unless
>the backup set doesn't exist or the backup record doesn't
>exist in current controlfile. "
>which seems, to me, to be self-contradictory.
>

Hemant K Chitale
http://web.singnet.com.sg/~hkchital                

--
http://www.freelists.org/webpage/oracle-l