Explain the difference between ARCHIVELOG mode and NOARCHIVELOG mode in oracle.
Advertisement


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.