Skip to main content
ExLibris
  • Subscribe by RSS
  • ExLibris Dev

    Check whether Oracle for Voyager is in archive mode

    • Article Type: General
    • Product: Voyager
    • Product Version: 7

    Desired Outcome Goal:
    To know whether Oracle for Voyager is in archive mode

    Procedure:
    1. Log in as Oracle user.
    2. Run the following sql commands:

    sqlplus '/ as sysdba'

    SQL> archive log list

    3. Check the output from step 2.
    The example below shows archive mode enabled.

    SQL> archive log list
    Database log mode Archive Mode
    Automatic archival Enabled
    Archive destination /oracle/oradata/VGER/arch
    Oldest online log sequence 12377
    Next log sequence to archive 12379
    Current log sequence 12379

    Category: Voyager

    Subject: Oracle


    • Article last edited: 7/31/2014
    //doorbell.io feedback widged