oracle STARTUP problem.

[sivakumar_dba]

can any one help me ....
i have two database, one is 192.168.10.12 and another 192.168.10.03 running on different different machines, ( os is sun solaris 5.8)
For test purpose I had took hot back 192.168.10.03.
I backup .dbf
I backup .ora
i m not backup control file, becoz i wat to edit .dft and .log file location in control file.

after connecting to 192.168.10.12


$ svrmgrl

Oracle Server Manager Release 3.1.7.0.0 - Production

Copyright (c) 1997, 1999, Oracle Corporation. All Rights Reserved.

Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
With the Partitioning option
JServer Release 8.1.7.0.0 - Production

SVRMGR> connect internal
Connected.
SVRMGR> startup nomount pfile = /oracle/initkesd.ora
ORACLE instance started.
Total System Global Area 183460000 bytes
Fixed Size 73888 bytes
Variable Size 81428480 bytes
Database Buffers 101777408 bytes
Redo Buffers 180224 bytes
SVRMGR>CREATE CONTROLFILE REUSE DATABASE "KESDEE" NORESETLOGS ARCHIVELOG
MAXLOGFILES 32
MAXLOGMEMBERS 2
MAXDATAFILES 254
MAXINSTANCES 8
MAXLOGHISTORY 3619
LOGFILE
GROUP 1 '/oracle/redo01.log' SIZE 500K
,
GROUP 2 '/oracle/redo02.log' SIZE 500K
,
GROUP 3 '/oracle/redo03.log' SIZE 500K
DATAFILE
'/oracle/system01.dbf',
'/oracle/tools01.dbf',
'/oracle/rbs01.dbf',
'/oracle/temp01.dbf',
'/oracle/users01.dbf',
'/oracle/indx01.dbf',
'/oracle/tms01.dbf',
'/oracle/klms01.dbf',
'/oracle/kesdee01.dbf',
'/oracle/cbt01.dbf',
'/oracle/lms01.dbf',
'/oracle/USER1.dbf'
CHARACTER SET US7ASCII
;
CREATE CONTROLFILE REUSE DATABASE "KESDEE" NORESETLOGS ARCHIVELOG
*
ORA-01503: CREATE CONTROLFILE failed
ORA-01160: file is not a data file
ORA-01110: data file : '/oracle/system01.dbf'
SVRMGR>

the above error will accured. can i know what is the cause of failing.

[davey23uk]

/oracle/system01.dbf is not a datafile - doesnt that make sense?

[sivakumar_dba]

hi sir,
I have took hot backup of all .dbf file correctly .. but still its showing same error. I don't know Y?
pls help me.

[gandolf989]

Just to make things painfully clear, if you type "ls -l /oracle/system01.dbf" Unix will return file not found. not found because that is not where the file is stored. And why would you store the system datafile in /oracle??? That makes no sense. Perhaps you would find the file in /oracle/oradata/kesdee, or /oracle/db/kesdee, or even /oradata/kesdee. Find the datafiles and make sure that the paths to all of the files are correct and recreate the control files again.

[hrishy]

Hi

I would advise you to hire a DBA.

regards
Hrishy

[Ravi_2008]

what you are trying to achieve? Why do you want to edit the .dbf file?

What is the present status??

[PAVB]

what you are trying to achieve? Why do you want to edit the .dbf file?

Who's trying to edit what? May I ask where did you find that piece of information?
Poster is already confused to dead and you come out of the blue with such implicit statement, why?

[Ravi_2008]

For test purpose I had took hot back 192.168.10.03.
I backup .dbf
I backup .ora
i m not backup control file, becoz i wat to edit .dft and .log file location in control file.

In the above it was mentioned to edit .dft Or its .dbf.

[PAVB]

got it... you can't read English. Good luck.

[Ravi_2008]

Sorry .. Please correct me, if I went wrong.