-
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
-
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.
-
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
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|