During the upgrade from maximum performance mode to maximum protection mode, there was end-of-file on communication channel error.
SQL> SELECT PROTECTION_MODE FROM V$DATABASE;
PROTECTION_MODE
--------------------
MAXIMUM PERFORMANCE
SQL> SHUTDOWN IMMEDIATE;
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SQL> STARTUP MOUNT;
ORACLE instance started.
Total System Global Area 1593832624 bytes
Fixed Size 9135280 bytes
Variable Size 1191182336 bytes
Database Buffers 385875968 bytes
Redo Buffers 7639040 bytes
Database mounted.
SQL> ALTER DATABASE SET STANDBY DATABASE TO MAXIMIZE PROTECTION;
Database altered.
SQL> ALTER DATABASE OPEN;
ALTER DATABASE OPEN
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel
Process ID: 115636
Session ID: 1 Serial number: 26751
For this error, even tried clearing unarchived logfile and its group;
SQL*Plus: Release 19.0.0.0.0 - Production on Wed Sep 11 17:22:08 2019
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup nomount;
ORACLE instance started.
Total System Global Area 1593832624 bytes
Fixed Size 9135280 bytes
Variable Size 1191182336 bytes
Database Buffers 385875968 bytes
Redo Buffers 7639040 bytes
SQL> alter database mount;
Database altered.
SQL> alter database clear unarchived logfile group 1;
Database altered.
SQL> alter database clear unarchived logfile group 2;
Database altered.
SQL> alter database clear unarchived logfile group 3;
Database altered.
SQL> alter database clear unarchived logfile group 4;
Database altered.
SQL> alter database clear unarchived logfile group 5;
Database altered.
SQL> alter database clear unarchived logfile group 6;
Database altered.
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel
Process ID: 117391
Session ID: 1 Serial number: 13397
But still i face the same issue, may i get some help on this?