| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: RMAN retention policy
The recovery window thing always hurts my head. The recovery window time (7
days) is the number of days that RMAN should be able to recover the
database. So.... it's like this:
Day 1 Full Can recover to day 1
Day 2 Inc Can recover to day 1,2
Day 3 Inc Can recover to day 1,2,3
Day 4 Inc Can recover to day 1,2,3,4
Day 5 Inc Can recover to day 1,2,3,4,5
Day 6 Inc Can recover to day 1,2,3,4,5,6
Day 7 Inc Can recover to day 1,2,3,4,5,6,7
Day 8 Full Can recover to day 1,2,3,4,5,6,7,8
Must be able to recover to day 2 (so full is needed)
Day 9 Inc Can recover to day 1,2,3,4,5,6,7,8,9
Must be able to recover to day 3 (need full day 1 still)
Day 10 Inc Can recover to day 1,2,3....10
Must recover to day 4 (need full day 1 still)
Day 11 Inc Can recover to day 1,2,3.....11
Must recover to day 5 (need full day 1 still)
Day 12 Inc Can recover to day 1,2,3....12
Must recover to day 6 (need full day 1 still)
Day 13 Inc Can recover to day 1,2,3....13
Must recover to day 7 (need full day 1 still)
Day 14 Inc Can recover to day 8....14
Must recover to day 8 (No need for day 1 full, it's removed
as are incrementals.)
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
To: oracle-l_at_freelists.org
Sent: 8/13/2004 9:37 AM
Subject: RMAN retention policy
Hi guys, env: Oracle 9204 and Win2k.=20
We have scheduled a RMAN full backup every thursday and incremental = every other day. With a retention policy of 7 days, we are having old = backup files not erased for several days. Yesterday the full backup = erased arch and control files from Jul 29 through Aug 5, and the day = before yesterday the incremental erased backup incremental and control = files from Jul 30 through Aug 4.=20
So, What is the sense of having retention policy of 7 days if we have to
=
keep files for more than 7 days? I suppossed that the incremental =
running the other days had to erase files older that 7 days and not to =
wait for the full to do this job at thursday, at this moment the oldest
=
full file is from Jul 29, so, why the full didnt erase that file =
yesterday?=20
Is that a normal behavior or am I missing something from the fine = manual?
--Here is the configuration file and the full and incremental file.
CONFIGURE DEFAULT DEVICE TYPE TO DISK;
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO =
'f:\oracle\rman-backup\backup-files\ctrlfile_%F';
--Full (every thursday)
@@config.rcv
CROSSCHECK ARCHIVELOG ALL;=20
BACKUP INCREMENTAL LEVEL 0 DATABASE FORMAT =
'f:\oracle\rman-backup\backup-files\full_%t_s%s_s%p';
BACKUP ARCHIVELOG ALL DELETE ALL INPUT FORMAT =
'f:\oracle\rman-backup\backup-files\archlogs_%t_s%s_s%p';
LIST BACKUP SUMMARY;
LIST BACKUP BY FILE;
LIST COPY OF CONTROLFILE DATABASE ARCHIVELOG ALL;
LIST EXPIRED BACKUP OF CONTROLFILE DATABASE ARCHIVELOG ALL;
LIST EXPIRED COPY OF CONTROLFILE DATABASE ARCHIVELOG ALL;
REPORT OBSOLETE RECOVERY WINDOW OF 7 DAYS;
DELETE OBSOLETE;
--Incremental (every other day)
@@config.rcv
CROSSCHECK ARCHIVELOG ALL;=20
BACKUP INCREMENTAL LEVEL 1 DATABASE FORMAT =
'f:\oracle\rman-backup\backup-files\incr_%t_s%s_s%p';
BACKUP ARCHIVELOG ALL DELETE ALL INPUT FORMAT =
'f:\oracle\rman-backup\backup-files\archlogs_%t_s%s_s%p';
LIST BACKUP SUMMARY;
LIST BACKUP BY FILE;
LIST COPY OF CONTROLFILE DATABASE ARCHIVELOG ALL;
LIST EXPIRED BACKUP OF CONTROLFILE DATABASE ARCHIVELOG ALL;
LIST EXPIRED COPY OF CONTROLFILE DATABASE ARCHIVELOG ALL;
REPORT OBSOLETE RECOVERY WINDOW OF 7 DAYS;
DELETE OBSOLETE;
Yeah, I know, in the next days I will be adquiring Freeman's book. =3D)
Thanks
Gabriel
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------Received on Fri Aug 13 2004 - 11:21:04 CDT
 |
 |