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!

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
282 views