This a a little discovery from my present Oracle Database 12c New Features course in Copenhagen: The default setting for Controlfile Autobackup has changed to ON – but only for Multitenant, apparently:
$ rman target sys/oracle_4U@cdb1 Recovery Manager: Release 12.1.0.1.0 - Production on Wed Sep 24 13:28:39 2014 Copyright (c) 1982, 2013, Oracle and/or its affiliates. All rights reserved. connected to target database: CDB1 (DBID=832467154) RMAN> select cdb from v$database; using target database control file instead of recovery catalog CDB --- YES RMAN> show controlfile autobackup; RMAN configuration parameters for database with db_unique_name CDB1 are: CONFIGURE CONTROLFILE AUTOBACKUP ON; # default
Above you see the setting for a container database (CDB). Now an ordinary (Non-CDB) 12c Database:
$ rman target sys/oracle_4U@orcl Recovery Manager: Release 12.1.0.1.0 - Production on Wed Sep 24 13:33:27 2014 Copyright (c) 1982, 2013, Oracle and/or its affiliates. All rights reserved. connected to target database: ORCL (DBID=1386527354) RMAN> select cdb from v$database; using target database control file instead of recovery catalog CDB --- NO RMAN> show controlfile autobackup; RMAN configuration parameters for database with db_unique_name ORCL are: CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default
I really wonder why we have this difference! Is that still so with 12.1.0.2? Don’t believe it, test it! 🙂
Pickleball spielen 
#1 von Horia Berca am September 24, 2014 - 19:02
Still there in 12.1.0.2
rman target sys/welcome1@orcl
Recovery Manager: Release 12.1.0.2.0 – Production on Wed Sep 24 13:00:19 2014
Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved.
connected to target database: ORCL (DBID=1382119978)
RMAN> select cdb from v$database;
using target database control file instead of recovery catalog
CDB
—
NO
RMAN> show controlfile autobackup;
RMAN configuration parameters for database with db_unique_name ORCL are:
CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default
Thanks for the post Uwe!