sorry sto se kasno javljam.
pravi db cloning se radi sa RMAN Backup-om sa komandom: 'duplicate target database to <newInstanceName>'.
ali posto kazes da imas 'ladni backup, mozes da jednostavno da odradis:
kopiras sve DB file-ove i uradis CREATE CONTROLFILE:
CREATE CONTROLFILE
SET DATABASE prod
(prod ti je ime clon baze-nove)
LOGFILE GROUP 1 ('/u01/oracle/prod/redo01_01.log',
'/u01/oracle/prod/redo01_02.log'),
GROUP 2 ('/u01/oracle/prod/redo02_01.log',
'/u01/oracle/prod/redo02_02.log'),
GROUP 3 ('/u01/oracle/prod/redo03_01.log',
'/u01/oracle/prod/redo03_02.log')
NORESETLOGS
DATAFILE '/u01/oracle/prod/system01.dbf' SIZE 3M,
'/u01/oracle/prod/rbs01.dbs' SIZE 5M,
'/u01/oracle/prod/users01.dbs' SIZE 5M,
'/u01/oracle/prod/temp01.dbs' SIZE 5M
MAXLOGFILES 50
MAXLOGMEMBERS 3
MAXLOGHISTORY 400
MAXDATAFILES 200
MAXINSTANCES 6
ARCHIVELOG;
onda prati uputstva sa:
http://download-west.oracle.co...er.920/a96521/control.htm#4532