Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: RMAN-NetBackup without an RMAN Catalog

RE: RMAN-NetBackup without an RMAN Catalog

From: Mercadante, Thomas F <>
Date: Wed, 13 Oct 2004 11:00:26 -0400
Message-ID: <C9995D8C5E0DDA4A8FF9D68EE666CE07A7F97C@exchsen0a1ma>


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 [] Sent: Wednesday, October 13, 2004 10:52 AM To: Smith, Ron L.
Subject: RE: RMAN-NetBackup without an RMAN Catalog


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 :

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?


-----Original Message-----
From: [] On Behalf Of Hemant K Chitale
Sent: Tuesday, October 12, 2004 10:10 AM To:
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                

Received on Wed Oct 13 2004 - 09:55:57 CDT

Original text of this message