Hi all.
I'm using Oracle Database 11g Rel2 and hit error RMAN-06172 when trying to restore controlfile from autobackup following this procedure:
RMAN> startup force nomount;
RMAN> run
2> {SET CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F';
3> restore spfile from autobackup;
4> }
I find out RMAN was trying to restore the controlfile from the FRA. Unfortunately, there were no files to restore from FRA, and obviously the reported error.
I have a script that stores RMAN backups on an external device (NAS - incremental update backup), so i tried to recover the controlfile using a command similiar to this:
RMAN> run {
set controlfile autobackup format for device type disk to 'B:\backup\RMAN\TEST\%F';
restore controlfile from autobackup maxdays 40;
}
To my surprise no copies of the controlfile were not found there either.
So i figure all controlfiles copies were going to the FRA instead of NAS directory.
This is the default configuration:
RMAN> show all;
se utiliza el archivo de control de la base de datos destino en lugar del catßlo
go de recuperaci¾n
Los parßmetros de configuraci¾n de RMAN para la base de datos con db_unique_name
TEST son:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;
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 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 'D:\APP\ADMINISTRADOR\11.2.0\DBHOME_1\DATABASE\SNCFCABPROD.ORA'; # default
The RMAN script similar to this:
run {
allocate channel c1 type disk format 'B:\backup\RMAN\TEST\bk_bd_ORCL_%U.BAK';
recover copy of database with tag 'incr_update' until time 'sysdate-6';
backup incremental level 1 for recover of copy with tag 'incr_update' database
plus archivelog delete input;
}
delete noprompt obsolete;
I'd like to make sure the controlfile autobackup is set to both FRA and NAS directory. Is this possible?
I mean, to copy to NAS directoty i would code something like this:
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO ‘B:\backup\RMAN\TEST\%F’;
Please advice accordingly.
Thanks in advance!!!