Path: text.usenetserver.com!out04a.usenetserver.com!news.usenetserver.com!in02.usenetserver.com!news.usenetserver.com!postnews.google.com!n67g2000cwd.googlegroups.com!not-for-mail
From: "gazzag" <gareth@jamms.org>
Newsgroups: comp.databases.oracle.server
Subject: Re: [ora10] Cloning database, Unknown command 'DATAFILE'
Date: 12 Dec 2006 06:57:17 -0800
Organization: http://groups.google.com
Lines: 48
Message-ID: <1165935437.919576.34140@n67g2000cwd.googlegroups.com>
References: <4u7khrF1743hbU1@mid.individual.net>
   <1165930011.316853.37700@n67g2000cwd.googlegroups.com>
   <4u7u2gF16h83eU1@mid.individual.net>
NNTP-Posting-Host: 193.130.12.157
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
X-Trace: posting.google.com 1165935445 19080 127.0.0.1 (12 Dec 2006 14:57:25 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Tue, 12 Dec 2006 14:57:25 +0000 (UTC)
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),gzip(gfe),gzip(gfe)
Complaints-To: groups-abuse@google.com
Injection-Info: n67g2000cwd.googlegroups.com; posting-host=193.130.12.157;
   posting-account=zujbXgsAAAA8hne0tKRbNp7NAGtNgEwN
Xref: usenetserver.com comp.databases.oracle.server:419002
X-Received-Date: Tue, 12 Dec 2006 09:57:25 EST (text.usenetserver.com)

Helmut Schneider wrote:
> STARTUP NOMOUNT
> CREATE CONTROLFILE REUSE DATABASE "ORCL" RESETLOGS  NOARCHIVELOG
>     MAXLOGFILES 16
>     MAXLOGMEMBERS 3
>     MAXDATAFILES 100
>     MAXINSTANCES 8
>     MAXLOGHISTORY 292
> LOGFILE
>   GROUP 1 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO01.LOG'  SIZE 50M,
>   GROUP 2 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO02.LOG'  SIZE 50M,
>   GROUP 3 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO03.LOG'  SIZE 50M
>
> DATAFILE
>   'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\SYSTEM01.DBF',
>   'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\UNDOTBS01.DBF',
>   'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\SYSAUX01.DBF',
>   'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\USERS01.DBF',
>   'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\EXAMPLE01.DBF'
> CHARACTER SET WE8MSWIN1252
> ;
>
> RECOVER DATABASE USING BACKUP CONTROLFILE
>
> ALTER DATABASE OPEN RESETLOGS;
>
> ALTER TABLESPACE TEMP ADD TEMPFILE
> 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\TEMP01.DBF'
>      SIZE 20971520  REUSE AUTOEXTEND ON NEXT 655360  MAXSIZE 32767M;
>
> This is the original without comments (each line beginning with "--"). I
> changed REUSE to SET for the first CREATE statement and removed the RECOVER
> DATABASE and the ALTER DATABASE OPEN statement.
>
> Thanks, Helmut

You have a blank line in your CREATE DATABASE statement.  Namely, get
rid of the blank line between these two lines:

GROUP 3 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO03.LOG'  SIZE 50M
 
DATAFILE


HTH

--g