Oracle Database - How to know the archivelog mode ?

Card Puncher Data Processing

About

To know if the database is in Oracle Database - ARCHIVELOG or Oracle Database - NOARCHIVELOG mode, you have to perform the statement below :

gerardnico@orcl> select log_mode from v$database;

LOG_MODE
------------
NOARCHIVELOG

The default mode in the creation of a database is Oracle Database - NOARCHIVELOG to prevent the generation of Oracle Database - Redo Log (Transaction Log Files) during the installation.





Discover More
Card Puncher Data Processing
Oracle Database - How to change the Database Archiving Mode

To change the default mode from to
Card Puncher Data Processing
Oracle Database - Mode Archive Log / Archiving

Oracle Database lets you save filled groups of files to one or more offline destinations, known collectively as the archived , or more simply thearchive log. The process of turning redo log files into...



Share this page:
Follow us:
Task Runner