hi,
i am trying to make it up in Oracle 7.3 Oracle Financials data base to 8i
i am created instence demo in Oracle 8i and i am trying to re create the controlfile and i want's to make up..
in oracle 8i
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
Can any one Help me
