| Retention Policy [message #441094] |
Thu, 28 January 2010 11:52  |
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 #444719 is a reply to message #441094] |
Tue, 23 February 2010 13:47  |
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 |
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 |
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 |
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,
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
