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
Comments