ORA-01126: database must be mounted in this instance and not open in any instance
Cause:
I try to convert snapshot standby to physical standby post testing and i get the error due to improper database state
kish@STDBY>alter database convert to physical standby;
alter database convert to physical standby
*
ERROR at line 1:
ORA-01126: database must be mounted in this instance and not open in any instance
Workaround:
Bounce the snap database to mount and then start conversion of physical standby. This should be performed in this way because the database should ensure consistency of data between primary and standby
kish@STDBY>shu immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
kish@STDBY>startup mount;
ORACLE instance started.
Total System Global Area 1509949440 bytes
Fixed Size 2924640 bytes
Variable Size 989859744 bytes
Database Buffers 503316480 bytes
Redo Buffers 13848576 bytes
Database mounted.
kish@STDBY>alter database convert to physical standby;
Database altered.
kish@STDBY>alter database recover managed standby database using current logfile disconnect from session;
Database altered.
kish@STDBY>