在线精品99_中国九九盗摄偷拍偷看_91免费版在线观看_91.app_91高清视频在线_99热最新网站

switchover physical DB怎样互换primary DB

137次阅读
没有评论

共计 10535 个字符，预计需要花费 27 分钟才能阅读完成。

switchover physical DB 怎样互换 primary DB，相信很多没有经验的人对此束手无策，为此本文总结了问题出现的原因和解决方法，通过这篇文章希望你能解决这个问题。

PS：这一些实验是建立在我之前博客实验的基础上的

为什么要先 alter 先切主库   再切备库，
因为如果先切备库的话，那么主库的一些日志可能备库收不到，导致不一致的情况发生

先切主库 —— standby DB 切换之后主库是断开 close 的，重新 open 后查看其状态

20:53:33 SYS @ slow select name,database_role,protection_mode,switchover_status from v$database;

NAME   DATABASE_ROLE    PROTECTION_MODE SWITCHOVER_STATUS

——— —————- ——————– ——————–

SLOW  PRIMARY    MAXIMUM AVAILABILITY TO STANDBY

1 row selected.

Elapsed: 00:00:00.00

20:55:15 SYS @ slow edit

Wrote file afiedt.buf

 1* select username,sid,serial# from v$session where username is not null

20:55:24 SYS @ slow r

 1* select username,sid,serial# from v$session where username is not null

USERNAME       SID    SERIAL#

—————————— ———- ———-

SYS 1    5

1 row selected.

Elapsed: 00:00:00.01

20:55:25 SYS @ slow r

 1* select username,sid,serial# from v$session where username is not null

USERNAME       SID    SERIAL#

—————————— ———- ———-

SYS 1    5

SCOTT        41   47

2 rows selected.

Elapsed: 00:00:00.00

20:56:25 SYS @ slow alter database commit to switchover to standby;

Database altered.

Elapsed: 00:00:01.89

20:57:05 SYS @ slow select name,database_role,protection_mode,switchover_status from v$database;

select name,database_role,protection_mode,switchover_status from v$database

*

ERROR at line 1:

ORA-01034: ORACLE not available

Process ID: 5713

Session ID: 1 Serial number: 5

Elapsed: 00:00:00.00

20:58:08 SYS @ slow select status from v$instance;

select status from v$instance

*

ERROR at line 1:

ORA-01034: ORACLE not available

Process ID: 5713

Session ID: 1 Serial number: 5

Elapsed: 00:00:00.00

20:58:46 SYS @ slow startup

ORACLE instance started.

Total System Global Area  521936896 bytes

Fixed Size     2254824 bytes

Variable Size   377489432 bytes

Database Buffers   138412032 bytes

Redo Buffers     3780608 bytes

Database mounted.

Database opened.

21:07:19 SYS @ slow select name,open_mode,database_role,protection_mode,switchover_status from v$database;

NAME   OPEN_MODE        DATABASE_ROLE PROTECTION_MODE      SWITCHOVER_STATUS

——— ——————– —————- ——————– ——————–

SLOW   READ ONLY        PHYSICAL STANDBY MAXIMUM AVAILABILITY TO PRIMARY

1 row selected.

Elapsed: 00:00:00.01

21:07:55 SYS @ slow recover managed standby database disconnect;

Media recovery complete.

21:08:35 SYS @ slow select name,open_mode,database_role,protection_mode,switchover_status from v$database;

NAME   OPEN_MODE        DATABASE_ROLE PROTECTION_MODE      SWITCHOVER_STATUS

——— ——————– —————- ——————– ——————–

SLOW   READ ONLY WITH APPLY PHYSICAL STANDBY MAXIMUM AVAILABILITY TO PRIMARY

1 row selected.

Elapsed: 00:00:00.00

21:09:02 SYS @ slow

再切换备库 —– primary DB   备库 mount 状态下操作   成功?。。?/p>

