When running backup with control autobackup enabled, even though the destination was not set and by default it sould be created in fast recovery area, the autobackup file was created in Oracle Home.
RMAN> show all;
RMAN configuration parameters for database with db_unique_name SAPCC are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 8 DAYS;
CONFIGURE BACKUP OPTIMIZATION OFF; # default
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 PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
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/oracle/product/11.2.0/dbhome_1/dbs/snapcf_sapcc1.f'; # default
RMAN> backup incremental level 0 database plus archivelog;
........
Starting Control File and SPFILE Autobackup at 29-AUG-12
piece handle=/u01/app/oracle/product/11.2.0/dbhome_1/dbs/c-1925572543-20120829-02 comment=NONE
Finished Control File and SPFILE Autobackup at 29-AUG-12
RMAN> CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK CLEAR;
old RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F';
RMAN configuration parameters are successfully reset to default value
RMAN> backup incremental level 0 database plus archivelog;
.......
Starting Control File and SPFILE Autobackup at 29-AUG-12
piece handle=+FRA/sapcc/autobackup/2012_08_29/s_792594079.266.792594081 comment=NONE
Finished Control File and SPFILE Autobackup at 29-AUG-12
RMAN>
Thanks
ReplyDelete