Hi all,
{OS is Windows 8, Oracle 11gR2}
Pls I need some clarification regarding RMAN controlfile autobackup filename format and location.
From what I understand, the default for RMAN controlfile autobackup format and location. is ' CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default '
I also understand the '%F' means that the controlfile name after backup will include the DBID and date of backup and also that the default location is a AUTOBACKUP folder in your FLASH RECOVER AREA.
My issue is that the controlfile format name after backup doesn't appear that way, it doesn't include the DBID and date of backup thought its in the default location. See below
Starting Control File and SPFILE Autobackup at 12-NOV-15
piece handle=D:\APP\ORACLE\FLASH_RECOVERY_AREA\ORCL\AUTOBACKUP\2015_11_12\O1_MF_S_895580297_C48XCT97_.BKP comment=NONE
Finished Control File and SPFILE Autobackup at 12-NOV-15
BUT
if i alter the format to exactly that the default is, i e
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
I get the below after backup,
Starting Control File and SPFILE Autobackup at 12-NOV-15
piece handle=D:\APP\ORACLE\PRODUCT\11.2.0\DBHOME_1\DATABASE\C-1420251868-20151112-04 comment=NONE
Finished Control File and SPFILE Autobackup at 12-NOV-15
This shows that the controlfile name format is what is expected but the default location is not in the flash recovery are.
Can someone please explain. Thanks
Why the discussion is because I need find the DBID of a drop database and all i have is the controlfile autobackup which is meant to include the DBID as part of its name but it doesn't.