RE: RMAN-NetBackup without an RMAN Catalog
- From: Hemant K Chitale <hkchital@xxxxxxxxxxxxxx>
- To: "Smith, Ron L." <rlsmith@xxxxxxx>
- Date: Wed, 13 Oct 2004 22:52:19 +0800
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
Other related posts:
