|
-
i copy all the 8i datafile, controlfile, logs and put in one directory /u02/oradata/DCTEST/ on my 11gr1 server. but in this file i don't see the *.ctl file mention atall.
this is my reconfigure sqlfile : DCTEST_cr_control.sql
STARTUP NOMOUNT
CREATE CONTROLFILE SET DATABASE "DCTEST" RESETLOGS ARCHIVELOG
MAXLOGFILES 32
MAXLOGMEMBERS 2
MAXDATAFILES 254
MAXINSTANCES 8
MAXLOGHISTORY 907
LOGFILE
GROUP 1 '/u02/oradata/DCTEST/redo01.log' SIZE 4M,
GROUP 2 '/u02/oradata/DCTEST/redo02.log' SIZE 4M,
GROUP 3 '/u02/oradata/DCTEST/redo03.log' SIZE 4M
DATAFILE
'/u02/oradata/DCTEST/system01.dbf',
'/u02/oradata/DCTEST/tools01.dbf',
'/u02/oradata/DCTEST/rbs01.dbf',
'/u02/oradata/DCTEST/temp01.dbf',
'/u02/oradata/DCTEST/eqndxs01.dbf',
'/u02/oradata/DCTEST/drsys01.dbf',
'/u02/oradata/DCTEST/eqdata01.dbf',
'/u02/oradata/DCTEST/CATTBS_1.dbf'
CHARACTER SET US7ASCII
;
Why does this sql file not work in 11g?
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|