Forums.ATC.no

Teknisk => Generelt teknisk => Emne startet av: ATC på 17. Juni 2009, 08:30 am

Tittel: Oracle: How to check if a database is in archivelog mode
Skrevet av: ATC på 17. Juni 2009, 08:30 am

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.

Tittel: [Solved] Oracle: How to check if a database is in archivelog mode
Skrevet av: ATC på 17. Juni 2009, 08:30 am

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