Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

RMAN LIST backup and maintain backup.

925463Jul 24 2012 — edited Aug 13 2012
Hi Experts,

Currently we have some changes on the rman retention policy from 168days to 90days.

RMAN Retention policy is:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 14 DAYS;

And RMAN Scripts monthly backup is:
run
{
allocate channel t1 type 'sbt_tape' parms
'ENV=(TDPO_OPTFILE=/opt/tivoli/tsm/client/oracle/bin64/tdpo_monthly.opt)';
backup as compressed backupset database tag ${SID}_MONTHLY keep until time 'sysdate+168';
release channel t1;
}

I believe I still have the old backup after I changed the 'sysdate+168' to 'sysdate+90'; on my scripts

How do I manage to delete this ?
Using, List backup and list backup summary will prompt me very long line and window,

How do I create the CONFIGURE settings I can remove the allocate channel... on my scripts ?

Cheers,
Raff
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 10 2012
Added on Jul 24 2012
6 comments
1,499 views