Tag Archives: disable the archive log

Enable and disable the archivelog in Oracle database

Enable or disable archivelog in Oracle Database

Check the database is in archive log mode

SELECT LOG_MODE FROM V$DATABASE;

Check the location of archive generated.

ARCHIVE LOG LIST;
OR
SELECT DEST_NAME, STATUS, DESTINATION FROM V$ARCHIVE_DEST;

Enable the archivelog mode in Oracle

ALTER SYSTEM SET LOG_ARCHIVE_DEST_1='LOCATION=D:\ARCHIVE\ORCL' SCOPE=BOTH;
SHUTDOWN IMMEDIATE;
STARTUP MOUNT;
ALTER DATABASE ARCHIVELOG;
ALTER DATABASE OPEN;

Disable the archivelog Mode in Oracle

SHUTDOWN IMMEDIATE;
START MOUNT
ALTER DATABASE NOARCHIVELOG;
ALTER DATABASE OPEN;

Change the location of Archive log if location is full

-- first check the parameter which configured.
SHOW PARAMETER LOG_ARCHIVE_DEST
--Second change the location which having sufficient space
ALTER SYSTEM SET LOG_ARCHIVE_DEST_1='LOCATION=D:\ARCHIVE\ORCL' SCOPE=BOTH;
--Third backup the archive and clear with RMAN
RMAN> BACKUP ARCHIVELOG ALL DELETE INPUT;