Database crash with error ORA-03113: end-of-file on communication channel

RAC DATABASE Crash with ORA-03113 error

Sometimes, RAC database after clone failed to start with ORA-03113 error.

This is because of log_archive_config is not same across all instances of the database.

SQL> startup mount;

ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance

ORACLE instance started.

Total System Global Area 1.0737E+11 bytes

Fixed Size 7715904 bytes

Variable Size 1.2281E+10 bytes

Database Buffers 9.5026E+10 bytes

Redo Buffers 59392000 bytes

Database mounted.

SQL> alter database open;

alter database open

ERROR at line 1:

ORA-03113: end-of-file on communication channel

Process ID: 23064

Session ID: 3001 Serial number: 23050

Cause: log_archive_config was not set properly and not same across the instances.

Below are the errors in alert log

WARNING: The ‘LOG_ARCHIVE_CONFIG’ init.ora parameter settings

are inconsistent with another started instance. This may be

caused by the ‘DB_UNIQUE_NAME’ init.ora parameter being specified

differently on one or more of the other RAC instances; the

DB_UNIQUE_NAME parameter value MUST be identical for all

instances of the database.

/u01/app/db_1/diag/rdbms/DOYEN12/trace/DOYEN12_diag_8807_20200111064914.trc

ORA-16188: LOG_ARCHIVE_CONFIG settings inconsistent with previously started instance

Solution: