Sudipta Bhaskar

May 7, 20212 min

How to enable archivelog mode in Oracle RAC Database

I will modify my newly created RAC database from noarchivelog to archivelog mode.

SQL> archive log list
 
Database log mode No Archive Mode
 
Automatic archival Disabled
 
Archive destination USE_DB_RECOVERY_FILE_DEST
 
Oldest online log sequence 20
 
Current log sequence 21
 

 
[oracle@OEL7N1 admin]$ srvctl config
 
orcl
 

 
[oracle@OEL7N1 admin]$ srvctl status database -d orcl -v
 
Instance orcl1 is running on node oel7n1 with online services pdborcl_srv. Instance status: Open.
 
Instance orcl2 is running on node oel7n2 with online services pdborcl_srv. Instance status: Open.
 

 
[oracle@OEL7N1 admin]$ sqlplus / as sysdba
 

 
SQL*Plus: Release 12.2.0.1.0 Production on Fri May 7 06:07:07 2021
 

 
Copyright (c) 1982, 2016, Oracle. All rights reserved.
 

 

 
Connected to:
 
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
 
SQL>
 

 
SQL> archive log list
 
Database log mode No Archive Mode
 
Automatic archival Disabled
 
Archive destination USE_DB_RECOVERY_FILE_DEST
 
Oldest online log sequence 20
 
Current log sequence 21
 
SQL>
 

 
SQL> exit
 
Disconnected from Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
 
[oracle@OEL7N1 admin]$ srvctl stop database -d orcl
 
[oracle@OEL7N1 admin]$
 

 
[oracle@OEL7N1 admin]$ srvctl start database -d orcl -o mount
 
[oracle@OEL7N1 admin]$
 
[oracle@OEL7N1 admin]$ srvctl status database -d orcl
 
Instance orcl1 is running on node oel7n1
 
Instance orcl2 is running on node oel7n2
 
[oracle@OEL7N1 admin]$
 
[oracle@OEL7N1 admin]$ srvctl status database -d orcl -v
 
Instance orcl1 is running on node oel7n1. Instance status: Mounted (Closed).
 
Instance orcl2 is running on node oel7n2. Instance status: Mounted (Closed).
 
[oracle@OEL7N1 admin]$
 

 
[oracle@OEL7N1 admin]$ sqlplus / as sysdba
 

 
SQL*Plus: Release 12.2.0.1.0 Production on Fri May 7 06:16:03 2021
 

 
Copyright (c) 1982, 2016, Oracle. All rights reserved.
 

 

 
Connected to:
 
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
 

 
SQL> alter database archivelog;
 

 
Database altered.
 

 
SQL> exit
 
Disconnected from Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
 

 
[oracle@OEL7N1 admin]$ srvctl stop database -d orcl
 
[oracle@OEL7N1 admin]$
 
[oracle@OEL7N1 admin]$ srvctl start database -d orcl
 
[oracle@OEL7N1 admin]$
 
[oracle@OEL7N1 admin]$ srvctl status database -d orcl -v
 
Instance orcl1 is running on node oel7n1 with online services pdborcl_srv. Instance status: Open.
 
Instance orcl2 is running on node oel7n2 with online services pdborcl_srv. Instance status: Open.
 
[oracle@OEL7N1 admin]$
 
[oracle@OEL7N1 admin]$ sqlplus / as sysdba
 

 
SQL*Plus: Release 12.2.0.1.0 Production on Fri May 7 06:21:02 2021
 

 
Copyright (c) 1982, 2016, Oracle. All rights reserved.
 

 

 
Connected to:
 
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
 

 
SQL> archive log list
 
Database log mode Archive Mode
 
Automatic archival Enabled
 
Archive destination USE_DB_RECOVERY_FILE_DEST
 
Oldest online log sequence 20
 
Next log sequence to archive 21
 
Current log sequence 21
 
SQL>
 
SQL> show parameter recover
 

 
NAME TYPE VALUE
 
------------------------------------ ----------- ------------------------------
 
db_recovery_file_dest string +ARCH
 
db_recovery_file_dest_size big integer 16188M
 
db_unrecoverable_scn_tracking boolean TRUE
 
recovery_parallelism integer 0
 
remote_recovery_file_dest string
 
SQL>
 
SQL> exit
 
Disconnected from Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
 

    390
    1