Oracle archive logs filling up due to p_manage_21 in xxx10 library

• Article Type: General
• Product: Aleph
• Product Version: 19.01

Description:
After running p_manage_21 to update the UPD field in 251,389 authority records from "N" to "Y", the Oracle archive logs keep filling up.

Resolution:
Though z105, z01, and z07 updates are all involved. The vast majority of the archive logging was occurring for the updates to Aleph indexes as a result of the processing of z07 records by the abc01 ue_01.

This newly-implemented site indicated that their bib records are currently in synch with their authorities and that the UPD was being changed to "Y" only so that *subsequent* changes to the authority records will result in updates to the heading fields in the associated bib records. Therefore, the z07's produced by ue_08 were extraneous.

I used the principles described in KB's 4093, 6242, and 8192-2743 to locate z07's *not* created by ue_08 (and, therefore, needing to be preserved).

I ran p_file_03 to back up the entire z07 and then the following to create a file with just the z07's needing to be preserved:

cd $data_files
mv z07.seqaa z07.seqaa.complete
grep ABC50 z07.seqaa > z07.seqaa.abc50
grep ABC60 z07.seqaa > z07.seqaa.abc60
cat z07.seqaa.abc50 z07.seqaa.abc60 > z07.seqaa

Then I did util a/17/1 for the z07 and loaded this z07.seqaa file with p_file_04.

• Article last edited: 10/8/2013