Home » RDBMS Server » Backup & Recovery » Retention Policy (RHEL5 Oracle 10g )
Retention Policy [message #441094] Thu, 28 January 2010 11:52 Go to next message
marcossantos
Messages: 123
Registered: June 2008
Senior Member
Hi,
I have a incremental backup level 0 on sunday and incremental backup level 1 along with week. The retention policy is 1. The size of backup file is 38GB, and recovery_area of 40GB. My question is: the retention policy is applied before the new backup? In other words, the when the old backup is deleted? Before or after the new backup? The recovery area is enough?

Thanks,
Re: Retention Policy [message #441095 is a reply to message #441094] Thu, 28 January 2010 12:08 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Why don't you just try it instead of relying on an answer in a Forum, answser which may be wrong and which you have to test anyway?

Regards
Michel
Re: Retention Policy [message #441107 is a reply to message #441094] Thu, 28 January 2010 21:06 Go to previous messageGo to next message
ramoradba
Messages: 2457
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
Yes,thats exactly.always try yourself,if any thing wrong/any error then come back here..

But before trying any thing make sure that you have a sound knowledge in that Wink

Read the fine manuals


RTFM

RMAN

rman_demos

Goodluck

sriram Smile
Re: Retention Policy [message #444719 is a reply to message #441094] Tue, 23 February 2010 13:47 Go to previous messageGo to next message
marcossantos
Messages: 123
Registered: June 2008
Senior Member
Thanks for your answer.
The retention policy not been applied. The old backupset not been deleted.

RMAN> show all;

RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1;
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/dados/u01/app/oracle/product/10.2.0/db_1/dbs/snapcf_orahom.f'; # default

Can you help me.
Tanks,

[Updated on: Tue, 23 February 2010 13:48]

Report message to a moderator

Re: Retention Policy [message #446452 is a reply to message #441094] Mon, 08 March 2010 09:02 Go to previous messageGo to next message
marcossantos
Messages: 123
Registered: June 2008
Senior Member
Hi,
I make a test.
1. Resize flash recovery area to 60Gb;
2. Configure retentio policy to 1;
3. Execute DELETE OBSOLETE command on script of backup.

Result: The old backup set not is deleted.

Can someone help me.

Thanks,
Re: Retention Policy [message #446538 is a reply to message #441094] Tue, 09 March 2010 03:49 Go to previous messageGo to next message
pokhraj_d
Messages: 117
Registered: December 2007
Senior Member
Hi,

"CONFIGURE RETENTION POLICY TO REDUNDANCY 1" means the One set of backup copy will be at your disk.[Correct me if I am wrong].

So DELETE OBSOLETE will not delete the backupsets.
You can try the below approach:-

1. CROSSCHECK BACKUP;
2. REPORT OBSOLETE;[To check whether any obsolete backup exists or not]
3. DELETE OBSOLETE;

Thanks-
P
Re: Retention Policy [message #446996 is a reply to message #441094] Thu, 11 March 2010 06:13 Go to previous message
marcossantos
Messages: 123
Registered: June 2008
Senior Member
Hi,
I have a bash script that run every sunday. Its like this:
...
echo "Running rman"
su - $ORA_OWNER -c "$ORA_HOME/bin/rman log=/dados/backup-rman/log-rman/log-rman.txt" <<EOF 
connect target /
connect catalog $CATALOG_CONN
backup incremental level 0 database plus archivelog delete input;
delete obsolete;
host "exp rman_user/rman file=/dados/backup-rman/files-rman/rman_cat.dmp owner=rman_user";
exit
EOF
...


I have to delete old backup set. I have to put "crosscheck backup" and "report obsolete" too?

Actually, I have to access the RMAN and entry delete command manually.

Thanks,
Previous Topic: change or scn for incomplete recovery
Next Topic: RMAN command
Goto Forum:
  


Current Time: Tue Dec 03 08:23:13 CST 2024