Enabling achivelog mode in 12c RAC database

Posted in: Technical Track

Below is the step by step procedure to enable archivelog mode in 12c RAC database:
[oracle@testsrv1 ~]$ srvctl status database -d MYTESTDB
Instance MYTESTDB1 is running on node testsrv1
Instance MYTESTDB2 is running on node testsrv2


[oracle@testsrv1 ~]$ srvctl stop database -d MYTESTDB
[oracle@testsrv1 ~]$

[oracle@testsrv1 ~]$ srvctl status database -d MYTESTDB
Instance MYTESTDB1 is not running on node testsrv1
Instance MYTESTDB2 is not running on node testsrv2

[oracle@testsrv1 ~]$ srvctl start database -d MYTESTDB -o mount

[oracle@testsrv1 ~]$ srvctl status database -d MYTESTDB
Instance MYTESTDB1 is running on node testsrv1
Instance MYTESTDB2 is running on node testsrv2

[oracle@testsrv1 ~]$ 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

[oracle@testsrv1 ~]$ srvctl stop database -d MYTESTDB
[oracle@testsrv1 ~]$ srvctl start database -d MYTESTDB
[oracle@testsrv1 ~]$ 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

 

email

Author

Interested in working with Fahd? Schedule a tech call.

About the Author

I have been in love with Oracle blogging since 2007. This blogging, coupled with extensive participation in Oracle forums, plus Oracle related speaking engagements, various Oracle certifications, teaching, and working in the trenches with Oracle technologies has enabled me to receive the Oracle ACE award. I was the first ever Pakistani to get that award. From Oracle Open World SF to Foresight 20:20 Perth. I have been expressing my love for Exadata. For the last few years, I am loving the data at Pythian, and proudly writing their log buffer carnivals.

1 Comment. Leave new

Excellent!!! Thank you

Reply

Leave a Reply

Your email address will not be published. Required fields are marked *