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