OraFAQ Forum: Backup & Recovery » What Is The Difference Between Default Controlfile Auotbackup Format And The '%F' We Set

Home » RDBMS Server » Backup & Recovery » What Is The Difference Between Default Controlfile Auotbackup Format And The '%F' We Set (11.2.0.4 SE, SLES SP3)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

What Is The Difference Between Default Controlfile Auotbackup Format And The '%F' We Set [message #650466]

Tue, 26 April 2016 02:40

juniordbanewbie
Messages: 250
Registered: April 2014

Senior Member

Dear all,

before I change my controlfile autobackup format


RMAN> show all;

RMAN configuration parameters for database with db_unique_name ORCL are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 2;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COMPRESSED BACKUPSET PARALLELISM 1;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle2/product/11.2.0.4/dbhome_1/dbs/snapcf_ORCL.f'; # default

Next I change my controlfile autobackup format. It look like the same before.


RMAN> configure CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F';

new RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F';
new RMAN configuration parameters are successfully stored
starting full resync of recovery catalog
full resync complete

RMAN> show CONTROLFILE AUTOBACKUP FORMAT;

RMAN configuration parameters for database with db_unique_name ORCL are:
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F';

I did a backup

RMAN> backup as compressed backupset incremental level 1 database tag 'ORCL_20160426_inc1';

Starting backup at 2016-04-26 14:47:25
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=6 device type=DISK
channel ORA_DISK_1: starting compressed incremental level 1 datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00011 name=/u02/app/oracle2/oradata/ORCL/bigger_next_01.dbf
input datafile file number=00003 name=/u02/app/oracle2/oradata/ORCL/undotbs01.dbf
......


piece handle=/u03/app/oracle2/fast_recovery_area/ORCL/backupset/2016_04_26/o1_mf_nnnd1_ORCL_20160426_INC1_cky3qzo8_.bkp tag=ORCL_20160426_INC1 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:35
Finished backup at 2016-04-26 14:48:02

Starting Control File and SPFILE Autobackup at 2016-04-26 14:48:02
piece handle=/u01/app/oracle2/product/11.2.0.4/dbhome_1/dbs/c-1373321928-20160426-02 comment=NONE
Finished Control File and SPFILE Autobackup at 2016-04-26 14:48:06

so the newly set controlfile autobackup format is /u01/app/oracle2/product/11.2.0.4/dbhome_1/dbs/c-1373321928-20160426-02, ie. c-DBID-YYYY-QQ

next I change to default. It look like the same before.

CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK CLEAR;
show CONTROLFILE AUTOBACKUP FORMAT;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default

next I do a backup

backup as compressed backupset archivelog all tag 'ORCL_20160426_arc' delete input;

Starting backup at 2016-04-26 14:56:06
current log archived
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=10 device type=DISK
channel ORA_DISK_1: starting compressed archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set

channel ORA_DISK_1: deleting archived log(s)
archived log file name=/u03/app/oracle2/fast_recovery_area/ORCL/archivelog/2016_04_26/o1_mf_1_1876_cky486sn_.arc RECID=945 STAMP=910191366
Finished backup at 2016-04-26 14:56:10

Starting Control File and SPFILE Autobackup at 2016-04-26 14:56:10
piece handle=/u03/app/oracle2/fast_recovery_area/ORCL/autobackup/2016_04_26/o1_mf_s_910191371_cky48dft_.bkp comment=NONE
Finished Control File and SPFILE Autobackup at 2016-04-26 14:56:13

controlfile autobackuup format is FAST_RECOVERY_AREA/<db_unique_name>/autobackup/<YYYY-NN_DD>/%....

Show what's the difference between the default controlfile autobackup format and the one we set, aren't they the same?

I mean

CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default

AND

CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F';

They looks the same but behave differently. Is this a bug?

thanks a lot!

Report message to a moderator

Re: What Is The Difference Between Default Controlfile Auotbackup Format And The '%F' We Set [message #650467 is a reply to message #650466]

Tue, 26 April 2016 02:48

Michel Cadot
Messages: 68770
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

Is this a bug?

Only Oracle can answer this question, open a SR and tell us the answer. Smile

Report message to a moderator

Re: What Is The Difference Between Default Controlfile Auotbackup Format And The '%F' We Set [message #650477 is a reply to message #650466]

Tue, 26 April 2016 05:51

John Watson
Messages: 8989
Registered: January 2010
Location: Global Village

Senior Member

This is expected behaviour. If you don't set the destination and have and FRA configured, that is where it goes; if you do set it, on Unix default is $OH/dbs. If you look at v$rman_configuration you'll see that any values set to #default are removed.

Report message to a moderator

Re: What Is The Difference Between Default Controlfile Auotbackup Format And The '%F' We Set [message #650480 is a reply to message #650477]

Tue, 26 April 2016 06:23

EdStevens
Messages: 1377
Registered: September 2013

Senior Member

John - It sounds like you are saying that the string '# DEFAULT' is not just a comment, but actually modifies the behavior. That is what the OP seems to have observed and is asking about. I find nothing about that in the docs.

Report message to a moderator

Re: What Is The Difference Between Default Controlfile Auotbackup Format And The '%F' We Set [message #650481 is a reply to message #650480]

Tue, 26 April 2016 06:35

John Watson
Messages: 8989
Registered: January 2010
Location: Global Village

Senior Member

From the docs,Quote:

If you have set up a fast recovery area for the database, then you can direct control file autobackups to the fast recovery area by clearing the control file autobackup format for disk.

If you look at the view I mentioned you'll see that if you configure a setting it is saved and visible, and that cleared values are removed.

Report message to a moderator

Re: What Is The Difference Between Default Controlfile Auotbackup Format And The '%F' We Set [message #650685 is a reply to message #650481]

Fri, 29 April 2016 08:59

juniordbanewbie
Messages: 250
Registered: April 2014

Senior Member

Yes,

Master John is absolutely right!

rman configuration before setting controlfile autobackup format

RMAN> show all;

using target database control file instead of recovery catalog
RMAN configuration parameters for database with db_unique_name ORCL are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 2;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COMPRESSED BACKUPSET PARALLELISM 1;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle2/product/11.2.0.4/dbhome_1/dbs/snapcf_ORCL.f'; # default

rman_configuration before setting controlfile autobackup format only 4 rows


SYS@ORCL>SELECT * FROM v$rman_configuration;

     CONF# NAME
---------- -----------------------------------------------------------------
VALUE
--------------------------------------------------------------------------------
         1 BACKUP OPTIMIZATION
ON

         2 DEVICE TYPE
DISK BACKUP TYPE TO COMPRESSED BACKUPSET PARALLELISM 1

         3 CONTROLFILE AUTOBACKUP
ON


     CONF# NAME
---------- -----------------------------------------------------------------
VALUE
--------------------------------------------------------------------------------
         4 RETENTION POLICY
TO REDUNDANCY 2

after setting controlfile autobackup


RMAN> CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F';

new RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F';
new RMAN configuration parameters are successfully stored

RMAN> show all;

RMAN configuration parameters for database with db_unique_name ORCL are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 2;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F';
CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COMPRESSED BACKUPSET PARALLELISM 1;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle2/product/11.2.0.4/dbhome_1/dbs/snapcf_ORCL.f'; # default

RMAN>

rman_Configuration after setting controlfile autobackup format 5 rows now


SYS@ORCL>SELECT * FROM v$rman_configuration;

     CONF# NAME
---------- -----------------------------------------------------------------
VALUE
--------------------------------------------------------------------------------
         1 BACKUP OPTIMIZATION
ON

         2 DEVICE TYPE
DISK BACKUP TYPE TO COMPRESSED BACKUPSET PARALLELISM 1

         3 CONTROLFILE AUTOBACKUP
ON


     CONF# NAME
---------- -----------------------------------------------------------------
VALUE
--------------------------------------------------------------------------------
         4 RETENTION POLICY
TO REDUNDANCY 2

         5 CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE
DISK TO '%F'

Can also read MOS Controlfile Autobackup written to ORACLE_HOME/dbs instead of FRA (Doc ID
1305517.1)

thanks to all!

Report message to a moderator

Previous Topic:	issue in Monitoring RMAN job Progress (multiple channels)
Next Topic:	Rman Backup set specification slowness.

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Nov 04 02:45:17 CST 2025