Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: [ora10] Cloning database, Unknown command 'DATAFILE'
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