Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: [ora10] Cloning database, Unknown command 'DATAFILE'

Re: [ora10] Cloning database, Unknown command 'DATAFILE'

From: gazzag <gareth_at_jamms.org>
Date: 12 Dec 2006 06:57:17 -0800
Message-ID: <1165935437.919576.34140@n67g2000cwd.googlegroups.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 Received on Tue Dec 12 2006 - 08:57:17 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US