Difference between ARCHIVELOG mode and NOARCHIVELOG mode

Archivelog mode is a mode in which backup is taken for all the transactions that takes place so as to recover the database at any point of time. Noarichvelog mode is in which the log files are not written. This mode has a disadvantage that the database cannot be recovered when required. It has an advantage over archivelog mode which is increase in performance.

Oracle - Difference between ARCHIVELOG mode and NOARCHIVELOG mode - April 10, 2009 at 11:00 AM

Difference between ARCHIVELOG mode and NOARCHIVELOG mode  

There are two modes in which the hot backup works:

ARCHIEVELOG mode
NOARCHIVELOG mode

The database operations are suspended until archiving has been completed if the on-line redo log files are filled before they can be archived.

It is important that the directory containing the archived log files doesn’t become full because if it does the ARCH thread wouldn’t be able to archive the redo log files. The DBA has to continuously monitor the used-space percentage in the archive directory.

The database can be placed into ARCHIVELOG mode at the creation time or after the database has been created.

However, the database is shutdown before connecting as the user INTERNAL.

It was originally created in NOARCHIVELOG mode; this technique can be used to place the database in ARCHIVELOG mode.

Also read

What are SQL*Plus Environment variables?

The behaviour of SQL PLUS depends on some environmental variables predefined in the OS: ORACLE_HOME: This variable stores the home directory where the Oracle client.............

What is a subquery in Oracle?

When a query needs to be run which has a condition that needs to be a result of another query then, the query in the condition part of the main one is called a sub-query...............

What are the uses of Rollback Segment?

Rollback segments undo changes when a transaction is rolled back, they also ensure that transactions leave the uncommitted changes unnoticed..............

What are the types PL/SQL code blocks?

Anonymous Block, Stored Program Unit, Trigger............

<<Previous  Next>>

Write your comment - Share Knowledge and Experience