ORA-16456错误，由于备库未mount而在主库执行切换，解决办法详解

ORA-16456错误，由于备库未mount而在主库执行切换，解决办法详解

如果对数据库进行主备库的切换需要的前提条件是：

（1）备库必须mount状态下,主库open状态

（2）必须不能在最大保护模式下 

我们有时做主备库的切换，结果忘记了把备库处于mount状态而是open状态下；

当在primary执行过切换操作之后：

SQL>alterdatabase commit to switchover to physical standby; 

Databasealtered.

现在对primary库进行查看：

00:26:00sys@felix SQL>select switchover_status from v$database; 

SWITCHOVER_STATUS

----------------------------------------

RECOVERY NEEDED 

状态我们发现时recovery needed 

这个时刻，我感觉出事了，该怎么办？？

我就在主库执行了如下操作：（以为这样会可以的，但是不行）

00:26:26 sys@felix SQL>alter database commit to switchoverto primary;

alter database commit to switchover to primary

*

ERROR at line 1:

ORA-16456: switchover to standby in progress or completed 

0:26:54 sys@felix SQL>shutdown immediate;

ORA-01092: Oracle instance terminated.Disconnection forced

00:27:17 sys@felix SQL>startup mount;

ORA-24324: service handle not initialized

ORA-01041: internal error. hostdefextension doesn't exist

00:27:25 sys@felix SQL>exit 

然后mount主库：

00:27:30 SQL>startup mount;

ORACLE instance started.

 

Total System Global Area 417546240 bytes

Fixed Size 2228944 bytes

Variable Size 289410352 bytes

Database Buffers 121634816 bytes

Redo Buffers 4272128 bytes

Database mounted. 

在standby库执行：

mount备库：

03:21:36 SQL>shutdown immediate;

Database closed.

Database dismounted.

ORACLE instance shut down.

03:21:48 SQL>startup mount;

ORACLE instance started.

 

Total System Global Area 417546240 bytes

Fixed Size 2228944 bytes

Variable Size 289410352 bytes

Database Buffers 121634816 bytes

Redo Buffers 4272128 bytes

Database mounted.

03:22:02 SQL> 

打开主库： 

00:27:41 SQL>alter database open; 

Database altered. 

把主库的切换状态进行切换过来，再试一下：

00:31:30 SQL>alter database commit to switchover to primary; 

Database altered. 

Ok，成功了，看来往下面走是有希望了 

继续，go！！！！

00:32:08 sys@felix SQL>select statusfrom v$instance; 

STATUS

------------------------

MOUNTED

 

00:32:22 sys@felix SQL>alter database open;

 

Database altered.

 

00:32:32 sys@felix SQL>selectswitchover_status from v$database; 

SWITCHOVER_STATUS

----------------------------------------

TO STANDBY 

终于看到to standby了，心里算是松了一口气！！ 

ok，开始真正的主备库的切换：

一定要注意：主库一定要处于open状态，备库一定要处于mount状态

 

0:41:57 sys@felix SQL> alter database commit to switchoverto physical standby 

Database altered.

主库执行成功： 

在备库要进行操作： 

03:46:06 SQL>select switchover_status from v$database; 

SWITCHOVER_STATUS

----------------------------------------

RECOVERY NEEDED

 03:46:46 SQL>alter database recover managed standbydatabase disconnect session;

alter database recovermanaged standby database disconnect session

*

ERROR at line 1:

ORA-00274: illegalrecovery option SESSION 

为什么错？？？少了一个关键字，from

03:52:23 SQL>alter database recover managed standby database disconnect FROMsession; 

Database altered. 

ORACLE instance shut down.

03:56:01 SQL>startup

ORACLE instance started.

 

Total System Global Area 417546240 bytes

Fixed Size 2228944 bytes

Variable Size 301993264 bytes

Database Buffers 109051904 bytes

Redo Buffers 4272128 bytes

Database mounted.

Database opened.

03:56:43 SQL>select switchover_status from v$database;

 

SWITCHOVER_STATUS

----------------------------------------

TO PRIMARY 

03:57:13 SQL>alter database commit to switchover to primary; 

Database altered. 

03:57:42 SQL>shutdown immediate;

ORA-01109: database not open

 

Database dismounted.

ORACLE instance shut down.

03:58:20 SQL> 

Ok，打开主备库： 

Ok，到此主备库已经完整切换了