Database Administration (MOSC)

MOSC Banner

Problem with control file

edited Apr 2, 2025 7:24AM in Database Administration (MOSC) 4 commentsAnswered

I had a database installed on Oracle 11.2. but due to a bad disk belonging to the asm DATA group, I deleted the group and that bad disk. I recreated the DATA disk group and added all the disks that belonged to it, but when I mount database I get an error

ALTER DATABASE MOUNT

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

When I show the existing control files I get the following

SQL> SHOW PARAMETER CONTROL_FILES;

NAME TYPE VALUE

control_files string +DATA/dbname/control01.ctl,+RECO/dbname/control02.ctl

How do I mount the database without rman backup is it possible?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center