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:
[[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] ~]$

[[email protected] ~]$ srvctl status database -d MYTESTDB
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

 

email

Author

Want to talk with an expert? Schedule a call with our team to get the conversation started.

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 *