20:52:21 SYS @ gotime select name,database_role,protection_mode,switchover_status from v$database;

NAME   DATABASE_ROLE    PROTECTION_MODE SWITCHOVER_STATUS

——— —————- ——————– ——————–

SLOW   PHYSICAL STANDBY MAXIMUM AVAILABILITY NOT ALLOWED

1 row selected.

Elapsed: 00:00:00.01

20:53:12 SYS @ gotime r

 1* select name,database_role,protection_mode,switchover_status from v$database

NAME   DATABASE_ROLE    PROTECTION_MODE SWITCHOVER_STATUS

——— —————- ——————– ——————–

SLOW   PHYSICAL STANDBY MAXIMUM AVAILABILITY NOT ALLOWED

1 row selected.

Elapsed: 00:00:00.00

20:59:16 SYS @ gotime select username,sid from v$session where username is not null;

USERNAME       SID

—————————— ———-

SYS        24

1 row selected.

Elapsed: 00:00:00.01

21:02:26 SYS @ gotime alter database commit to switchover to primary with session shutdown;

alter database commit to switchover to primary with session shutdown

*

ERROR at line 1:

ORA-16139: media recovery required

Elapsed: 00:00:00.01

21:03:18 SYS @ gotime recover managed standby database disconnect;

Media recovery complete.

21:03:51 SYS @ gotime alter database commit to switchover to primary with session shutdown;

Database altered.

Elapsed: 00:00:02.04

21:05:00 SYS @ gotime select name,database_role,protection_mode,switchover_status from v$database;

NAME   DATABASE_ROLE    PROTECTION_MODE SWITCHOVER_STATUS

——— —————- ——————– ——————–

SLOW  PRIMARY    MAXIMUM AVAILABILITY NOT ALLOWED

1 row selected.

Elapsed: 00:00:00.01

21:05:12 SYS @ gotime alter database open;

Database altered.

Elapsed: 00:00:00.58

21:05:45 SYS @ gotime select name,database_role,protection_mode,switchover_status from v$database;

NAME   DATABASE_ROLE    PROTECTION_MODE SWITCHOVER_STATUS

——— —————- ——————– ——————–

SLOW  PRIMARY    MAXIMUM AVAILABILITY FAILED DESTINATION

1 row selected.

Elapsed: 00:00:00.01

21:06:13 SYS @ gotime

————————————– 但是，switchover_status 是 failed destination 状态 ——————————————

switchover 之后的备库 slow，重新启动 listener

[oracle@slow ~]$ lsnrctl stop

LSNRCTL for Linux: Version 11.2.0.4.0 – Production on 13-JAN-2018 21:31:12

Copyright (c) 1991, 2013, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=slow)(PORT=1521)))

TNS-12541: TNS:no listener

 TNS-12560: TNS:protocol adapter error

 TNS-00511: No listener

 Linux Error: 111: Connection refused

[oracle@slow ~]$ lsnrctl start

LSNRCTL for Linux: Version 11.2.0.4.0 – Production on 13-JAN-2018 21:31:20

Copyright (c) 1991, 2013, Oracle. All rights reserved.

Starting /u01/app/oracle/product/11.2.0/dbhome_1/bin/tnslsnr: please wait…

TNSLSNR for Linux: Version 11.2.0.4.0 – Production

System parameter file is /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora

Log messages written to /u01/app/oracle/diag/tnslsnr/slow/listener/alert/log.xml

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=slow)(PORT=1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=slow)(PORT=1521)))

STATUS of the LISTENER

————————

Alias                     LISTENER

Version                   TNSLSNR for Linux: Version 11.2.0.4.0 – Production

Start Date 13-JAN-2018 21:31:20

Uptime                    0 days 0 hr. 0 min. 0 sec

Trace Level off

Security ON: Local OS Authentication

SNMP OFF

Listener Parameter File /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora

Listener Log File /u01/app/oracle/diag/tnslsnr/slow/listener/alert/log.xml

