ITPub博客

首页 > 数据库 > Oracle > duplicate数据库的操作步骤

duplicate数据库的操作步骤

原创 Oracle 作者:peng163fj 时间:2015-08-24 18:01:07 0 删除 编辑
  1. 两边安装os,db软件
  2. dup1安装数据库,设置归档
  3. dup2使用nomount启动
  4. 两边设置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博客 ” ,链接:http://blog.itpub.net/21302630/viewspace-1781364/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2013-11-20

  • 博文量
    155
  • 访问量
    381156