oracleADG增加备库
新增备库主机:
192.168.66.44
主机名:dgd
sid:orcl
网络别名:orcl_sd
下文中称之为“备2”
1,更改现在的主备文件
hosts文件,tnsnames.ora文件,initorcl.ora文件
1.1,更改hosts文件
把新增的主机加上
主:
[oracle@db dbs]$ cat /etc/hosts
127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4
::1 localhost localhost.localdomain localhost6 localhost6.localdomain6
192.168.66.61 db
192.168.66.62 dg
192.168.66.64 dgd
备1:
[oracle@dg dbs]$ cat /etc/hosts
127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4
::1 localhost localhost.localdomain localhost6 localhost6.localdomain6
192.168.66.61 db
192.168.66.62 dg
192.168.66.64 dgd
备2:
[oracle@dgd ~]$ cat /etc/hosts
127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4
::1 localhost localhost.localdomain localhost6 localhost6.localdomain6
192.168.66.61 db
192.168.66.62 dg
192.168.66.64 dgd
1.2,修改tnsnames.ora文件
主:
#增加下面内容
[oracle@db admin]$ vim tnsnames.ora
orcl_sd =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = dgd)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
(SERVER = DEDICATED)
)
)
备1:
#增加下面内容
[oracle@dg admin]$ vim tnsnames.ora
orcl_sd =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = dgd)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
(SERVER = DEDICATED)
)
)
备3:
[oracle@dgd admin]$ cat tnsnames.ora
# tnsnames.ora Network Configuration File: /data/app/oracle/product/11.2.0.4/db_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = dgd)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
orcl_pri =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = db)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
(SERVER = DEDICATED)
)
)
orcl_sty =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = dg)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
(SERVER = DEDICATED)
)
)
orcl_sd =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = dgd)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
(SERVER = DEDICATED)
)
)
1.3,修改pfile文件
主:
#修改和增加了以下内容
[oracle@db dbs]$ pwd
/data/app/oracle/product/11.2.0.4/db_1/dbs
[oracle@db dbs]$ vim initorcl.ora
*.log_archive_config='dg_config=(orcl_pri,orcl_sty,orcl_sd)'</