How to check if Oracle database is running in Archive Log mode:
December 2, 2007
Leave a comment
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Disabled
Archive destination /u01/app/oracle/product/9.2.0/dbs/arch
Oldest online log sequence 568
Next log sequence to archive 569
Current log sequence 570
Categories: oracle
archive log, oracle archive log