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

    How can I tell if Oracle archive logging is turned on? location of logs

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

    Description:
    How can I tell if Oracle archive logging is turned on -- and, if turned on, where the archive logs are located?

    Resolution:
    util o/7/3 gives you this information:

    Database log mode Archive Mode
    Automatic archival Enabled <--------------
    Archive destination /exlibris1/aleph1 <--------------
    Oldest online log sequence 33228
    Next log sequence to archive 33232
    Current log sequence 33232
    SQL> Disconnected from Oracle8i Enterprise Edition Release 8.1.7.4.0 - Production
    With the Partitioning option
    JServer Release 8.1.7.4.0 - Production


    • Article last edited: 10/8/2013