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