RE: RMAN-NetBackup without an RMAN Catalog

From: Hemant K Chitale <hkchital_at_singnet.com.sg>
Date: Wed, 13 Oct 2004 22:52:19 +0800
Message-Id: <6.1.2.0.0.20041013224427.024804a0@pop.singnet.com.sg>

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_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

Received on Wed Oct 13 2004 - 09:49:56 CDT