-
两边安装os,db软件
-
dup1安装数据库,设置归档
-
dup2使用nomount启动
-
两边设置listener和tnsname
-
.audit_file_dest='/u01/oracle/app/admin/orcl/adump/'
*.audit_trail='db'
*.compatible='11.2.0.4'
*.control_files= (ora_control1, ora_control2)
*.db_block_size=8192
*.db_name='dup2'
db_file_name_convert=('/u01/oracle/app/oradata/dup1/','/u01/oracle/app/oradata/dup2/')
log_file_name_convert=('/u01/oracle/app/oradata/dup1/','/u01/oracle/app/oradata/dup2/')
---listener.ora:
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(ORACLE_HOME = /u01/oracle/app/product/11.2.0/dbhome_1)
(SID_NAME =dup1)
)
(SID_DESC =
(ORACLE_HOME = /u01/oracle/app/product/11.2.0/dbhome_1)
(SID_NAME =dup2)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = dup1.local.com)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)
ADR_BASE_LISTENER = /u01/oracle/app
--tnsnames.ora:
DUP2 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.5.104)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = dup2)
(UR=A)
)
)
DUP1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.5.103)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = dup1)
(UR=A)
)
)
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/21302630/viewspace-1781364/
,如需转载,请注明出处,否则将追究法律责任。