RE: RMAN retention policy
- From: Freeman Robert - IL <FREEMANR@xxxxxxxx>
- To: "'Aragon, Gabriel (GE Commercial Finance) '" <gabriel.aragon@xxxxxx>, "'oracle-l-bounce@xxxxxxxxxxxxx '" <oracle-l-bounce@xxxxxxxxxxxxx>, "'oracle-l@xxxxxxxxxxxxx '" <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 13 Aug 2004 11:25:09 -0500
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.)
HTH
Robert
Author Oracle9i RMAN Backup and Recovery
Watch for my new book, Portable DBA: Oracle from Oracle Press
Due out soon!
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
To: oracle-l@xxxxxxxxxxxxx
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
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
