manual clone of database

Hi

I am trying to manually clone a database, but also renaming the database.

On the source system, I issue an 'ALTER DATABASE BACKUP CONTROLFILE TO TRACE' and then copy the trace file from this and all datafiles to the target system. I edit the output from the trace file, replacing file paths and database names where appropriate.

On the destination system, the database already exists. It is shutdown and all data files and redo-logs over-written and some new tablespaces added in the data directory. I place the init[SID].ora file and then I issue the CREATE CONTROLFILE command from the trace file. I am told that the controlfile is created. I have tried this with ARCHIVELOG and NOARCHIVELOG and with SET DATABASE to create new controlfiles.

But, when I try the next step,
SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01194: file 1 needs more recovery to be consistent ORA-01110: data file 1: '/u02/oradata/P1THUR/system01.dbf'

OK, so I try to recover ...

SQL> recover database using backup controlfile; ORA-00279: change 11276017 generated at 04/04/2007 12:05:45 needed for thread 1
ORA-00289: suggestion : /u02/orabackup/P1THUR/ archive1_702_611010067.dbf
ORA-00280: change 11276017 for thread 1 is in sequence #702

Specify log: {<RET>=suggested | filename | AUTO | CANCEL} AUTO
ORA-00308: cannot open archived log
'/u02/orabackup/P1THUR/archive1_702_611010067.dbf' ORA-27037: unable to obtain file status
IBM AIX RISC System/6000 Error: 2: No such file or directory Additional information: 3

I try CANCEL as well but this won't recover to the point when I can start the database. I also try to revover that problem datafile '/u02/ oradata/P1THUR/system01.dbf'.

Please - anyone got any better ideas or references on this. I have done this before successfully albeit without a database rename. I didn't copy any archived logs over so I don't understand why it is asking for that /u02/orabackup/P1THUR/archive1_702_611010067.dbf file. It doesn't exist on the source or destination system.

I'd be grateful for any insights !

Thanks

Chris Received on Thu Apr 05 2007 - 08:56:26 CDT