Controlfile confusion
- From: "J. Dex" <cemail_219@xxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 15 Jan 2009 21:58:12 -0500
I inherited a script that runs an rman nocatalog cold backup in a 10.2.0.3
database. There appears to be 3 different copies of the controlfile that get
generated. In the event of a restore, will there be an issue if any of them
are missing? Which one would the restore use? Here is the scenario:
1. In the rman configuration, ‘CONFIGURE SNAPSHOT CONTROLFILE NAME TO ..’is
left at default so a copy of the controlfile goes to the $ORACLE_HOME/dbs
directory.
In looking at the log, there is also an autobackup of the controlfile that
goes to the flashback_recovery_dest which is determined by the database setting
(which is a different directory than the backup directory mount point that the
backup piece itself is actually going to). Shouldn’t flashback_recovery_dest
be set to the same directory as the backup itself? If there were a restore
and the file in the flashback_recovery_dest is not there, but still have the
one that is located in the /dbs directory, will there be any issues?
3. After the database is restarted and opened, the script does an alter
database backup controlfile to trace. Is this 3rd backup controlfile even
worth anything since it is run after the database is re-opened?
_________________________________________________________________
Windows Live™: Keep your life in sync.
http://windowslive.com/explore?ocid=TXT_TAGLM_WL_t1_allup_explore_012009
Other related posts:
