Welcome Guest ( Log In | Register )


 
 
 
 
 
 

 
 
Oracle 

performance Tuning 10g reference poster
 
Oracle training in Linux 

commands
 
Oracle training 

Excel
 
Easy Oracle Jumpstart
 
Oracle training & performance tuning books
 
Burleson Consulting Remote DB Administration
 
 
 
Reply to this topicStart new topic
> Simulating control file damage
paulogervasio
post Feb 16 2012, 02:45 PM
Post #1


Advanced Member
***

Group: Members
Posts: 69
Joined: 5-August 11
From: Brazil
Member No.: 45,669



Hi,
I am trying to simulate a damage in my control files

$ORACLE_BASE/oradata/orcl/control01.ctl and $ORACLE_BASE/flash_recovery_area/orcl/control02.ctl

So I moved these files to another folder different of origin with the database online (in linux, I tried to do it in win7, but not works)!

And for my surprise the DML and DDL commands still working!?

The Oracle docs said:

QUOTE
If any of the control files become unavailable during database operation, the instance becomes inoperable and should be aborted.


http://docs.oracle.com/cd/B28359_01/server.../control002.htm


Did someone can tell me what " the instance becomes inoperable" in Oracle Docs means?

Thanks.
Paulo.
Go to the top of the page
 
+Quote Post
burleson
post Feb 17 2012, 10:06 AM
Post #2


Advanced Member
***

Group: Members
Posts: 11,088
Joined: 26-January 04
Member No.: 13



[code][/code]Hi Paulo,

>> And for my surprise the DML and DDL commands still working!?


Nah, I don't think so! There MIST be control files there . . .

See here, how to check locations :

http://www.dba-oracle.com/t_oracle_display_controlfiles.htm

*******************************************
http://www.dba-oracle.com/sf_ora_00204_err...ol_file_bc1.htm

>> If any of the control files become unavailable during database operation, the instance becomes inoperable and should be aborted. Did someone can tell me what " the instance becomes inoperable" in Oracle Docs means?

If Oracle cannot update all of the control files because of an I/O error (or missing file), the database will crash and refuse to proceed until it is fixed.

ORA-00204: error in reading control file name block num, # blocks num

ORA-00204: error in reading (block string, # blocks string) of control file

Cause:A disk I/O failure was detected on reading the control file.

Action:
Check if the disk is online, if it is not, bring it online and try a warm start again. If it is online, then you need to recover the disk.


--------------------
Hope this helps. . .

Donald K. Burleson
Oracle Press author
Author of Oracle Tuning: The Definitive Reference
Go to the top of the page
 
+Quote Post
SteveC
post Feb 18 2012, 12:48 PM
Post #3


Advanced Member
***

Group: Members
Posts: 2,807
Joined: 11-March 08
Member No.: 18,933



Windows - file is locked, you're not going to be able to rename or delete it.
UNIX - inode needs to be understood. You can move or rename a file, but there is still a pointer to it.

Either - if the drive is lost, the instance crashes, not hangs.

http://www.databasejournal.com/features/or...cle.php/3732711
Go to the top of the page
 
+Quote Post

Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 

Lo-Fi Version Time is now: 18th April 2014 - 01:31 PM