The analyst is right! The Oracle documentation sometimes can be a pain
but yes the analyst is correct. As your backup is going into a catalog,
you don't need anything to do with the controlfile.
Of course, the Controlfile controls everything including RMAN but in
this particular instance, the catalog will keep the record. I am writing
this because we use this here.
D
-----Original Message-----
From: debra
[mailto:oracledba-ezmlmshield-x39198343.[Email address protected]
Sent: 01 September 2006 18:12
To: LazyDBA Discussion
Subject: control_file_record_keep_time and RMAN catalog
Question: If a database is backed up using an rman catalog, but the
control_file_record_keep_time is set to zero, will the rman backups be
reliable for restore?
Openned a metalink ticket, analyst says:
Your RMAN backups will be usable because you are using an RMAN catalog.
The records in the control file always get truncated, regardless if the
control_file_record_keep_time is set to 0 or 7 (for example).
The problems with control_file_record_keep_time = 0 start only when NOT
using an RMAN catalog
Oracle documentation says:
...there is a possibility that backup records may be overwritten in the
control file before RMAN is able to add them to the catalog.
Does anyone know which is correct?... or should I ask under what
conditions perhaps they are both correct? I am presently working on this
as a production issue...
Thanks in advance for your feedback..
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
This e-mail (and any attachments) contains information, which is confidential and intended solely for the attention and use of the named addressee(s). If you are not the intended recipient you must not copy, distribute or use it for any purpose or disclose the contents to any person. If you have received this e-mail in error, please notify us immediately at [Email address protected] The information contained in this e-mail (and any attachments) is supplied in good faith, but the sender shall not be under any liability in damages or otherwise for any reliance that may be placed upon it by the recipient. Any comments or opinions expressed are those of the originator not of NTT Europe Ltd unless otherwise expressly stated.
Oracle LazyDBA home page