RMAN retention policy

From: Aragon, Gabriel (GE Commercial Finance) <gabriel.aragon_at_ge.com>
Date: Fri, 13 Aug 2004 10:37:00 -0400
Message-ID: <DA3854DCCE41EA42B603E39691388AC31643BB07@CINMLVEM05.e2k.ad.ge.com>

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';

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_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 - 09:35:46 CDT