📋Steps in this guide1/2

Enable Archivelog - Bright DBA

Enable the database in Archivelog mode. Step 1: Set the following parameters in parameter file. SQL> ALTER SYSTEM SET LOG_ARCHIVE_FORMAT='%t_%s_%r.dbf' SCOPE=SPFILE; SQL> ALTER SYSTEM SET log_archive_dest_1='location=/u01/app/oracle/oradata/MYSID/archive/' SCOPE=both; Step 2: Enable archivelog using below commands. SHUTDOWN IMMEDIATE; STARTUP MOUNT; ALTER DATABASE ARCHIVELOG; ARCHIVE LOG LIST; ALT

oracle clusteringintermediate

by OracleDba

12 views

Overview

Enable the database in Archivelog mode. Step 1: Set the following parameters in parameter file. Step 1: Step 2: Enable archivelog using below commands.

Code/Command (click line numbers to comment):

1
2

SQL> ALTER SYSTEM SET LOG_ARCHIVE_FORMAT='%t_%s_%r.dbf' SCOPE=SPFILE;
SQL> ALTER SYSTEM SET log_archive_dest_1='location=/u01/app/oracle/oradata/MYSID/archive/' SCOPE=both;

Section 2

Step 2: It is recommended to take a full backup before/after you brought the database in archive log mode. Caution: Your use of any information or materials on this website is entirely at your own risk. It is provided for educational purposes only.

Code/Command (click line numbers to comment):

SHUTDOWN IMMEDIATE;
STARTUP MOUNT;
ALTER DATABASE ARCHIVELOG;
ARCHIVE LOG LIST;
ALTER DATABASE OPEN;

Comments (0)

Please to add comments

No comments yet. Be the first to comment!