Skrevet av Emne: Oracle: How to check if a database is in archivelog mode  (Lest 4312 ganger)

ATC

  • Gjest
  • [applaud]0
  • [smite]0
  • Before switching archivelog mode on or off, it can sometimes be useful to know if it's already on or off, especially since changing modes require a shutdown of the database.



    ATC

    • Gjest
    [Solved] Oracle: How to check if a database is in archivelog mode
    « Svar #1 på: 17. Juni 2009, 08:30 am »
  • [applaud]0
  • [smite]0
  • Using sqlplus, simply type
    "archive log list"

    Typical output when OFF:
    Database log mode              No Archive Mode
    Automatic archival             Enabled
    Archive destination            /oracle/app/oracle/oradata/RALEPH/archive
    Oldest online log sequence     305
    Current log sequence           307

    Typical output when ON:
    Database log mode              Archive Mode
    Automatic archival             Enabled
    Archive destination            /oracle/app/oracle/oradata/EXTENS/archive
    Oldest online log sequence     193
    Next log sequence to archive   195
    Current log sequence           195