OraFAQ Forum: Backup & Recovery » RMAN (magically) purging old directories

Home » RDBMS Server » Backup & Recovery » RMAN (magically) purging old directories

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

RMAN (magically) purging old directories [message #258300]

Fri, 10 August 2007 21:14

sweetness
Messages: 10
Registered: May 2005
Location: Pasadena

Junior Member

I have a question (thanks in advance for any help).

Why is it that RMAN removes any directories in $ORACLE_BASE/flash_recovery_area/backupset and $ORACLE_BASE/flash_recovery_area/autobackup that are older than seven days? For example, today is August 10, and I see the directories 2008_08_10, 2008_08_09, ... 2008_08_04 today, but tomorrow I will see the directories 2008_08_11, 2008_08_08, ... 2008_08_05. I know that tomorrow 2008_08_11 directory will be created because my RMAN script will be called and new backups of my datafiles and archived redo logs as well as my control files and spfiles will be created and put in that directory. But why will the 2008_08_04 directory be removed?

It can't be my recovery window. It is one day, not seven.

Here is my RMAN script:

Code: [Select all] [Show/ hide]

configure retention policy to recovery window of 1 days;
allocate channel for maintenance type disk;
delete noprompt obsolete device type disk;
configure controlfile autobackup on;
configure maxsetsize to 12G;
backup as compressed backupset device type disk database;
backup as compressed backupset archivelog from time 'SYSDATE-(5/2)';

Does this happen to anyone else? Is this seventh day purge behavior hard-coded into RMAN, or is there some type of configuration that the previous DBA must have set but is simply not apparent to me?

Joe

Report message to a moderator

Re: RMAN (magically) purging old directories [message #258309 is a reply to message #258300]

Fri, 10 August 2007 23:47

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

Do you have enough disk space for FRA

post

Code: [Select all] [Show/ hide]

show parameter db_recover_file_dest_size

Quote:

Is this seventh day purge behavior hard-coded into RMAN, or is there some type of configuration that the previous DBA must have set but is simply not apparent to me?

The files in the flash recovery area can be classified as permanent or transient. The only permanent files (assuming these are configured to be stored in the flash recovery area) are multiplexed copies of the current control file and online redo logs. These cannot be deleted without causing the instance to fail. All other files are transient, because Oracle will generally eventually delete these files, at some point after they become obsolete under the retention policy or have been backed up to tape. Transient files include archived redo logs, datafile copies, control file copies, control file autobackups, and backup pieces.

http://download.oracle.com/docs/cd/B19306_01/backup.102/b14192/setup005.htm

Report message to a moderator