A tough situation..
I have a db instance just created and was up and running.
oracle 8i, no archive log and no backup yet..
one of the QA guys accidentally ran a create database script..
and i guess messed up a few things..
after doing a shutdown abort, i cant even bring the databse to mount stage.. Is the db a big trash already?? Any chances..
ORA-00205: error in identifying controlfile, check alert log for more info...
What can be done..Any clues??
Check your init.ora file to make sure the control_files paramter is pointing to one of the correct control files. If the control file was toasted, you will have to do an incomplete recovery and re-create your control files.
It is a toast Jeff..
I check the location of control files and wow..
They dont exist...
I cannot even come to mount stage if I have to do incomplete recovery or even creating a controlfile..
So, what's next??
Continuation to the above scenario::
The user ran the database script and when the problem occured he promptly deleted the control files manually and reran the script.. so i guess nothing can be done..
1. startup nomount
2. issue create controlfile command (http://technet.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/a85397/statem4b.htm#2061202)
3. shutdown immediate
4. startup mount
5. alter database recover until cancel using backup controlfile
6. alter database recover cancel
7. alter database open resetlogs
Jeff and sreddy:
Please check the syntax underneath..
tried creating a controlfile and it errors out when i did not mention the datafile name (system.dbf)..
But when i included system.dbf again it errored out..
where am i doing wrong??
The logfile destination, i copied exactly from our create database script so that i will not make a mistake..
create controlfile reuse
logfile group 1 '/u02/oradata/nbs/redo01.log' size 5120k,
group 2 '/u02/oradata/nbs/redo02.log' size 5120k,
group 3 '/u02/oradata/nbs/redo03.log' size 5120k
datafile '/u01/oradata/nbs/system.dbf' size 500M
character set WE8ISO8859P1;
create controlfile reuse
ORA-01503: CREATE CONTROLFILE failed
ORA-01565: error in identifying file '/u01/oradata/nbs/system.dbf'
ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory
Additional information: 3
Here you see my production 734 version controlfile backed up to trace. Is system file is the only one you have in the database ? do you have other files too..... you have to include all the files of database.
Thanks for the links sreddy..
It is very clear in metalink(with syntax)..
let me ask you, once i create the control file and run it through as per the one in metalink, i dont have to follow the remaining steps of what jeff mentioned right... such as 4 to 7, coz the end of control file script includes alter db open..
once the db is open, i am in shape, right..
Am i making sense?? If not, please let me know..
Ps: The logfiles and datafiles might be having an SCN and when new control file gets created how will it share the new number.. when i dont go with resetlogs..