Enabling Archivelog Mode
Published by : Obay Salah , November 19, 2024
1- Make sure that the database is running in NOARCHIVELOG mode by running a query on the database.
ARCHIVE LOG LIST SELECT LOG_MODE FROM V$DATABASE; SELECT ARCHIVER FROM V$INSTANCE;
2- Configure the variable LOG_ARCHIVE_DEST_1, which specifies the path where the archive will be stored. Different paths and directions can be specified for storing the archive
Through the variables LOG_ARCHIVE_DEST_2 to LOG_ARCHIVE_DEST_31.
Here we will configure one path to store the archive through the variable LOG_ARCHIVE_DEST_1. We must first ensure that the specified path is correct on the operating system.
ALTER SYSTEM SET LOG_ARCHIVE_DEST_1='LOCATION=D:\ARCHIVE\' SCOPE=BOTH;
To verify the variable after initialization
SHOW PARAMETER LOG_ARCHIVE_DEST_1
3- We close the database and open it in MOUNT mode and execute the ALTER DATABASE ARCHIVELOG command.
SHUT IMMEDIATE; STARTUP MOUNT; ALTER DATABASE ARCHIVELOG; ALTER DATABASE OPEN;
4- We verify the configuration by querying the database.
SELECT LOG_MODE FROM V$DATABASE;
Comments
no comment yet!