复制数据库

Rman duplicate database

run
 {allocate channel d1 type disk maxpiecesize = 500m;
 backup full database format 'e:\rmans\db_%d_%s_%p_%t';
 release channel d1;
 }

oradim -new -sid clone -PFILE D:\oracle\ora92\database\INITclone.ORA -INTPWD SYS1

run
 {allocate channel d1 type disk maxpiecesize = 500m;
 backup archivelog all format 'e:\rmans\db_%d_%s_%p_%t';
 release channel d1;
 }

run
{allocate auxiliary channel d1 type disk;
set newname for datafile 1 to 'D:\oracle\oradata\clone\system01.dbf';
set newname for datafile 2 to 'D:\oracle\oradata\clone\UNDOTBS01.DBF';
 DUPLICATE TARGET DATABASE TO CLONE_DB
 LOGFILE
 GROUP 1 ('D:\oracle\oradata\clone\REDO01.DBF') SIZE 100M,
 GROUP 2 ('D:\oracle\oradata\clone\REDO02.DBF') SIZE 100M,
 GROUP 3 ('D:\oracle\oradata\clone\REDO03.DBF') SIZE 100M;
 }