The database instance is currently using SPFILE. View the Exhibit and examine the error that you received while running the DB Structure Integrity check.
Given below are the steps to recover from the error in random order:
1. Shut down the instance, if not already done.
2. Copy one of the remaining control files to a new location.
3. Change the value of the CONTROL_FILES initialization parameter to correspond to the new location of the control files.
4. Start up the database instance to the NOMOUNT stage.
5. Recover the database to the point of failure of the control file.
6. Open the database.
Identify the correct sequence of steps?
A.
1, 2, 4, 3, 5, 6
B.
2, 4, 3, 5, 6; 1 not required
C.
4, 5, 6, 2, 3; 1 not required
D.
5, 2, 3, 4; 1 and 6 not required
i type the error message in case you need it:
ora-00210: cannot open the specified control file
ora-00202: controlfile: ‘D:Oracleoradatachencontrol01.ctl’
ora-27041: unable to open file, Linux error: no such file or directory.
Additional information: ora-06512: at “SYS.DBMS_HM”. line 191
Hi, what is meant by stop 3. Change the value of the CONTROL_FILES initialization parameter to correspond to the new location of the control files?
I have a 12c DB. When I type SQL> SHOW PARAMETER control_files
I get
NAME TYPE VALUE
———————————— ———– ——————————
control_files string C:\APP\ORACLE\ORADATA\EE8\CONT
ROLFILE\O1_MF_B3HK360O_.CTL, C
:\APP\ORACLE\FAST_RECOVERY_ARE
A\EE8\CONTROLFILE\O1_MF_B3HK36
61_.CTL
SQL>
How to change this value???
I say ALTER SYSTEM SET control_files=c:\app\oracle\oradata\ee8\controlfile\mynewfile.ctl;
Also, what why should you do step 5? i.e. 5. Recover the database to the point of failure of the control file.
What is there to recover? We are are talking only about the control files, not data files, right?
If we have to do it, what is the procedure?
Step 3 should append “restart instance” because control_files is a static parameter!
Hello i agree with Rohan de Silva, why we need to perform step 5 ?
Can someone explain please ?
you’re truly a excellent webmaster. The web site loading pace is amazing.
It kind of feels that you’re doing any distinctive trick.
Moreover, The contents are masterwork. you’ve performed a fantastic job on this matter!
real madrid trøje
Usually I do not read article on blogs, but I
wish to say that this write-up very compelled me
to take a look at and do so! Your writing taste has been amazed me.
Thank you, very nice post.
chelsea matchtröja
My brother recommended I may like this web site.
He used to be entirely right. This submit truly made my day.
You can not imagine simply how much time I had spent for this info!
Thanks!
liverpool kläder