Hi
I'm trying to use RMAN to maintain a 'copy' of my database in the Flash Recovery Area, using incremental backups to keep the copy half a day behind my live database. The idea is to have near instant recovery via a datafile switch if needed.
In addition I need to backup to tape for disaster recovery, and longer term backup retention.
I use tagging to make sure the incremental backups are relative to the correct FULL backups, the problem is that the recovery of the FRA copy always attempts to use the tape incremental and fails with RMAN-05019. Although I specify a disk channel, and there are backups available RMAN still goes for the backups on tape.
Has anybody successfully deployed a dual strategy of backup to FRA and tape.
My RMAN is as follows,
FULL backup to tape (Weekly)
=============================
run {
allocate channel ch1 type 'SBT_TAPE';
allocate channel ch2 type 'SBT_TAPE';
send "NB_ORA_POLICY=ORAclus_CPSDBPRE";
send "NB_ORA_CLIENT=cb20cpsdbpre";
send "NB_ORA_SCHED=CPSPT1+full+db";
backup
incremental level=0
check logical
filesperset 20
format "oracle/bk_%I_%s_%p_%t"
tag "full_CPSPT1"
(database );
sql "alter system archive log current";
sql "alter system archive log current";
backup
filesperset 50
format "oracle/al_%I_%s_%p_%t"
archivelog all not backed up 2 times;
release channel ch1;
release channel ch2;
}
Incremental backup to tape (daily)
===================================
run {
allocate channel ch1 type 'SBT_TAPE';
allocate channel ch2 type 'SBT_TAPE';
send "NB_ORA_POLICY=ORAclus_CPSDBPRE";
send "NB_ORA_CLIENT=cb20cpsdbpre";
send "NB_ORA_SCHED=CPSPT1+cinc+db";
backup
incremental level=1 cumulative
check logical
filesperset 20
format "oracle/bk_%I_%s_%p_%t"
for recover of tag "full_CPSPT1"
tag "inc_CPSPT1"
(database );
sql "alter system archive log current";
sql "alter system archive log current";
backup
filesperset 50
format "oracle/al_%I_%s_%p_%t"
archivelog all not backed up 2 times;
release channel ch1;
release channel ch2;
}
Incremental to FRA and database copy roll forward (daily)
==========================================================
run {
allocate channel ch1 type disk;
allocate channel ch2 type disk;
recover copy of database with
tag 'CPSPT1_fra_backup'
until time 'SYSDATE - 0.5'
from tag 'CPSPT1_fra_incremental';
backup incremental level 1 cumulative
tag 'CPSPT1_fra_incremental'
for recover of copy
with tag 'CPSPT1_fra_backup'
check logical database;
sql "alter system archive log current";
release channel ch1;
release channel ch2;
}
] 
Blog
Search
Help
Members
Register
Login
Home
