RMAN retention policy
- From: "Aragon, Gabriel (GE Commercial Finance)" <gabriel.aragon@xxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 13 Aug 2004 10:37:00 -0400
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
-----------------------------------------------------------------
Other related posts:
