Originally posted by sudip
Use the migration utility provided by Oracle to do the migration. Please refer to the migration manual for details. But don't forget to take a cold backup of the oracle7 database before migraion.

Migration utility will create the control file for you when you invoke the following command

alter database convert;

Regards

The steps followed.. and Errors.


Echo ON
SVRMGR> spool recrctrl.log
MGR-03512: spool file "log.log" is already open
SVRMGR> connect internal/oracle;
Connected.
SVRMGR> shutdown normal;
ORA-01034: ORACLE not available
SVRMGR> startup nomount pfile=D:\DEMO\init.ora;
ORACLE instance started.
Total System Global Area 119160780 bytes
Fixed Size 65484 bytes
Variable Size 55508992 bytes
Database Buffers 63512576 bytes
Redo Buffers 73728 bytes
SVRMGR> create controlfile reuse
2> set database DEMO
3> logfile 'D:\DEMO\log1.dbf' size 10M,
4> 'D:\DEMO\log2.dbf' size 10M,
5> 'D:\DEMO\log3.dbf' resetlogs
6> datafile 'D:\DEMO\system1.dbf',
7> 'D:\DEMO\system2.dbf',
8> 'D:\DEMO\system3.dbf',
9> 'D:\DEMO\temp.dbf',
10> 'D:\DEMO\data1.dbf',
11> 'D:\DEMO\data2.dbf',
12> 'D:\DEMO\data3.dbf',
13> 'D:\DEMO\index1.dbf',
14> 'D:\DEMO\index2.dbf',
15> 'D:\DEMO\office.dbf',
16> 'D:\DEMO\rbs.dbf';
create controlfile reuse
*
ORA-01503: CREATE CONTROLFILE failed
ORA-01210: data file header is media corrupt
ORA-01110: data file : 'D:\DEMO\system1.dbf'
SVRMGR>
SVRMGR> ALTER DATABASE OPEN RESETLOGS;
ALTER DATABASE OPEN RESETLOGS
*
ORA-01507: database not mounted
SVRMGR>
SVRMGR> spool off

http://education.oracle.com/certific...f/dba8i_cg.pdf

SVRMGR> alter database convert;
alter database convert
*
ORA-00404: Convert file not found: '%ORACLE_HOME%\RDBMS\CONVERT.ORA'
ORA-27047: unable to read the header block of file
OSD-04006: ReadFile() failure, unable to read from file
O/S-Error: (OS 38) Reached end of file.
SVRMGR> spool off


[email protected]