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

EdStevens (quetico_man_at_yahoo.com) wrote:
> Helmut Schneider wrote:
>> When I try to execute @D:\ctrl_old.sql I get an error:
>>
>> SP2-0042: Unknown command 'DATAFILE'.
>
> Do we get to see the contents of the file "D:\ctrl_old.sql", or do we
> have to guess?

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'

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

-- 
Please do not feed my mailbox, Swen still does his job well