Tuesday, May 17, 2016

ORA-16072: a minimum of one standby database destination is required; ORA-03113: end-of-file on communication channel

Following error while trying to open the database after RMAN restore and recover database has finished: 

SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel
Process ID: 3689
Session ID: 5644 Serial number: 5

On the alert.log file
Mon May 16 16:29:17 2016
alter database open
Mon May 16 16:29:18 2016
LGWR: STARTING ARCH PROCESSES
Mon May 16 16:29:18 2016
ARC0 started with pid=21, OS id=3196 
ARC0: Archival started
LGWR: STARTING ARCH PROCESSES COMPLETE
ARC0: STARTING ARCH PROCESSES
LGWR: Primary database is in MAXIMUM AVAILABILITY mode
LGWR: Destination LOG_ARCHIVE_DEST_1 is not serviced by LGWR
LGWR: Minimum of 1 LGWR standby database required
Errors in file /soft/app/oracle/diag/rdbms/remitdb/remitdb/trace/remitdb_lgwr_3144.trc:
ORA-16072: a minimum of one standby database destination is required
Mon May 16 16:29:19 2016
ARC1 started with pid=22, OS id=3198 
LGWR (ospid: 3144): terminating the instance due to error 16072
Mon May 16 16:29:20 2016
System state dump requested by (instance=1, osid=3144 (LGWR)), summary=[abnormal instance termination].
System State dumped to trace file /soft/app/oracle/diag/rdbms/remitdb/remitdb/trace/remitdb_diag_3134_20160516162920.trc
Dumping diagnostic data in directory=[cdmp_20160516162920], requested by (instance=1, osid=3144 (LGWR)), summary=[abnormal instance termination].
Instance terminated by LGWR, pid = 3144
Mon May 16 16:31:18 2016


Solution
Step-1: Startup database in mount mode
SQL> startup mount;
ORACLE instance started.

Total System Global Area 7482626048 bytes
Fixed Size                  2267792 bytes
Variable Size            5804918128 bytes
Database Buffers         1660944384 bytes
Redo Buffers               14495744 bytes
Database mounted.
SQL>  select open_mode, DATABASE_ROLE, guard_status, SWITCHOVER_STATUS from v$database;

OPEN_MODE            DATABASE_ROLE    GUARD_S SWITCHOVER_STATUS
-------------------- ---------------- ------- --------------------
MOUNTED              PRIMARY          NONE    NOT ALLOWED


Step-2: Execute following command
SQL> alter database set standby database to maximize performance;

Database altered.

SQL>

Step-3: Shutdown database
SQL> shutdown immediate
ORA-01109: database not open


Database dismounted.
ORACLE instance shut down.

Step-4: startup database in mount mode
SQL> startup mount;
ORACLE instance started.

Total System Global Area 7482626048 bytes
Fixed Size                  2267792 bytes
Variable Size            5804918128 bytes
Database Buffers         1660944384 bytes
Redo Buffers               14495744 bytes
Database mounted.

Step-5: startup database in mount mode
SQL> alter database open;
Database altered.

SQL> select open_mode from v$database;

OPEN_MODE
--------------------
READ WRITE

No comments:

Post a Comment