LGWR: Minimum of 1 LGWR standby database required- RMAN Restore
After database restore when tried to open , encountered below error.
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel
Process ID: 17034
Session ID: 387 Serial number: 7
Checking at Alterlog
LGWR: Minimum of 1 LGWR standby database required
Errors in file /ora_log/diag/rdbms/shfus1pp/SHFUS1P/trace/SHFUS1P_lgwr_17009.trc:
ORA-16072: a minimum of one standby database destination is required
Sun Jan 17 11:14:29 2021
ARC1 started with pid=20, OS id=17046
LGWR (ospid: 17009): terminating the instance due to error 16072
Sun Jan 17 11:14:30 2021
System state dump requested by (instance=1, osid=17009 (LGWR)), summary=[abnormal instance termination].
System State dumped to trace file /ora_log/diag/rdbms/shfus1pp/SHFUS1P/trace/SHFUS1P_diag_16999_20210117111430.trc
Dumping diagnostic data in directory=[cdmp_20210117111430], requested by (instance=1, osid=17009 (LGWR)), summary=[abnormal instance termination].
Instance terminated by LGWR, pid = 17009
Sun Jan 17 11:15:47 2021
Errors in file /ora_log/diag/rdbms/shfus1pp/SHFUS1P/trace/SHFUS1P_lgwr_17009.trc:
ORA-16072: a minimum of one standby database destination is required
Sun Jan 17 11:14:29 2021
ARC1 started with pid=20, OS id=17046
LGWR (ospid: 17009): terminating the instance due to error 16072
Sun Jan 17 11:14:30 2021
System state dump requested by (instance=1, osid=17009 (LGWR)), summary=[abnormal instance termination].
System State dumped to trace file /ora_log/diag/rdbms/shfus1pp/SHFUS1P/trace/SHFUS1P_diag_16999_20210117111430.trc
Dumping diagnostic data in directory=[cdmp_20210117111430], requested by (instance=1, osid=17009 (LGWR)), summary=[abnormal instance termination].
Instance terminated by LGWR, pid = 17009
Sun Jan 17 11:15:47 2021
Cause: Issue due to protection mode of the database.
SQL> select PROTECTION_MODE, PROTECTION_LEVEL from v$database;
PROTECTION_MODE PROTECTION_LEVEL
-------------------- --------------------
MAXIMUM AVAILABILITY UNPROTECTED
-------------------- --------------------
MAXIMUM AVAILABILITY UNPROTECTED
Solution: Changed the protection mode from MAXIMUM AVAILABILITY to MAXIMUM PERFORMANCE
SQL> ALTER DATABASE SET STANDBY DATABASE TO MAXIMIZE PERFORMANCE;
Database altered.
SQL> alter database open;
Database altered.
SQL> select PROTECTION_MODE, PROTECTION_LEVEL from v$database;
PROTECTION_MODE PROTECTION_LEVEL
-------------------- --------------------
MAXIMUM PERFORMANCE MAXIMUM PERFORMANCE
-------------------- --------------------
MAXIMUM PERFORMANCE MAXIMUM PERFORMANCE
Comments
Post a Comment