Below is the step by step procedure to enable archivelog mode in 12c RAC database:
[[email protected] ~]$ srvctl status database -d MYTESTDB
Instance MYTESTDB1 is running on node testsrv1
Instance MYTESTDB2 is running on node testsrv2
[[email protected] ~]$ srvctl stop database -d MYTESTDB
[[email protected] ~]$
Instance MYTESTDB1 is not running on node testsrv1
Instance MYTESTDB2 is not running on node testsrv2 [[email protected] ~]$ srvctl start database -d MYTESTDB -o mount [[email protected] ~]$ srvctl status database -d MYTESTDB
Instance MYTESTDB1 is running on node testsrv1
Instance MYTESTDB2 is running on node testsrv2 [[email protected] ~]$ sqlplus ‘/ as sysdba’
SQL*Plus: Release 12.1.0.2.0 Production on Fri Oct 14 00:10:28 2016
Copyright (c) 1982, 2014, Oracle. All rights reserved.
SQL> select instance_name,status from gv$instance;
INSTANCE_NAME STATUS
—————- ————
MYTESTDB1 MOUNTED
MYTESTDB2 MOUNTED
SQL> archive log list;
Database log mode No Archive Mode
Automatic archival Disabled
Archive destination /u01/app/oracle/product/12.1.0.2/dbhome_1/dbs/arch
Oldest online log sequence 32
Current log sequence 33
SQL> alter database archivelog;
Database altered.
SQL> alter system set log_archive_dest_1=’LOCATION=+FRA’ SCOPE=SPFILE;
SQL> exit
[[email protected] ~]$ srvctl stop database -d MYTESTDB[[email protected] ~]$ srvctl start database -d MYTESTDB
[[email protected] ~]$ sqlplus ‘/ as sysdba’
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination +FRA
Oldest online log sequence 33
Next log sequence to archive 34
Current log sequence 34
1 Comment. Leave new
Excellent!!! Thank you