impact of ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL issued on Primary database instead
edited Mar 20, 2012 5:11PM in High Availability Data Guard, Sharding and Global Data Services (MOSC) 4 commentsAnswered
Dear experts,
if by mistake we issue the command ""ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL" in primary instead of standby, will it just kill the background process or will it shut down the database instance.
From log what I observed it that it started the shutdown immediate process but DB was not shutdown. Shutdown process stopped in between and DB was again functional without a start up activity recorded in the alert log.
reproducing the alert log portion for your reference:
Tue Jan 24 10:16:18 2012
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL
Tue Jan 24 10:16:18 2012
ORA-1665 signalled during: ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL...
if by mistake we issue the command ""ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL" in primary instead of standby, will it just kill the background process or will it shut down the database instance.
From log what I observed it that it started the shutdown immediate process but DB was not shutdown. Shutdown process stopped in between and DB was again functional without a start up activity recorded in the alert log.
reproducing the alert log portion for your reference:
Tue Jan 24 10:16:18 2012
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL
Tue Jan 24 10:16:18 2012
ORA-1665 signalled during: ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL...
0