oracle 10g duplicate database

10g 复制数据库配置：

run {
aLLOCATE AUXILIARY CHANNEL c2 DEVICE TYPE 'SBT_TAPE'   parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=level3,OB2BARLIST=l3testing)';

set newname for datafile 1 to '/app/oradata/system01.dbf';
set newname for datafile 2 to '/app/oradata/undotbs01.dbf';
set newname for datafile 3 to '/app/oradata/sysaux01.dbf';
set newname for datafile 10 to '/app/oradata/test_bed.dbf';
SET NEWNAME FOR TEMPFILE 1 TO '/app/oradata/temp01.dbf';

DUPLICATE TARGET DATABASE TO orcl
SKIP TABLESPACE OTHER,USERS,JLW,JLW1,QM
LOGFILE
GROUP 1 ('/app/oradata/redo01a.log',
'/app/oradata/redo01b.log') SIZE 4M REUSE,
GROUP 2 ('/app/oradata/redo02a.log',
'/app/oradata/redo02b.log') SIZE 4M REUSE;

release   CHANNEL c2;
}

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/25702/viewspace-759713/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/25702/viewspace-759713/