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>

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s