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

switchover physical DB怎样互换primary DB

116次阅读
没有评论

共计 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 状态下操作   成功！！！

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，正常了！！

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-17
 
丸趣
版权声明：本站原创文章，由 丸趣 2023-07-17发表，共计10535字。
转载说明：除特殊说明外本站除技术相关以外文章皆由网络搜集发布，转载请注明出处。
评论（没有评论）
主站蜘蛛池模板： 国产三级在线播放 | 日本久久道一区二区三区 | 亚洲深夜在线 | 日韩毛片在线 | 中文字幕久久精品一二三区 | 国产乱理伦片a级在线观看 国产乱理伦片在线观看 | 亚洲av无一区二区三区久久 | 亚洲人成在线中文字幕 | 午夜亚洲福利在线老司机 | 女邻居做爰2在线观看 | 久久久一本 | 欧美另类 videos黑人极品 | 国产成人免费网站在线观看 | 亚洲欧美精品一区天堂久久 | 日日摸日日碰夜夜爽无 | 亚洲精品9999久久久久无码 | 一级毛片一级毛片一级级毛片 | 2020年最新国产精品视频免费 | 亚洲精品一区久久久久久 | 日本黄大片影院一区二区 | 日本一区二区高清不卡 | 国产欧美日韩在线不卡第一页 | 一本一道精品欧美中文字幕 | 色妞av永久一区二区国产av | 中文字幕久久久久一区 | 国产一区二区久久精品 | 欧美日韩国产免费一区二区三区 | 亚洲成人网在线观看 | 久久免费国产精品一区二区 | 日本天堂免费观看 | 天天做日日做天天添天天欢公交车 | 成人人免费夜夜视频观看 | 2019国产夜间视频 | 草草影院www色欧美极品 | 国内自拍视频在线播放 | 午夜一区二区国产好的精华液 | 毛片2016免费视频 | 狠狠综合亚洲综合亚洲色 | 97se亚洲国产综合自在线 | 午夜无码人妻av大片色欲 | 亚洲精品午夜久久aaa级久久久 |