Simulating control file damage Options

[paulogervasio]

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:

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.

[burleson]

[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.

[SteveC]

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