Knowledge Base : Duplicate Database on same host

  • create initial initSID.ora

    DB_NAME=test3
    DB_DOMAIN=loopback.org
    DB_FILE_NAME_CONVERT= (‘test1′,’test3′,’/home/oracle/app/oracle/oradata/test1′,’/home/oracle/app/oracle/oradata/test3’)
    CONTROL_FILES=’/home/oracle/app/oracle/oradata/test3/control01.ctl’
    LOG_FILE_NAME_CONVERT= (‘/home/oracle/app/oracle/oradata/test1′,’/home/oracle/app/oracle/oradata/test3’)

  • orapwd file=$ORACLE_HOME/dbs/orapwdSID
  • sqlplus / as sysdba, startup nomount
  • static listener configuration ($ORACLE_HOME/network/admin/listener.ora):

    SID_LIST_LISTENER=
    (SID_LIST=
    (SID_DESC=
    (GLOBAL_DBNAME=test3.loopback.org)
    (SID_NAME=test3)))

  • RMAN

    connect target sys/pass@source
    connect auxiliary sys/pass@duplicate
    duplicate database to test3 from active database;