Re: manual clone of database

On Apr 5, 3:56 pm, "chris.faulk..._at_gmail.com" <chris.faulk..._at_gmail.com> wrote:
> 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

I recall several situations where I ran into the same problem, and I had to specify one of the *online* redologs as source. You'll need to find out in which online redo log the SCN reported is.

hth

--
Sybrand Bakker
Senior Oracle DBA