5 Ответы Последний ответ: 04.09.2019 13:57, автор: EdStevens

    ora-00205 error in identifying control file

    4055443

      Hi,

       

      When I lauched my database ORCL (alter database mount or open), the message in subject appears.

       

      I trying recreate spfile and pfile.

      The control_files are present but empty.

       

      Some informations :

      show parameters control_files;

       

      NAME                                 TYPE        VALUE

      ------------------------------------ ----------- ------------------------------

      control_files                        string      /applications/oracle/product/d

                                                       bs/ora_control1, /applications

                                                       /oracle/product/dbs/ora_contro

                                                       l2

       

       

       

      #files and rights

      [oracle@oracle dbs]$ ll /applications/oracle/product/dbs/ora_control1

      -rwxrwxr-x 1 oracle oinstall 0 21 août  11:41 /applications/oracle/product/dbs/ora_control1

      [oracle@oracle dbs]$ ll /applications/oracle/product/dbs/ora_control2

      -rwxrwxr-x 1 oracle oinstall 0 28 août  10:05 /applications/oracle/product/dbs/ora_control2

       

      # files also in fast_recovery area

      [oracle@oracle fast_recovery_area]$ ll

      total 0

      -rwxrwxr-x 1 oracle oinstall 0 21 août  11:41 ora_control1

      -rwxrwxr-x 1 oracle oinstall 0 21 août  11:41 ora_control2

      [oracle@oracle fast_recovery_area]$

       

      #extract spfileORCL concerning control_files

      *.control_files='/applications/oracle/product/dbs/ora_control1','/applications/oracle/product/dbs/ora_control2'

       

      #extract initORCL concerning control_files

      control_files ='/applications/oracle/product/dbs/ora_control1','/applications/oracle/product/dbs/ora_control2'

       

      # extract of alert_log.xml

      <txt>Errors in file /applications/oracle/product/diag/rdbms/orcl/ORCL/trace/ORCL_m000_16845.trc:

      ORA-00202: control file: &apos;/applications/oracle/product/dbs/ora_control2&apos;

      ORA-27047: unable to read the header block of file

      Linux-x86_64 Error: 25: Inappropriate ioctl for device

      Additional information: 1

      ORA-00210: cannot open the specified control file

      ORA-00202: control file: &apos;/applications/oracle/product/dbs/ora_control1&apos;

      ORA-27047: unable to read the header block of file

      Linux-x86_64 Error: 25: Inappropriate ioctl for device

       

       

       

      Thanks for your help.

        • 1. Re: ora-00205 error in identifying control file
          EdStevens

          how did your control files become "empty"?  you will have to recover from a backup.

          • 2. Re: ora-00205 error in identifying control file
            4055443

            Hi, no, the control files are created (touch ora_control1). So, the files are empty.

            No backup, no restore

            • 3. Re: ora-00205 error in identifying control file
              EdStevens

              4055443 wrote:

               

              Hi, no, the control files are created (touch ora_control1). So, the files are empty.

              No backup, no restore

              Why did you 'touch' your control files?  How do you expect a database to open and read critical information from an 'empty' control file?  If you current control files are empty, and you have no backup or 'controlfile trace', then your database is toast. Full stop.

              • 4. Re: ora-00205 error in identifying control file
                4055443
                There is absolutely nothing in the ORCL database. 
                It's the first installation.
                Suddenly, it should be deleted and recreated with the right parameters, is it? Is there any way to change it as is?

                Thanks
                • 5. Re: ora-00205 error in identifying control file
                  EdStevens

                  4055443 wrote:

                   

                  There is absolutely nothing in the ORCL database.

                  If you can't even open the database (which you can't) then you cannot know if there is anything in it or not.  So how did you determine that there is nothing in it?

                   

                   

                  It's the first installation.

                  The first installation on this particular server?  Or your first installation ever?

                   

                  Suddenly, it should be deleted and recreated with the right parameters, is it? Is there any way to change it as is?

                  I think perhaps you should back up and describe exactly what you have done.  You ignored my question about how the control files got created or why you 'touched' them.

                  What, exactly, did you install?  Database version (in decimal form, like '12.1.0.2', not the marketing lable of '12c'). 

                  Did you choose to create a database as part of the installation? Or did you use the dbca utility after completion of the installation? Explain exactly how you created the db.

                  What OS is this on?

                  What OS user were you logged on as when you installed Oracle?