بعدتنصيب اوراكل 11g R2 واﻻتصال عن طريق التريمنال بال sqlplus  , وعند عمل startup  لقاعده البيانات اواجه اﻻتى 

         ORA-00205: error in identifying control file, check alert log for more info 

وبعد فحص alert log file اواجه اﻻتى 

                                   ORA-00210: cannot open the specified control file
  'ORA-00202: control file: '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/ora_control
                                             ORA-27037: unable to obtain file status

 ارجو المساعده من اصحاب الخبره فى هذا المجال الشيق , وللتوضح بشكل افضل قمت برفع alert log file

تم تعديل 8 يوليو 201312 سنة بواسطة soft3a6ala

أسهل طريقة لو عندك اكتر من control file ... اعمل shu immediate .. بس المهم ماتعملش shu abort .... وبعدين اعمل كوبي للـ control file التاني إللي المفروض يكون سليم ... وحطه في مكان البايظ وسميه باسم البايظ طبعا ... وافتح الـ Database

السلام عليكم

 

اتفضل اطلع على اللينك دا

 

http://www.in-oracle.com/Oracle-DBA/ora/ORA-00210.php

ﻻ يوجد اى ملف فى المسار المشار اليه 

يمكنك استخدام  RMAN

هذه هى الملفات الموجوده فى المسار المشار اليه عن طريق هذا اﻻمر  ls -a

hc_orcl.dat init.ora~ initorcl.ora~ lkorcl spfileORCL.ora~
.. init.ora initorcl.ora initORCL.ora~ lkORCL .spfileORCL.ora.swp

ﻻيوجد اى ملف يدعى ora_control

 please help this issue will make me crazy this contents alert log file 

Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options.
Using parameter settings in server-side pfile /u01/app/oracle/product/11.2.0/dbhome_1/dbs/initorcl.ora
System parameters with non-default values:
                                                                        processes= 150 
                                                                    memory_target= 1G
            "control_files= "/u01/app/oracle/product/11.2.0/dbhome_1/dbs/ora_control1
           "control_files= "/u01/app/oracle/product/11.2.0/dbhome_1/dbs/ora_control2
                                                                 db_block_size= 8192 
                                                                "compatible= "11.2.0
                         "db_recovery_file_dest="/u01/app/oracle/flash_recovery_area
                                                      db_recovery_file_dest_size= 2G 
                                                         "undo_tablespace= "UNDOTBS1
                                               "remote_login_passwordfile= "EXCLUSI
                                                                       ""=db_domain
                                     "(dispatchers="(PROTOCOL=TCP) (SERVICE=ORCLXDB
                                                 "audit_file_dest= "/u01/app/oracle
                                                                  "audit_trail= "DB
                                                                     "db_name="orcl
                                                                  open_cursors= 300
                                                 "diagnostic_dest= "/u01/app/oracle 

 

تم تعديل 8 يوليو 201312 سنة بواسطة soft3a6ala

 

?where are who have experience 

?i'm amazing ,where are dba here 

 

sir, do u have single or multi controlfiles in this database ???

 

if there are two as it's appeared above "ora_control1" and "ora_control2" ... then simply

1- SQL> shu immediate;

2- rename the corrupted one ... for example ora_control.old

3- copy the good one to the place where the corrupted one

4- rename the good copy to be the same as the currupted one

5- SQL> startup;

تم تعديل 10 يوليو 201312 سنة بواسطة mk_araboug

sir, do u have single or multi controlfiles in this database ???

 

if there are two as it's appeared above "ora_control1" and "ora_control2" ... then simply

1- SQL> shu immediate;

2- rename the corrupted one ... for example ora_control.old

3- copy the good one to the place where the corrupted one

4- rename the good copy to be the same as the currupted one

5- SQL> startup;

firstly thank you for effort with me , but those file that called ora_control1 and ora_control2 not exist in this path which pointed it inside  the alert log file 

 

hope:really if  can you connect to my device remotely and fix this error , that  of my pleasure

تم تعديل 10 يوليو 201312 سنة بواسطة soft3a6ala