RE: RMAN-NetBackup without an RMAN Catalog
- From: "Mercadante, Thomas F" <thomas.mercadante@xxxxxxxxxxxxxxxxx>
- To: "'hkchital@xxxxxxxxxxxxxx'" <hkchital@xxxxxxxxxxxxxx>, "Smith, Ron L." <rlsmith@xxxxxxx>
- Date: Wed, 13 Oct 2004 11:00:26 -0400
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.
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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Hemant K Chitale
Sent: Tuesday, October 12, 2004 10:10 AM
To: oracle-l@xxxxxxxxxxxxx
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
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
