Skip to main content
ExLibris
  • Subscribe by RSS
  • Ex Libris Knowledge Center

    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