duplicate資料庫的操作步驟

.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)
    )
  )