What are the best practices for the location of your control files? We are using ASM for our data files.
Traditionally they have been stored in
$ORACLE_HOME/dbs
A consultant created control files in ASM
SQL> show parameter control_files
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
control_files string +DATA/test/controlfile/current
.ctl, +RECO/test/controlfile/c
urrent.ctl
spfile shows:
*.control_files='+DATA/test/controlfile/current.ctl','+RECO/test/controlfile/current.ctl'
Are there Pros/Cons for either place?
Are there implications for RMAN restore/recover for using ASM?
Are there implication for RMAN Duplicate Database for using ASM?