Discussions
Categories
- 196.7K All Categories
- 2.2K Data
- 235 Big Data Appliance
- 1.9K Data Science
- 449.8K Databases
- 221.5K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 549 MySQL Community Space
- 477 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3K ORDS, SODA & JSON in the Database
- 532 SQLcl
- 4K SQL Developer Data Modeler
- 186.8K SQL & PL/SQL
- 21.2K SQL Developer
- 295.3K Development
- 17 Developer Projects
- 138 Programming Languages
- 292K Development Tools
- 104 DevOps
- 3.1K QA/Testing
- 645.9K Java
- 27 Java Learning Subscription
- 37K Database Connectivity
- 153 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.1K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 17 Java Essentials
- 158 Java 8 Questions
- 85.9K Java Programming
- 79 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.2K Java SE
- 13.8K Java Security
- 203 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 390 LiveLabs
- 37 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.6K Other Languages
- 2.3K Chinese
- 170 Deutsche Oracle Community
- 1K Español
- 1.9K Japanese
- 230 Portuguese
control file issue in oracle installed on Redhat Machine.

Hello,
I got following error while shutting down the database
SQL> SHUTDOWN IMMEDIATE
ORA-00210: cannot open the specified control file
ORA-00202: control file: '/home/core/Databases/ControlFile/ctl2.dat'
ORA-27041: unable to open file
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
when I check for control file i could not found that control file may be deleted by mistake.
Is there any way to recover control file?
Answers
-
You can recover the controlfile from one of the following:
an rman backup
a mulriplexed copy of the controlfile...was this the only copy of the controlfile?
from a trace file if you had previously executed a backup controlfile to trace.
Or create the controlfile using the create controlfile command.
-
"May" be deleted by mistake?
This is why oracle strongly recommends that control files (and redo log files) be multiplexed.
If yours are multiplexed, all you have to do is copy one of the surviving copies back to the name/location of the lost copy.
If not, we have a more complex problem.
-
I've seen an admin perform unconditional removes of any directories that exactly matched the word "core", no matter where on the server, no matter who owned it. Maybe that is what happened here ... "core" is a weird name for an account though.
-
And I've had SAs remove my online redo logs because they were named '*.log'.
Which is why, in addition to multiplexing, I don't name them '*.log' any more. Prior to 10g, their default name was *.rdo. After getting bit, I've reverted back to that naming, so as to not tempt an SA.
fortunately, because I *was* multiplexed, it was more an annoyance than a business critical issue.
I guess I should have put more emphasis on "MAY". The OP needs to be finding out for sure how this happened. No "may" about it.
-
find another control file.
Place it '/home/core/Databases/ControlFile/' here
and rename it as 'ctl2.dat'
Hope you have multiplexed control file available.
check with 'show parameter control' if you really don't know control file locations.
HTH
B Dave
-
Mine was not multiplexed.
Is there another way or I have to re Install Oracle database software again?
-
You're gonna have to re-create the control file, with NORESETLOGS. A simple google search will get you all the information you need. You will need to acquire the correct db_name, location of logfiles and datafiles, and characterset for this operation. For the future, use control file auto backups, multiplexing and periodically do a trace of the control file to avoid this happening.
Have a read:
http://docs.oracle.com/cd/B28359_01/server.111/b28286/statements_5003.htm#SQLRF53762
-
7144389e-3944-4d5c-830e-46539d2d9971 wrote: Mine was not multiplexed. Is there another way or I have to re Install Oracle database software again?
Reinstalling the software has nothing to do with a database control file. What you ask is like deleting an Excel spreadsheet, then asking if you can recover it by re-installing Microsoft Office.
The software is not the database and the database is not the software. The control file is part of a database.
-
Definately, besides solving the issue of getting this solved, it's needed to know why that happens, as file being deleted is not a good thing. I'm seeing a database file in what looks like a Home directory ... I don't think the Home directory should contain parts of a database. But, it may also not actually be a Home structure, just looks like one.
I also don't understand why the redo files are named .log, since it is generally accepted that .log files are text-files which are normally not necessary for running processes. The redos actually are totally different, extremely different even, on all levels, in that context. It doesn't surprise me at all that some day, some OS admin, or a non-experienced DBA would remove these files, thinking there are just text logs ... RDO seems like a perfect naming. Litterally though, they are logs, in the way they log things, in a serial manner ...
-
I think he or she means that although you technically can remove the instance only and re-use the database software, the process used to setup a database and instance is one complete procedure which ... sets up database and instance