Search This Blog

Total Pageviews

Wednesday, 8 October 2014

Delete archivelogs using RMAN until date

Delete archivelogs using RMAN until date .....

RMAN delete archive until time


RMAN> run
{
DELETE archivelog until time "to_date('2010-10-08:05:00:00','YYYY-MM-DD:hh24:mi:ss')";
crosscheck archivelog all;
delete noprompt expired archivelog all;
}


Oracle DBA

anuj blog Archive