Search
  • Sudipta Bhaskar

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


15 views0 comments

Recent Posts

See All

1Z0-083 Few Important Links

Following are few important links to prepare for the certification. Oracle® Multitenant Administrator’s Guide https://docs.oracle.com/en/database/oracle/oracle-database/19/multi/index.html Backup and

Certification Overview

This has been downloaded from oracle website. It contains syllabus and other sample questions for both 082 and 083. Please concentrate on 083.