Oracle 7.3 database currupted i want to Up/Run from 8i

[rameshgiri26]

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

[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

[rameshgiri26]

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


nrgirius@yahoo.com

[sudip]

Hi!
Did you go through the Migration utility manual? There are various steps steps to follow before you can run the
alter database convert statement.

Please use the mig utility provided by oracle to migrate 7.3 database to 8i.

cheers