Listening Endpoints Summary…

 (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=slow)(PORT=1521)))

The listener supports no services

The command completed successfully

[oracle@slow ~]$ lsnrctl status

LSNRCTL for Linux: Version 11.2.0.4.0 – Production on 13-JAN-2018 21:31:23

Copyright (c) 1991, 2013, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=slow)(PORT=1521)))

STATUS of the LISTENER

————————

Alias                     LISTENER

Version                   TNSLSNR for Linux: Version 11.2.0.4.0 – Production

Start Date 13-JAN-2018 21:31:20

Uptime                    0 days 0 hr. 0 min. 2 sec

Trace Level off

Security ON: Local OS Authentication

SNMP OFF

Listener Parameter File /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora

Listener Log File /u01/app/oracle/diag/tnslsnr/slow/listener/alert/log.xml

Listening Endpoints Summary…

 (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=slow)(PORT=1521)))

The listener supports no services

The command completed successfully

关闭 slow 备库，再打开 mount 状态

21:28:36 SYS @ slow shutdown immediate;

Database closed.

Database dismounted.

ORACLE instance shut down.

21:28:53 SYS @ slow startup mount;

ORACLE instance started.

Total System Global Area  521936896 bytes

Fixed Size     2254824 bytes

Variable Size   377489432 bytes

Database Buffers   138412032 bytes

Redo Buffers     3780608 bytes

Database mounted.

21:29:08 SYS @ slow

等 slow 备库重新启动之后，状态为 ready 了

[oracle@slow ~]$ lsnrctl status

LSNRCTL for Linux: Version 11.2.0.4.0 – Production on 13-JAN-2018 21:32:05

Copyright (c) 1991, 2013, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=slow)(PORT=1521)))

STATUS of the LISTENER

————————

Alias LISTENER

Version TNSLSNR for Linux: Version 11.2.0.4.0 – Production

Start Date 13-JAN-2018 21:31:20

Uptime 0 days 0 hr. 0 min. 44 sec

Trace Level off

Security ON: Local OS Authentication

SNMP OFF

Listener Parameter File /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora

Listener Log File /u01/app/oracle/diag/tnslsnr/slow/listener/alert/log.xml

Listening Endpoints Summary…

 (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=slow)(PORT=1521)))

Services Summary…

Service slow has 1 instance(s).

 Instance slow , status READY, has 1 handler(s) for this service…

The command completed successfully

[oracle@slow ~]$

现在的主库 gotime 这边重启 listener

[grid@sink ~]$ lsnrctl stop

LSNRCTL for Linux: Version 11.2.0.4.0 – Production on 13-JAN-2018 21:31:41

Copyright (c) 1991, 2013, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=sink)(PORT=1521)))

The command completed successfully

[grid@sink ~]$ lsnrctl start

LSNRCTL for Linux: Version 11.2.0.4.0 – Production on 13-JAN-2018 21:31:46

Copyright (c) 1991, 2013, Oracle. All rights reserved.

Starting /u01/11.2.0/grid/bin/tnslsnr: please wait…

TNSLSNR for Linux: Version 11.2.0.4.0 – Production

System parameter file is /u01/11.2.0/grid/network/admin/listener.ora

Log messages written to /u01/app/grid/diag/tnslsnr/sink/listener/alert/log.xml

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=sink)(PORT=1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=sink)(PORT=1521)))

STATUS of the LISTENER

————————

Alias                     LISTENER

Version                   TNSLSNR for Linux: Version 11.2.0.4.0 – Production

Start Date 13-JAN-2018 21:31:46

Uptime                    0 days 0 hr. 0 min. 0 sec

Trace Level off

Security ON: Local OS Authentication

SNMP OFF

Listener Parameter File /u01/11.2.0/grid/network/admin/listener.ora

Listener Log File /u01/app/grid/diag/tnslsnr/sink/listener/alert/log.xml

