Oracle Archive Log Mode Status or Status of Archive Log Subsystem

One can  can check to see if Oracle is in archive log mode or has logging turned on.  This means that the database is able to recover forward or backward in time.  Sometimes referred to as point in time recovery

Oracle Archive Log Mode Status or Status of Archive Log Subsystem

ARCHIVE LOG LIST;

Check the Oracle log mode of  the databases

SELECT name, log_mode FROM v$database;

Check the Oracle Archive mode in an  instance 

SELECT archiver FROM v$instance;

Leave a Reply

Your email address will not be published. Required fields are marked *