Physical Standby Switchover_status Showing Not Allowed

状态列表:

In Oracle documentation explain SWITCHOVER_STATUS column of v$database can have the following values:

NOT ALLOWED – Either this is a standby database and the primary database has not been switched first, or this is a primary database and there are no standby databases.

SESSIONS ACTIVE – Indicates that there are active SQL sessions attached to the primary or standby database that need to be disconnected before the switchover operation is permitted.

SWITCHOVER PENDING – This is a standby database and the primary database switchover request has been received but not processed.

SWITCHOVER LATENT – The switchover was in pending mode, but did not complete and went back to the primary database.

TO PRIMARY – This is a standby database, with no active sessions, that is allowed to switch over to a primary database.

TO STANDBY – This is a primary database, with no active sessions, that is allowed to switch over to a standby database.

RECOVERY NEEDED – This is a standby database that has not received the switchover request.

解决:

SQL>  select name,database_role,switchover_status from v$database;

NAME                        DATABASE_ROLE                                    SWITCHOVER_STATUS
--------------------------- ------------------------------------------------ ------------------------------------------------------------
MTXDB                       PHYSICAL STANDBY                                 NOT ALLOWED

SQL>  select PROCESS, STATUS, GROUP#, SEQUENCE#, BLOCK#, BLOCKS from v$managed_standby;

PROCESS                     STATUS                               GROUP#                                                                                                                    SEQUENCE#     BLOCK#     BLOCKS
--------------------------- ------------------------------------ ------------------------------------------------------------------------------------------------------------------------ ---------- ---------- ----------
ARCH                        CONNECTED                            N/A                                                                                                                               0          0          0
DGRD                        ALLOCATED                            N/A                                                                                                                               0          0          0
DGRD                        ALLOCATED                            N/A                                                                                                                               0          0          0
ARCH                        CONNECTED                            N/A                                                                                                                               0          0          0
ARCH                        CONNECTED                            N/A                                                                                                                               0          0          0
ARCH                        CONNECTED                            N/A                                                                                                                               0          0          0
MRP0                        APPLYING_LOG                         N/A                                                                                                                              57       2346     409600
RFS                         IDLE                                 N/A                                                                                                                               0          0          0
RFS                         IDLE                                 2                                                                                                                                57       2346          1

9 rows selected.

SQL> select database_role,switchover_status from v$database;

DATABASE_ROLE                                    SWITCHOVER_STATUS
------------------------------------------------ ------------------------------------------------------------
PHYSICAL STANDBY                                 NOT ALLOWED

SQL> alter database recover managed standby database finish force;

Database altered.

SQL> select database_role,switchover_status from v$database;

DATABASE_ROLE                                    SWITCHOVER_STATUS
------------------------------------------------ ------------------------------------------------------------
PHYSICAL STANDBY                                 TO PRIMARY

SQL> shutdown immediate;
ORA-01109: database not open


Database dismounted.
ORACLE instance shut down.
SQL> startup;
ORACLE instance started.

Total System Global Area 2466250400 bytes
Fixed Size                  9137824 bytes
Variable Size             536870912 bytes
Database Buffers         1912602624 bytes
Redo Buffers                7639040 bytes
Database mounted.
Database opened.
SQL> alter database recover managed standby database disconnect from session;

Database altered.

SQL> select database_role,switchover_status from v$database;

DATABASE_ROLE                                    SWITCHOVER_STATUS
------------------------------------------------ ------------------------------------------------------------
PHYSICAL STANDBY                                 TO PRIMARY

 产生DataGuard ora-16157故障:

关于这个问题,oracle 官方的回答是要重装DG,考虑实际情况,alter database recover managed standby database finish force 之后,系统没有更改,只需要在nomount 备库之后,在主库产生standby backup control file,然后在备机用些控制文件加载就可以了,测试通过.

在主库

SQL> alter system archive log current;

System altered.

SQL> alter system checkpoint;

System altered.

SQL> SELECT UNIQUE THREAD#, MAX(SEQUENCE#) OVER(PARTITION BY THREAD#) LAST FROM v$archived_log;

   THREAD#       LAST
---------- ----------
         1         66
SQL> ALTER DATABASE CREATE standby CONTROLFILE AS ‘/tmp/controlfs01.ctl‘;

 Database altered.

--scp到备库
 

在备库:

SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount;
ORACLE instance started.

 

Physical Standby Switchover_status Showing Not Allowed

上一篇:MySQL学习4——外键


下一篇:scrapy爬取海量数据并保存在MongoDB和MySQL数据库中