Home » RDBMS Server » Backup & Recovery » Dual backup strategy, backup to FRA and tape (AIX 5.3 Oracle 10.0.2)
Dual backup strategy, backup to FRA and tape [message #313993] Tue, 15 April 2008 07:44
asneville
Messages: 1
Registered: April 2008
Junior Member
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;
    }
Previous Topic: Rman and delete obsolete files..
Next Topic: Flashback for Oracle 10g
Goto Forum:
  


Current Time: Wed Dec 07 18:30:01 CST 2016

Total time taken to generate the page: 0.21064 seconds