Data Guard 环境修改主备库IP地址

 

       公司机房搬迁，Data Guard 环境需要修改IP地址。 提前整理顺便测试一下。 虽然只有几步，但怕晚上头晕了出了纰漏。  整理好了，晚上直接按文档，一步一步操作就可以了。

 

 

一.  IP 及数据库信息

修改之前：

主库：192.168.2.242

备库：192.168.2.243

 

修改之后：

主库：192.168.2.22

备库：192.168.2.23

 

数据库版本： 10.2.0.5

 

操作系统版本： Redhat 5.5

 

 

二. Shutdown 主备库实例及监听

2.1 shutdown 主库

SQL> select db_unique_name,open_mode from v$database;

 

DB_UNIQUE_NAME                 OPEN_MODE

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

xezf_pd                        READ WRITE

 

SQL> shutdown immediate

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL>

 

2.2 shutdown 备库

SQL> select db_unique_name,open_mode from v$database;

DB_UNIQUE_NAME    OPEN_MODE

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

xezf_st                MOUNTED

 

SQL> shutdown immediate

ORA-01109: database not open

 

 

Database dismounted.

ORACLE instance shut down.

 

2.3 停主备库的监听

[oracle@dg1 ~]$ lsnrctl stop

 

LSNRCTL for Linux: Version 10.2.0.5.0 - Production on 20-DEC-2010 09:49:43

 

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

 

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

The command completed successfully

[oracle@dg1 ~]$

 

[oracle@dg2 ~]$ lsnrctl stop

 

LSNRCTL for Linux: Version 10.2.0.5.0 - Production on 20-DEC-2010 09:49:50

 

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

 

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

The command completed successfully

[oracle@dg2 ~]$

 

 

三. 修改服务器IP信息

 

3.1 主库操作

3.1.1修改IP

[root@dg1 ~]# cat /etc/hosts

# Do not remove the following line, or various programs

# that require network functionality will fail.

127.0.0.1               localhost.localdomain localhost

#::1            localhost6.localdomain6 localhost6

192.168.2.22            dg1

 

[root@dg1 ~]# cat /etc/sysconfig/network

NETWORKING=yes

NETWORKING_IPV6=no

HOSTNAME=dg1

GATEWAY=192.168.2.1

 

[root@dg1 ~]# cat /etc/sysconfig/network-scripts/ifcfg-eth0

# Broadcom Corporation NetXtreme II BCM5716 Gigabit Ethernet

DEVICE=eth0

BOOTPROTO=static

BROADCAST=192.168.2.255

HWADDR=84:2B:2B:67:43:B9

IPADDR=192.168.2.22

NETMASK=255.255.255.0

NETWORK=192.168.2.0

ONBOOT=yes

 

3.1.2 重启network

[root@dg1 ~]# service network restart

 

3.1.3修改监听信息

 

[oracle@dg1 admin]$ cat listener.ora

# listener.ora Network Configuration File: /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora

# Generated by Oracle configuration tools.

 

SID_LIST_LISTENER =

  (SID_LIST =

    (SID_DESC =

      (SID_NAME = PLSExtProc)

      (ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1)

      (PROGRAM = extproc)

    )

    (SID_DESC =

      (SID_NAME = xezf)

      (ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1)

      (GLOBAL_DBNAME = xezf)

    )

  )

 

LISTENER =

  (DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST = dg1)(PORT = 1521))

  )

 

[oracle@dg1 admin]$ cat tnsnames.ora  

# tnsnames.ora Network Configuration File: /u01/app/oracle/product/10.2.0/db_1/network/admin/tnsnames.ora

# Generated by Oracle configuration tools.

 

XEZF =

  (DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST = dg1)(PORT = 1521))

    (CONNECT_DATA =

      (SERVER = DEDICATED)

      (SERVICE_NAME = xezf)

    )

  )

 

XEZF_PD =

  (DESCRIPTION =

    (ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.22)(PORT = 1521))

    )

    (CONNECT_DATA =

      (SERVICE_NAME = xezf)

    )

  )

 

XEZF_ST =

  (DESCRIPTION =

    (ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.23)(PORT = 1521))

    )

    (CONNECT_DATA =

      (SERVICE_NAME = xezf)

    )

  )

 

