RE: RMAN-NetBackup without an RMAN Catalog
- From: Hemant K Chitale <hkchital@xxxxxxxxxxxxxx>
- To: thomas.mercadante@xxxxxxxxxxxxxxxxx
- Date: Wed, 13 Oct 2004 23:09:55 +0800
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@xxxxxxxxxxxxxx]
>Sent: Wednesday, October 13, 2004 10:52 AM
>To: Smith, Ron L.
>Cc: oracle-l@xxxxxxxxxxxxx
>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
- References:
- RE: RMAN-NetBackup without an RMAN Catalog
- From: Mercadante, Thomas F
Other related posts:
- » RMAN-NetBackup without an RMAN Catalog
- » RE: RMAN-NetBackup without an RMAN Catalog
- » RE: RMAN-NetBackup without an RMAN Catalog
- » RE: RMAN-NetBackup without an RMAN Catalog
- » RE: RMAN-NetBackup without an RMAN Catalog
- » RE: RMAN-NetBackup without an RMAN Catalog
- » RE: RMAN-NetBackup without an RMAN Catalog
- » RE: RMAN-NetBackup without an RMAN Catalog
- » Re: RMAN-NetBackup without an RMAN Catalog
- » RE: RMAN-NetBackup without an RMAN Catalog
- » RE: RMAN-NetBackup without an RMAN Catalog
- » RE: RMAN-NetBackup without an RMAN Catalog
- » Re: RMAN-NetBackup without an RMAN Catalog
- » RE: RMAN-NetBackup without an RMAN Catalog
- » Re: RMAN-NetBackup without an RMAN Catalog
- » RE: RMAN-NetBackup without an RMAN Catalog
- RE: RMAN-NetBackup without an RMAN Catalog
- From: Mercadante, Thomas F