Listening Endpoints Summary…

 (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=sink)(PORT=1521)))

Services Summary…

Service gotime has 1 instance(s).

 Instance gotime , status UNKNOWN, has 1 handler(s) for this service…

The command completed successfully

[grid@sink ~]$

gotime 主库重新启动，到 open

21:32:12 SYS @ gotime startup force;

ORACLE instance started.

Total System Global Area  521936896 bytes

Fixed Size     2254824 bytes

Variable Size   377489432 bytes

Database Buffers   138412032 bytes

Redo Buffers     3780608 bytes

Database mounted.

Database opened.

21:32:35 SYS @ gotime

switchover 之后的备库 slow，查询其状态，not allowed，正常了?。?/p>

21:29:08 SYS @ slow recover managed standby database disconnect;

Media recovery complete.

21:29:32 SYS @ slow select name,open_mode,database_role,protection_mode,switchover_status from v$database;

NAME   OPEN_MODE        DATABASE_ROLE PROTECTION_MODE      SWITCHOVER_STATUS

——— ——————– —————- ——————– ——————–

SLOW   MOUNTED        PHYSICAL STANDBY MAXIMUM AVAILABILITY NOT ALLOWED

1 row selected.

Elapsed: 00:00:00.01

21:33:16 SYS @ slow

在查询状态，为 to standby 了，正常了??！

21:32:35 SYS @ gotime select name,open_mode,database_role,protection_mode,switchover_status from v$database

21:32:45   2 ;

NAME   OPEN_MODE        DATABASE_ROLE PROTECTION_MODE      SWITCHOVER_STATUS

——— ——————– —————- ——————– ——————–

SLOW   READ WRITE  PRIMARY MAXIMUM AVAILABILITY TO STANDBY

1 row selected.

Elapsed: 00:00:00.02

21:32:47 SYS @ gotime

看完上述内容，你们掌握 switchover physical DB 怎样互换 primary DB 的方法了吗？如果还想学到更多技能或想了解更多相关内容，欢迎关注丸趣 TV 行业资讯频道，感谢各位的阅读！

正文完
发表至： 数据库
2023-07-18
 
丸趣
版权声明：本站原创文章，由 丸趣 2023-07-18发表，共计10535字。
转载说明：除特殊说明外本站除技术相关以外文章皆由网络搜集发布，转载请注明出处。
评论（没有评论）
主站蜘蛛池模板： 久99视频 | 亚洲图片 中文字幕 | 国产成人午夜性a一级毛片 国产成人午夜性视频影院 国产成人系列 | 欧美国产精品va在线观看 | 久久国 | 欧美一区二区三区大片 | 午夜男人网站 | 久久视频精品线视频在线网站 | 日本理伦片午夜理伦片 | 国内精品周妍希在线播放 | 久久国产亚洲精品赲碰热 | 久艹视频在线观看 | 亚洲国产精品无码久久久秋霞2 | 日本a∨在线播放高清 | 毛片电影在线 | 欧美一区二区三区在线可观看 | 深夜福利视频网站 | 欧美牲交a欧美牲交aⅴ免费真 | 毛片高清视频在线看免费观看 | 久久精品视频2 | 青青青久在线视频免费观看 | 一级毛毛片| 国产精品色婷婷在线观看 | 视频偷拍一级视频在线观看 | 99青青 | 国内老熟妇对白xxxxhd | 亚洲综合日韩久久成人av | 久久伊人电影 | 在线看免费毛片 | 欧美大片va欧美在线播放 | 亚洲免费网站观看视频 | 国产成人综合亚洲怡春院 | 最爽无遮挡行房视频 | 久久精品久久精品久久精品 | 国产日韩欧美中文字幕 | 亚洲国产欧美自拍 | 亚洲精品无码一区二区三区久久久 | 天天狠狠色综合图片区 | 黄网站免费在线观看 | 四虎色播| 国产在线永久视频 |