HOME > > Enable Archive Log Mode In Oracle RAC

Enable Archive Log Mode In Oracle RAC

Anup - Friday, February 24, 2023

 1. stop the database service.

    srvctl stop database -d PROD

2. start the database in mount state.

srvctl start database -d PROD -o mount

3. enable archive log mode.

alter database archivelog;

4. Restart the database service (using srvctl)

srvctl stop database -d PROD

srvctl start database -d PROD

5. set the archive destination to a ASM DISK

SQL> alter system set log_archive_dest_1='LOCATION=+ARCH/' scope=both sid='*';

System altered.

SQL> archive log list

SQL> alter system switch logfile;

System altered.

Contact me

Get in Touch

Need to get touch with me? Please fill out the form with your enquiry.

Name
Anup Srivastav
Address
Lucknow - Utter Pradesh
Email
myindiandba@gmail.com
Message me