| Re: RMAN SCRIPT TO CLEAR THE BACKUP PIECES OLDER THAN 2 DAYS... [message #574226] |
Tue, 08 January 2013 03:19  |
 |
sranga.doddi
Messages: 3
Registered: January 2013
Location: India
|
Junior Member |
|
|
Is this script is enough to delete the backup pieces older than 2 days.
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 2 DAYS;
configure device type disk parallelism 1 backup type to compressed backupset;
run
{
allocate channel d1 type disk ;
backup filesperset 5 format '/u06/backup/EBSDEV/EBSDEV_data_t%t_s%s_p%p' database ;
sql 'alter system archive log current' ;
backup filesperset 20 format '/u06/backup/EBSDV3/EBSDV3_arch_t%t_s%s_p%p' archivelog all delete input ;
backup format '/u06/backup/EBSDEV/EBSDEV_control%U' current controlfile ;
backup spfile format '/u06/backup/EBSDEV/EBSDEV_spfile_%U';
sql "alter database backup controlfile to trace as ''/tmp/control.trc'' reuse";
CROSSCHECK BACKUP;
DELETE NOPROMPT OBSOLETE;
DELETE NOPROMPT EXPIRED BACKUP;
}
list backupset summary;
exit;
Thanks in Advance
Sairanga
[Updated on: Tue, 08 January 2013 03:20] Report message to a moderator |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
