Hi, we're newbie to Oracle Database. Flash Recovery Area is configured our database (11gR2). We just note that when backup to disk, a copy will be backup to FRA configured, while if we backup to tape, there is no copy created in FRA.
Attached please find the rman script we're using for backup to disk:
---------------------- cut here ----------------------
connect target /
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/home/oracle/scripts/backup/poim/output/%F';
run{
allocate channel t1 device type disk maxpiecesize 2 G;
sql 'alter system archive log current';
BACKUP
spfile
format '/home/oracle/scripts/backup/poim/output/spfile_%d_%s_%T.bak';
BACKUP
incremental level 0
database include current controlfile plus archivelog
format '/home/oracle/scripts/backup/poim/output/full_poim_%u_%p_%s.bkp';
sql 'alter system archive log current';
BACKUP
archivelog all
format '/home/oracle/scripts/backup/poim/output/archivelog_%d_%u_%s_%T.bkp';
BACKUP
current controlfile
format '/home/oracle/scripts/backup/poim/output/control_%t_dbid%I';
release channel t1;
}
---------------------- cut here ----------------------
Some newbie questions need your advice:
- why backup to tape won't create a copy of backup in FRA?
- if it possible to skip backing up to FRA without disabling FRA?
- how to clean up backupset in FRA? I current remove them with ASMCMD, and do a crosscheck backup afterwards.
Would anyone please help? Thanks and regards