dg oracle 切换模式_oracle dg 主、备切换SWITCHOVER 全过程记录

[oracle@oraclep trace]$ ifconfig

enp0s3: flags=4163 mtu 1500

inet 10.0.2.15 netmask 255.255.255.0 broadcast 10.0.2.255

inet6 fe80::64d8:a56d:a1af:ef20 prefixlen 64 scopeid 0x20

ether 08:00:27:23:25:0d txqueuelen 1000 (Ethernet)

RX packets 313 bytes 25282 (24.6 KiB)

RX errors 0 dropped 0 overruns 0 frame 0

TX packets 475 bytes 37678 (36.7 KiB)

TX errors 0 dropped 0 overruns 0 carrier 0 collisions 0

enp0s8: flags=4163 mtu 1500

inet 192.168.56.118 netmask 255.255.255.0 broadcast 192.168.56.255

inet6 fe80::283a:c36b:b773:c4d8 prefixlen 64 scopeid 0x20

inet6 fe80::3765:e61f:d653:f584 prefixlen 64 scopeid 0x20

ether 08:00:27:ae:62:fc txqueuelen 1000 (Ethernet)

RX packets 992188 bytes 1473325892 (1.3 GiB)

RX errors 0 dropped 0 overruns 0 frame 0

TX packets 47580 bytes 30037450 (28.6 MiB)

TX errors 0 dropped 0 overruns 0 carrier 0 collisions 0

lo: flags=73 mtu 65536

inet 127.0.0.1 netmask 255.0.0.0

inet6 ::1 prefixlen 128 scopeid 0x10

loop txqueuelen 1000 (Local Loopback)

RX packets 13897 bytes 1135717 (1.0 MiB)

RX errors 0 dropped 0 overruns 0 frame 0

TX packets 13897 bytes 1135717 (1.0 MiB)

TX errors 0 dropped 0 overruns 0 carrier 0 collisions 0

[oracle@oraclep trace]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Thu Jul 4 13:39:43 2019

Copyright (c) 1982, 2011, Oracle. All rights reserved.

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select switchover_status,database_role from v$database;

SWITCHOVER_STATUS DATABASE_ROLE

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

TO STANDBY PRIMARY

SQL> exit

Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

[oracle@oraclep trace]$ ssh 192.168.56.117

oracle@192.168.56.117's password:

Last login: Thu Jul 4 11:42:57 2019

[oracle@oracles ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Thu Jul 4 13:45:47 2019

Copyright (c) 1982, 2011, Oracle. All rights reserved.

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select switchover_status,database_role from v$database;

SWITCHOVER_STATUS DATABASE_ROLE

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

NOT ALLOWED PHYSICAL STANDBY

SQL> exit

Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

[oracle@oracles ~]$ exit

登出

Connection to 192.168.56.117 closed.

[oracle@oraclep trace]$ sqlplus test/test

SQL*Plus: Release 11.2.0.3.0 Production on Thu Jul 4 13:46:02 2019

Copyright (c) 1982, 2011, Oracle. All rights reserved.

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select * from test;

no rows selected

SQL> insert into test values(1,2);

1 row created.

SQL> commit;

Commit complete.

SQL> exit

Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

[oracle@oraclep trace]$ ssh 192.168.56.117

oracle@192.168.56.117's password:

Last login: Thu Jul 4 13:45:34 2019 from 192.168.56.118

[oracle@oracles ~]$ sqlplus test/test

SQL*Plus: Release 11.2.0.3.0 Production on Thu Jul 4 13:46:57 2019

Copyright (c) 1982, 2011, Oracle. All rights reserved.

ERROR:

ORA-01033: ORACLE initialization or shutdown in progress

Process ID: 0

Session ID: 0 Serial number: 0

Enter user-name:

ERROR:

ORA-01017: invalid username/password; logon denied

Enter user-name:

ERROR:

ORA-01017: invalid username/password; logon denied