Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Abount RMAN 'CONTROLFILE AUTOBACKUP FORMAT'

carragomNov 24 2024 — edited Nov 24 2024

Hi,

Using RMAN for database backups on 19c and I have the following configuration parameters set:

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

I'm following the docs here and as you can see the format directive is using the default value of ‘%F’ which according to the docs here should end up as c-IIIIIIIIII-YYYYMMDD-QQ.

I'm using Fast Recovery Area and that is where my backups go by default. Now when I run a backup like this:

BACKUP AS COMPRESSED BACKUPSET INCREMENTAL LEVEL 1 DATABASE TAG ‘LEVEL1’ PLUS ARCHIVELOG TAG 'ARCHIVELOG' DELETE INPUT;

Everything works fine except the file naming of the autobackup which ends up something like $FRA_PATH/$SID/autobackup/YYYY_MM_DD/o1_mf_s_1185812120_mn4nzsbt_.bkp.

I'm using Oracle Managed Files on this specific instance, but the same is observed without OMF and in older versions too.

I guessing this is documented somewhere but I can't find. Can anyone show me where is this behavior documented so I can understand it better?

Comments
Post Details
Added on Nov 24 2024
1 comment
58 views