5 Methods To Fix ORA-00205: Error In Identifying Control File

5 Methods To Fix ORA-00205: Error In Identifying Control File

Overview:

Facing error messages meanwhile working with the Oracle database is very disturbing as it breaks the flow of your work. Isn’t it…?

Our today’s article is also about one such annoying Oracle ORA-00205: error in identifying control file and it’s possible fixes.

Oracle is free, open business management software available for both personal and commercial use. The RDMS equipped system helps users to process credit card payments, handles customer, support, and manages customer orders.

Oracle, networking software does the task of data exchange between machines using underlying services to establish communication between the components. During data exchange there may be few errors in Oracle due to which database errors could evolve and connection may not be well established.

What Causes ORA-00205 Error?

ORA-00205 is one such error which arises due to dislocation of a control file or might have allocated in some wrong location.

Oracle database contains control file; it’s a small binary file that keeps record of the database physical structure. The control file includes:

  • The database name
  • Names and locations of associated data files and redo log files
  • The timestamp of the database creation
  • The current log sequence number
  • Checkpoint information

Whenever the database is open, the control file must be available for writing by the Oracle database. If the control file cannot be accessed or it is missing, the database cannot be mounted and the recovery of the database becomes very difficult. The creation of the control file is at the same time when the database is created.

On some Operating systems, at least one copy of the control file is created during the creation of the database and on some OS multiple files are created. You should always create two or more copies of the control file during database creation or later also you could change particular setting in the control files.

The system is not able to find a control file of the specified name and size that is required to execute the same. This may be due to data corruption or some hardware/software issue that makes the access of the file impossible.

How To Fix ORA-00205: Error In Identifying Control File, Check Alert Log For More Info?

Fix 1# Check For All Your Control Files

Check all control files whether they are available online or not. Also ensure that these are the same files that the system created at cold start time.

Close your database if it is already opened.

Create pfile from spfile by using command:

SQL> create pfile from spfile;

In directory $ORACLE_HOME\database a newly created pfile is present. (Its name is init<SID>.ora)

Edit this pfile to correct control file locations. Then follow this command:

SQL> create spfile from pfile;

After that, you will be able to see control files. Also if you have changed data file locations; you can rename data files in mount mode.

However if you have lost only one of many control files, then the repair procedure is different.  Having at least two control file (normally three) is recommended.

So, that if you need to identify the surviving control files in that case just replaces the missing one with one of the others.

Fix 2# Provide Filenames For The Control Files

Specify control file name using CONTROL_FILES initialization parameter in the database initialization parameter file.

If you do not specify files for CONTROL_FILES before database creation, then following things will happen:

  • operating system specific default name is taken
  • Using Oracle-managed files, then the initialization parameters you set is to enable name and location of the control files
  • Using Automatic Storage Management, incomplete ASM filenames could be placed in the DB_CREATE_FILE_DESTand DB_RECOVERY_FILE_DEST initialization parameters.

Fix 3# Multiplex Control Files On Different Disks

Two control files should be taken for every Oracle Database and should be stored on a different physical disk. If anyhow a control file is damaged (say due to a disk failure) the associated instance must be shut down possibly soon. When the drive has been repaired the damaged control file can be restored using the copy made on the other disk and can be restarted. Thus, no media recovery is required in this case.

Fix 4# Manage The Size Of Control Files

A control file size is the value set for the MAXDATAFILESMAXLOGFILESMAXLOGMEMBERSMAXLOGHISTORY, and MAXINSTANCES parameters in the CREATE DATABASE statement that created the associated database. If values of these parameters is increased the size of control file increases

If your control files are missing from your database then you will not be able to start your database. At last you will start getting ORA-00205: error in identifying control file, check alert log for more info.

[Automated Solution] To Fix ORA-00205: Error In Identifying Control File, Check Alert Log For More Info

If the above manual fixes won’t help you to fix ORA-00205: error in identifying control file then immediately go with the experts recommended option i .e Oracle File Repair Tool. As this tool efficiently fixes all kinds of Oracle database errors  and issues.

  • This tool successfully repairs and recover damaged/corrupted/lost database DBF file.
  • You can also recovers your lost clusters, views, table space, tables, triggers, roles, index, schema, synonyms, and sequence and cluster tables etc.
  • It shows preview of all recoverable Oracle database objects before making the recovery.
  • It recover all the queries of the procedures, triggers, views, package body, package, functions, and database links within the text files.
  • The software is well compatible with  almost every versions of Windows OS like Windows 10/ 8.1/ 8/ 7.

Steps To Use  Oracle File Repair tool

Step 1: Open Oracle data recovery tool. You’ll see a pop-up window showing options to select or search corrupt Oracle databases in your computer.1

Step 2: Hit Scan File to initiate the scan process after selecting the oracle database. The recoverable database objects get listed in left-side pane.

2

Step 3: Click an object to see its preview.

3

Step 4:  Click Start Repair in the icon bar to start the repair process. A pop-up window is displayed which show the steps needed to perform further. Click next and continue.

4

Step 5: Give the user name, password and path of the blank database where you want to save the repaired database objects.
5
Step 6: Repairing and restoring various database objects after establishing a connection with blank oracle database.
6

Wrap Up:

At last I want to conclude that always keep backup of your control files even if you have successfully overcome this Oracle error ORA00205.

As, it is very important whenever the physical structure of the database is changed. Structural changes could be adding, dropping, or renaming datafiles/tablespace/groups/redo files as applicable to each.

Don’t forget to share your opinion regarding this post in the comment section…..!