Linux Technical Track

Enabling achivelog mode in 12c RAC database

1 min read

Oct 17, 2016

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

Enabling achivelog mode in 12c RAC database

Share this

You May Also Like

Oracle Database 12c: Network Recovery in RMAN

Create 19c Database in Archive Mode Using DBCA Silent

Duplication: divide et impera

Get Email Notifications

No Comments Yet