DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

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

  1. #1
    Join Date
    May 2001
    Posts
    41
    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



  2. #2
    Join Date
    Feb 2001
    Location
    Kolkata- India
    Posts
    356

    Smile

    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

    There Nothing You cannot Do, The problem is HOW.

  3. #3
    Join Date
    May 2001
    Posts
    41
    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

  4. #4
    Join Date
    Feb 2001
    Location
    Kolkata- India
    Posts
    356
    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
    There Nothing You cannot Do, The problem is HOW.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width