Delete Archive log oracle using RMAN February 15, 2008
Posted by dpermana in DBA.trackback
i just want to share my case, about having problems with a disk space on R/3 server going full.
so i decided to delete archive log on oracle
step Configuration
the first thing to do is, find where the archive log is put
and after that you must use RMAN to delete the archive
on command promt. type this command RMAN
RMAN> run { allocate channel d1 type disk;
delete archivelog all;
release channel d1;
}
Best Regard’s
Dpermana
thanks alot
can i delete archivelog before one week ?
best regards afifics
If i delete the archive log files using the above method, next time my rman backup runs, wouldn’t it fail? and then wouldn’t i be forced to do a ‘crosscheck’ before i can successfully get a backup set?