Linux Technical Track

Enabling achivelog mode in 12c RAC database

1 min read

Oct 17, 2016 12:00:00 AM

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

On this page

Ready to unlock value from your data?

With Pythian, you can accomplish your data transformation goals and more.

Speak with Pythian consultants now →

What We Do

Enabling achivelog mode in 12c RAC database

Share this

Share this

More resources

OEM12c Discovery of Exadata Cluster

How to install 18c Grid Infrastructure in Silent Mode on Linux 7

Duplication: divide et impera

Ready to unlock value from your data?