Truncate them! obvious…
No, kidding… We do a lot of work with temp environments and large statements and sometimes that can cause various problems with filling archive logs… I was getting issues when importing large tables using impdp. Of course, I do not care about the archive.
Errors like this:
UDI-00257: operation generated ORACLE error 257
login as oracle to the database server. And delete all archive up to the current time – 1/24 (I did rip this off the net – sorry I missed the credit).
. oraenv
rman
connect target
delete noprompt archivelog all completed before 'sysdate - 1/24';
quit
It’ll plow through the archive and let your statements run again
No comments:
Post a Comment