Path: news.f.de.plusline.net!news-fra1.dfn.de!newsfeed.hanau.net!news.tiscali.de!tiscali!newsfeed1.ip.tiscali.net!proxad.net!64.233.160.134.MISMATCH!postnews.google.com!e65g2000hsc.googlegroups.com!not-for-mail
From: "sybrandb" <sybrandb@gmail.com>
Newsgroups: comp.databases.oracle.server
Subject: Re: manual clone of database
Date: 5 Apr 2007 07:44:57 -0700
Organization: http://groups.google.com
Lines: 96
Message-ID: <1175784297.740961.136560@e65g2000hsc.googlegroups.com>
References: <1175781386.659362.214650@y80g2000hsf.googlegroups.com>
   <1175782334.389679.256950@y80g2000hsf.googlegroups.com>
   <1175782810.974205.290680@q75g2000hsh.googlegroups.com>
NNTP-Posting-Host: 192.33.238.6
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
X-Trace: posting.google.com 1175784299 5832 127.0.0.1 (5 Apr 2007 14:44:59 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Thu, 5 Apr 2007 14:44:59 +0000 (UTC)
In-Reply-To: <1175782810.974205.290680@q75g2000hsh.googlegroups.com>
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322; .NET CLR 2.0.50727; InfoPath.1),gzip(gfe),gzip(gfe)
X-HTTP-Via: 1.1 PXYBEBR003
Complaints-To: groups-abuse@google.com
Injection-Info: e65g2000hsc.googlegroups.com; posting-host=192.33.238.6;
   posting-account=d8kqXg0AAADvDUR8IdYEU7pAZnZ1O2PC
Xref: news.f.de.plusline.net comp.databases.oracle.server:195793

On Apr 5, 4:20 pm, "chris.faulk...@gmail.com"
<chris.faulk...@gmail.com> wrote:
> On Apr 5, 3:12 pm, "sybrandb" <sybra...@gmail.com> wrote:
>
>
>
>
>
> > On Apr 5, 3:56 pm, "chris.faulk...@gmail.com"
>
> > <chris.faulk...@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