tag:blogger.com,1999:blog-940885937847335876.post9133099969888651453..comments2024-01-31T15:08:14.203+05:30Comments on One Can Succeed at Almost Anything For Which He Has Enthusiasm...: Difference Between OBSOLETE AND EXPIRED BackupNEERAJ VISHENhttp://www.blogger.com/profile/04032578930084182369noreply@blogger.comBlogger11125tag:blogger.com,1999:blog-940885937847335876.post-25533920621103461642018-01-09T01:20:42.952+05:302018-01-09T01:20:42.952+05:30If I have retention policy to redundancy 7 and if ...If I have retention policy to redundancy 7 and if I want to delete archives older than 7 days in ASM archive destination eg:+DATA/ORCL/ARCHIVELOG/ HERE I WANT KEEP ONLY 7 DAYS ARCHIVES WHICH ONE I HAVE TO USE IN RMAN SCRIPT DELETE OBSOLETE OR DELETE EXPIRED ARCHIVELOG ALL;Anonymoushttps://www.blogger.com/profile/02776104484099811309noreply@blogger.comtag:blogger.com,1999:blog-940885937847335876.post-62052026020549534062018-01-09T01:16:47.583+05:302018-01-09T01:16:47.583+05:30If I have retention policy redundancy to 7 and I w...If I have retention policy redundancy to 7 and I want delete archives older than 7 days in ASM archive destination which command i have to use in RMAN DELETE OBSOLETE OR DELETE EXPIRED ARCHIVELOG ALL?Anonymoushttps://www.blogger.com/profile/02776104484099811309noreply@blogger.comtag:blogger.com,1999:blog-940885937847335876.post-28225259177109220312017-10-29T02:20:04.778+05:302017-10-29T02:20:04.778+05:30As per http://www.dba-oracle.com/t_rman_delete_obs...As per http://www.dba-oracle.com/t_rman_delete_obsolete_remove_files.htm - A file is obsolete only if it is not required for full database recovery. It has got nothing do with retention policy.Anonymoushttps://www.blogger.com/profile/06634483018972808826noreply@blogger.comtag:blogger.com,1999:blog-940885937847335876.post-28100949789617188032017-10-29T02:18:25.136+05:302017-10-29T02:18:25.136+05:30As per http://www.dba-oracle.com/t_rman_delete_obs...As per http://www.dba-oracle.com/t_rman_delete_obsolete_remove_files.htm - Obsolete doesn't have anything to do with retention policy. It only marks a file OBSOLETE if it is not required for full database recovery.Anonymoushttps://www.blogger.com/profile/06634483018972808826noreply@blogger.comtag:blogger.com,1999:blog-940885937847335876.post-87546622406512027882017-10-05T14:33:53.570+05:302017-10-05T14:33:53.570+05:30Thanks for the info....
Very usefulThanks for the info....<br />Very usefulImrannoreply@blogger.comtag:blogger.com,1999:blog-940885937847335876.post-47591069158308150452015-12-23T04:49:51.541+05:302015-12-23T04:49:51.541+05:30Excellent mate Excellent mate Anonymoushttps://www.blogger.com/profile/03727848080695132205noreply@blogger.comtag:blogger.com,1999:blog-940885937847335876.post-30087505567645689152014-11-09T03:49:02.677+05:302014-11-09T03:49:02.677+05:30Intrvew qstn thnks dear hehe
feroz khan :)Intrvew qstn thnks dear hehe <br />feroz khan :)Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-940885937847335876.post-52568066620104989592013-06-03T22:00:04.333+05:302013-06-03T22:00:04.333+05:30Thanks Rashmi and Dev Anand .....
You most welco...Thanks Rashmi and Dev Anand .....<br /><br />You most welcome !!!!!<br /><br /><br />Have Fun and Enjoy :) NEERAJ VISHENhttps://www.blogger.com/profile/04032578930084182369noreply@blogger.comtag:blogger.com,1999:blog-940885937847335876.post-2249224049882000462013-06-03T16:38:23.042+05:302013-06-03T16:38:23.042+05:30Much Understandable. Explained So nicely..Much Understandable. Explained So nicely..Dev Anandhttps://www.blogger.com/profile/07040499880355600366noreply@blogger.comtag:blogger.com,1999:blog-940885937847335876.post-36197970643120374922012-04-17T07:15:44.608+05:302012-04-17T07:15:44.608+05:30Thanks and Valuble information.
With Regards
Jos...Thanks and Valuble information.<br /><br /><br />With Regards<br />JosephAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-940885937847335876.post-18914851053327868512011-12-22T11:19:48.966+05:302011-12-22T11:19:48.966+05:30Thanks for the info.Thanks for the info.Rashminoreply@blogger.com