LISTENER_XEZF =

  (ADDRESS = (PROTOCOL = TCP)(HOST = dg1)(PORT = 1521))

 

 

EXTPROC_CONNECTION_DATA =

  (DESCRIPTION =

    (ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))

    )

    (CONNECT_DATA =

      (SID = PLSExtProc)

      (PRESENTATION = RO)

    )

  )

 

3.2 备库操作

3.2.1修改IP

[root@dg2 ~]# cat /etc/hosts

# Do not remove the following line, or various programs

# that require network functionality will fail.

127.0.0.1               localhost.localdomain localhost

#::1            localhost6.localdomain6 localhost6

192.168.2.23            dg2

 

[root@dg2 ~]# cat /etc/sysconfig/network

NETWORKING=yes

NETWORKING_IPV6=no

HOSTNAME=dg2

GATEWAY=192.168.2.1

 

[root@dg2 ~]# cat /etc/sysconfig/network-scripts/ifcfg-eth0

# Broadcom Corporation NetXtreme II BCM5708 Gigabit Ethernet

DEVICE=eth0

BOOTPROTO=static

BROADCAST=192.168.2.255

HWADDR=00:1E:C9:DA:AE:95

IPADDR=192.168.2.23

NETMASK=255.255.255.0

NETWORK=192.168.2.0

ONBOOT=yes

 

3.2.2 重启network

[root@dg2 ~]# service network restart

 

3.2.3 修改监听信息

 

[oracle@dg2 admin]$ cat listener.ora

# listener.ora Network Configuration File: /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora

# Generated by Oracle configuration tools.

 

SID_LIST_LISTENER =

  (SID_LIST =

    (SID_DESC =

      (SID_NAME = PLSExtProc)

      (ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1)

      (PROGRAM = extproc)

    )

    (SID_DESC =

      (SID_NAME = xezf)

      (ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1)

      (GLOBAL_DBNAME = xezf)

    )

  )

 

LISTENER =

  (DESCRIPTION_LIST =

    (DESCRIPTION =

      (ADDRESS = (PROTOCOL = TCP)(HOST = dg2)(PORT = 1521))

    )

  )

 

[oracle@dg2 admin]$ cat tnsnames.ora

# tnsnames.ora Network Configuration File: /u01/app/oracle/product/10.2.0/db_1/network/admin/tnsnames.ora

# Generated by Oracle configuration tools.

 

EXTPROC_CONNECTION_DATA =

  (DESCRIPTION =

    (ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))

    )

    (CONNECT_DATA =

      (SID = PLSExtProc)

      (PRESENTATION = RO)

    )

  )

 

xezf_pd =

  (DESCRIPTION =

    (ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.22)(PORT = 1521))

    )

    (CONNECT_DATA =

      (SERVICE_NAME = xezf)

    )

  )

 

xezf_st =

  (DESCRIPTION =

    (ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.23)(PORT = 1521))

    )

    (CONNECT_DATA =

      (SERVICE_NAME = xezf)

    )

  )

 

 

四. 启动Data Guard并验证同步

 

4.1 启动备库监听和实例

 

4.1.1  启动监听

[oracle@dg2 ~]$ lsnrctl start

 

LSNRCTL for Linux: Version 10.2.0.5.0 - Production on 20-DEC-2010 10:11:47

 

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

 

Starting /u01/app/oracle/product/10.2.0/db_1/bin/tnslsnr: please wait...

 

TNSLSNR for Linux: Version 10.2.0.5.0 - Production

System parameter file is /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora

Log messages written to /u01/app/oracle/product/10.2.0/db_1/network/log/listener.log

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

 

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

STATUS of the LISTENER

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

Alias                     LISTENER

Version                   TNSLSNR for Linux: Version 10.2.0.5.0 - Production

Start Date                20-DEC-2010 10:11:47

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/10.2.0/db_1/network/admin/listener.ora

Listener Log File         /u01/app/oracle/product/10.2.0/db_1/network/log/listener.log

Listening Endpoints Summary...

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

Services Summary...

Service "PLSExtProc" has 1 instance(s).

  Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...

Service "xezf" has 1 instance(s).

  Instance "xezf", status UNKNOWN, has 1 handler(s) for this service...

The command completed successfully

[oracle@dg2 ~]$

 

