Unable to start standby database read-only mode
edited Aug 24, 2017 5:24AM in High Availability Data Guard, Sharding and Global Data Services (MOSC) 5 commentsAnswered
Hi There,
My primary and standby database no archive log gap but unable to start standby database with read-only mode.
How to solve this issue?
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;
Database altered.
SQL> alter database open read only;
^Calter database open read only
*
ERROR at line 1:
ORA-10458: standby database requires recovery
ORA-01194: file 2 needs more recovery to be consistent
ORA-01110: data file 2: '+DG_RTX/asm/datafile/sysaux392.631.944908911'
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT FROM SESSION;
Database altered.
SQL> select * from v$archive_gap;
no rows selected
SQL>
0