Description:-
In this is the article we are going to see Enabling Archive Log Mode In Oracle 19c RAC Database
Step:-1 Before Changing the archivelog mode check the status.
SQL> select log_mode,name from v$database;
LOG_MODE NAME
———— ———
NOARCHIVELOG ORADBWR
SQL> archive log list
Database log mode No Archive Mode
Automatic archival Disabled
Archive destination /u01/app/oracle/product/19c/dbhome_1/dbs/arch
Oldest online log sequence 4
Current log sequence 5
SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 – Production
Version 19.3.0.0.0
Step:-2 Stop the rac database service.
[oracle@rac1 ~]$ srvctl stop database -d oradbwr
[oracle@rac1 ~]$ srvctl status database -d oradbwr
Instance oradbwr1 is not running on node rac1
Instance oradbwr2 is not running on node rac2
Step:-3 Start the rac database in mount state.
srvctl start database -d oradbwr -o mount
[oracle@rac1 ~]$ srvctl start database -d oradbwr -o mount
[oracle@rac1 ~]$ srvctl status database -d oradbwr
Instance oradbwr1 is running on node rac1
Instance oradbwr2 is running on node rac2
Step:-4 Enable archive log mode rac database and set destination to a ASM DISK group
[oracle@rac1 ~]$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 – Production on Wed Dec 25 16:36:42 2019
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 – Production
Version 19.3.0.0.0
SQL> alter system set log_archive_dest_1=’LOCATION=+DATA/’ scope=both sid=’*’;
System altered.
SQL> alter database archivelog;
Database altered.
Step:-5 Stop the rac database service.
[oracle@rac1 ~]$ srvctl stop database -d oradbwr
Step:-6 Restart the rac database
[oracle@rac1 ~]$ srvctl start database -d oradbwr
[oracle@rac1 ~]$ srvctl status database -d oradbwr
Instance oradbwr1 is running on node rac1
Instance oradbwr2 is running on node rac2
[oracle@rac1 ~]$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 – Production on Wed Dec 25 16:44:47 2019
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 – Production
Version 19.3.0.0.0
Step:-7 Check Archivelog Status.
SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination +DATA
Oldest online log sequence 4
Next log sequence to archive 5
Current log sequence 5
SQL> select log_mode,name from v$database;
LOG_MODE NAME
———— ———
ARCHIVELOG ORADBWR
Connect with me:-
Telegram App:https://t.me/oracledbwr
LinkedIn:https://www.linkedin.com/in/hariprasathdba
Facebook:https://www.facebook.com/HariPrasathdba
FB Group:https://www.facebook.com/groups/894402327369506/
FB Page : https://www.facebook.com/dbahariprasath/?
Twitter : https://twitter.com/oracledbwr