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;


Tags : Database

You May Also Like

Comments

no comment yet!