Home » RDBMS Server » Backup & Recovery » RMAN-Differential,Cumulative and Full Backup
RMAN-Differential,Cumulative and Full Backup [message #188824] Mon, 21 August 2006 22:01
mymot
Messages: 225
Registered: July 2005
Senior Member
Hi,

If i want to use below backup strategy to backup oracle 9i db on sun solaris.

Strategy 1>Incrementally Updated

Strategy 2
A>Differential Daily
B>Cumulative Weekly
C>Full Backup Monthly



Strategy 1>Run below on twice 1 week

Start RMAN
RUN {
   RECOVER COPY OF DATABASE WITH TAG 'diff_update' UNTIL TIME 'SYSDATE - 7';
   BACKUP INCREMENTAL LEVEL 1 FOR RECOVER OF COPY WITH TAG 'diff_update'
       DATABASE;
   }



A- Run Monday to Sat
RMAN>
RUN {
     BACKUP INCREMENTAL LEVEL 1 DATABASE;
   }

B - Sun
RMAN>
RUN {
 BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE;
}

c- END of month 
RMAN>BACKUP DATABASE;  
RMAN> SQL 'ALTER SYSTEM ARCHIVE LOG CURRENT'; 



I believe that strategy 1 is obviously faster recovery option

in case of strategy 2-C, how can i find out and run script on each last day of each month on rman

Is strategy 2 is better?

its 24*7 opertaions.

Thanks


[Updated on: Mon, 21 August 2006 22:07]

Report message to a moderator

Previous Topic: Block corrupted
Next Topic: how to back up and restore the tables
Goto Forum:
  


Current Time: Thu May 02 13:47:41 CDT 2024