4.1.2 启动实例至mount状态

[oracle@dg2 ~]$ sqlplus /nolog

 

SQL*Plus: Release 10.2.0.5.0 - Production on Mon Dec 20 10:12:34 2010

 

Copyright (c) 1982, 2010, Oracle.  All Rights Reserved.

 

SQL> conn / as sysdba;

Connected to an idle instance.

SQL> startup nomount;

ORACLE instance started.

 

Total System Global Area 5251268608 bytes

Fixed Size                  2103600 bytes

Variable Size             939525840 bytes

Database Buffers         4294967296 bytes

Redo Buffers               14671872 bytes

SQL> alter database mount standby database;

Database altered.

 

SQL> alter database recover managed standby database disconnect from session;

Database altered.

 

SQL>

 

 

4.2  启动主库监听和实例

 

4.2.1 启动主库监听

[oracle@dg1 ~]$ lsnrctl start

 

LSNRCTL for Linux: Version 10.2.0.5.0 - Production on 20-DEC-2010 10:15:23

 

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

 

Starting /u01/app/oracle/product/10.2.0/db_1/bin/tnslsnr: please wait...

 

TNSLSNR for Linux: Version 10.2.0.5.0 - Production

System parameter file is /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora

Log messages written to /u01/app/oracle/product/10.2.0/db_1/network/log/listener.log

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

 

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

STATUS of the LISTENER

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

Alias                     LISTENER

Version                   TNSLSNR for Linux: Version 10.2.0.5.0 - Production

Start Date                20-DEC-2010 10:15:23

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/10.2.0/db_1/network/admin/listener.ora

Listener Log File         /u01/app/oracle/product/10.2.0/db_1/network/log/listener.log

Listening Endpoints Summary...

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

Services Summary...

Service "PLSExtProc" has 1 instance(s).

  Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...

Service "xezf" has 1 instance(s).

  Instance "xezf", status UNKNOWN, has 1 handler(s) for this service...

The command completed successfully

 

4.2.2 启动主库实例至open状态

[oracle@dg1 ~]$ sqlplus /nolog

 

SQL*Plus: Release 10.2.0.5.0 - Production on Mon Dec 20 10:15:51 2010

 

Copyright (c) 1982, 2010, Oracle.  All Rights Reserved.

 

SQL> conn / as sysdba;

Connected to an idle instance.

SQL> startup

ORACLE instance started.

 

Total System Global Area 5251268608 bytes

Fixed Size                  2103600 bytes

Variable Size             939525840 bytes

Database Buffers         4294967296 bytes

Redo Buffers               14671872 bytes

Database mounted.

Database opened.

SQL>

 

4.3 验证主备库同步

 

4.3.1 检查归档目录是否有误

SQL> select error from v$archive_dest;

 

ERROR

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

 

 

10 rows selected.

 

SQL>

 

正常，没有错误。

 

4.3.2 在主库手工切换归档

SQL> alter system switch logfile;

System altered.

 

4.3.3 查看主库归档情况

SQL> select max(sequence#) from v$archived_log;

 

MAX(SEQUENCE#)

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

            25

 

4.3.4 查看备库归档情况

 

SQL> select sequence#,applied from v$archived_log;

 

 SEQUENCE# APP

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

         1 YES

         2 YES

         3 YES

         4 YES

         4 YES

         5 YES

         5 YES

         6 YES

         6 NO

         7 YES

         8 YES

 

 SEQUENCE# APP

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

         9 YES

        10 YES

        11 YES

        12 YES

        13 YES

        14 YES

        15 YES

        16 YES

        17 YES

        18 YES

        19 YES

 

 SEQUENCE# APP

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

        20 YES

        21 YES

        22 YES

        23 YES

        24 YES

        25 YES

 

28 rows selected.

 

主备一致，同步正常。 IP 修改成功。

 

 

 

 

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

Blog： http://blog.csdn.net/tianlesoftware

网上资源： http://tianlesoftware.download.csdn.net

相关视频：http://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx

DBA1 群：62697716(满); DBA2 群：62697977(满)

DBA3 群：62697850   DBA 超级群：63306533;    

聊天 群：40132017

--加群需要在备注说明Oracle表空间和数据文件的关系，否则拒绝申请