About Me

My photo
I work for Fusion5 Australia . Connect with me on linked in here . I'm raising money for a good cause at the moment, follow donate to leukemia foundation

Thursday, 6 July 2017

A CNC approach to oracle archive logs getting filled

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: