10 Replies Latest reply on Apr 15, 2011 2:04 AM by EdStevens

    ORA-00205: error in identifying control file

    855496
      Dear all,

      I am running into this error when I execute startup:

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

      the last few lines from my alertSID.log is the following:

      MMNL started with pid=11, OS id=3758
      Fri Apr 15 08:21:24 2011
      ALTER DATABASE MOUNT
      Fri Apr 15 08:21:24 2011
      ORA-00202: control file: '/home/oracle/oracle/product/10.2.0/db_1/ora_control1
      ORA-27037: unable to obtain file status
      Linux-x86_64 Error: 2: No such file or directory
      Additional information: 3
      Fri Apr 15 08:21:24 2011
      ORA-205 signalled during: ALTER DATABASE MOUNT...

      to be very honest, my control files are not there and I do not understand why.
      when i do "show parameter control_files", it shows the following value:
      /home/oracle/oracle/product/10.2.0/db_1/dbs/ora_control1, /home/oracle/oracle/product/10.2.0/db_1/dbs/ora_control2

      but the files "ora_control1" and "ora_control2" are not there. I am very new to all these and I am still learning along the way. I seek your patience and understanding and I hope someone can guide me in getting my oracle db up and running error free.
        • 1. Re: ORA-00205: error in identifying control file
          LKBrwn_DBA
          control file: '/home/oracle/oracle/product/10.2.0/db_1/ora_control1 DOES NOT EXIST!
          DUH!
          :p
          • 2. Re: ORA-00205: error in identifying control file
            855496
            Yes, I know it doesn't exist but I do not understand why or where I had gone wrong. I am hoping someone can guide me on how I can correct this.
            • 3. Re: ORA-00205: error in identifying control file
              EdStevens
              852493 wrote:
              Yes, I know it doesn't exist but I do not understand why or where I had gone wrong. I am hoping someone can guide me on how I can correct this.
              No one here can know what happened to the file. They don't just go away, and they are so important that you can be sure oracle did not delete it.

              Your init parm lists 2 control files. Is only one of them missing? If so copy the existing file to the name/location of the missing file then startup
              • 4. Re: ORA-00205: error in identifying control file
                855496
                In my /home/oracle/oracle/product/10.2.0/db_1/dbs/ folder, I only see the following files:
                hc_orcl.dat
                initdw.ora
                init.ora
                lkDEFAULT

                and my db SID is orcl.
                • 5. Re: ORA-00205: error in identifying control file
                  sb92075
                  bcm@bcm-laptop:~$ ls -ltr $OH/dbs
                  total 9708
                  -rw-r--r-- 1 oracle dba    2851 2009-05-15 14:35 init.ora
                  -rw-r----- 1 oracle dba      24 2010-05-07 11:17 lkV112
                  -rw-r----- 1 oracle dba 9912320 2010-05-20 18:33 snapcf_v112.f
                  -rw-rw---- 1 oracle dba    1544 2010-06-09 08:31 hc_DBUA0.dat
                  -rw-r--r-- 1 oracle dba    1026 2011-01-11 10:27 initv112.ora
                  -rw-r----- 1 oracle dba    2048 2011-03-12 12:03 orapwv112
                  -rw-r----- 1 oracle dba    3584 2011-04-14 06:25 spfilev112.ora
                  -rw-rw---- 1 oracle dba    1544 2011-04-14 06:25 hc_v112.dat
                  where ORACLE_SID=v112
                  It appears you are missing some usual files from "dbs" folder
                  • 6. Re: ORA-00205: error in identifying control file
                    EdStevens
                    852493 wrote:
                    In my /home/oracle/oracle/product/10.2.0/db_1/dbs/ folder, I only see the following files:
                    hc_orcl.dat
                    initdw.ora
                    init.ora
                    lkDEFAULT

                    and my db SID is orcl.
                    you said:
                    when i do "show parameter control_files", it shows the following value:
                    /home/oracle/oracle/product/10.2.0/db_1/dbs/ora_control1, /home/oracle/oracle/product/10.2.0/db_1/dbs/ora_control2
                    so at one point (assumeing this db ever worked) you had two copies of the control file. Unfortunately, they were both in the same directory, so you had little to no protection against accidental deletion.

                    What do you have in the way of backups?
                    • 7. Re: ORA-00205: error in identifying control file
                      855496
                      Unfortunately, there are no backups. I am taking over this db from someone who did not implement it.
                      • 8. Re: ORA-00205: error in identifying control file
                        sb92075
                        below works for me
                        STARTUP NOMOUNT
                        CREATE CONTROLFILE REUSE DATABASE "V112" NORESETLOGS  NOARCHIVELOG
                            MAXLOGFILES 16
                            MAXLOGMEMBERS 3
                            MAXDATAFILES 100
                            MAXINSTANCES 8
                            MAXLOGHISTORY 292
                        LOGFILE
                          GROUP 1 '/u01/app/oracle/oradata/v112/redo01.log'  SIZE 50M BLOCKSIZE 512,
                          GROUP 2 '/u01/app/oracle/oradata/v112/redo02.log'  SIZE 50M BLOCKSIZE 512,
                          GROUP 3 '/u01/app/oracle/oradata/v112/redo03.log'  SIZE 50M BLOCKSIZE 512
                        -- STANDBY LOGFILE
                        DATAFILE
                          '/u01/app/oracle/oradata/v112/system01.dbf',
                          '/u01/app/oracle/oradata/v112/sysaux01.dbf',
                          '/u01/app/oracle/oradata/v112/undotbs01.dbf',
                          '/u01/app/oracle/oradata/v112/users01.dbf',
                          '/u01/app/oracle/oradata/v112/example01.dbf'
                        CHARACTER SET AL32UTF8
                        ;
                        -- Commands to re-create incarnation table
                        -- Below log names MUST be changed to existing filenames on
                        -- disk. Any one log file from each branch can be used to
                        -- re-create incarnation records.
                        -- ALTER DATABASE REGISTER LOGFILE '/u01/app/oracle/flash_recovery_area/V112/archivelog/2010_12_17/o1_mf_1_1_%u_.arc';
                        -- ALTER DATABASE REGISTER LOGFILE '/u01/app/oracle/flash_recovery_area/V112/archivelog/2010_12_17/o1_mf_1_1_%u_.arc';
                        -- Recovery is required if any of the datafiles are restored backups,
                        -- or if the last shutdown was not normal or immediate.
                        RECOVER DATABASE
                        -- Database can now be opened normally.
                        ALTER DATABASE OPEN;
                        -- Commands to add tempfiles to temporary tablespaces.
                        -- Online tempfiles have complete space information.
                        -- Other tempfiles may require adjustment.
                        ALTER TABLESPACE TEMP ADD TEMPFILE '/u01/app/oracle/oradata/v112/temp01.dbf'
                             SIZE 39845888  REUSE AUTOEXTEND ON NEXT 655360  MAXSIZE 32767M;
                        -- End of tempfile additions.
                        • 9. Re: ORA-00205: error in identifying control file
                          791413
                          Hi,

                          show parameter is showing the controlfile location reading from your init parameter file.
                          But the controlfiles are probably accidently deleted from someone from the actual location.

                          Regards
                          Sumit.
                          • 10. Re: ORA-00205: error in identifying control file
                            EdStevens
                            852493 wrote:
                            Unfortunately, there are no backups. I am taking over this db from someone who did not implement it.
                            Bummer.

                            Before doing anything else, backup all of the existing spfiles, data files. Then you might find some help here:
                            http://myracle.wordpress.com/2008/01/11/recover-database-without-control-files-and-redo-log-files/