On Apr 5, 4:20 pm, "chris.faulk..._at_gmail.com"
<chris.faulk..._at_gmail.com> wrote:
> On Apr 5, 3:12 pm, "sybrandb" <sybra..._at_gmail.com> wrote:
>
>
>
>
>
> > 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
>
> Sounds great - sorry to be so dumb but how do I specify one of the
> online redologs "as source" ? What does that last part mean. Please
> bear with me !
>
> Chris- Hide quoted text -
>
> - Show quoted text -
When you are prompted (see above) to specify a filename, or auto or
cancel, you specify the name of the redolog you found by selecting
from v$log and v$logfile.
You have both the SCN (11276017) and the sequence# column (702), so
you should be able to identify the file.
The name you see in the prompt, is the name Oracle would give the file
after archiving.
--
Sybrand Bakker
Senior Oracle DBA
Received on Thu Apr 05 2007 - 09:44:57 CDT
