Re: OCP Question

From: <Mayen.Shah_at_lazard.com>
Date: Wed, 16 Dec 2009 15:02:02 -0500
Message-ID: <OF8814022E.2A8A8720-ON8525768E.006DD87C-8525768E.006E0D04_at_lazard.com>

That will happen if tablespace was dropped after the controlfile backup was taken. (files exist in control file but missing from the location)

"Bill Zakrzewski" <bill_at_intactus.com>
Sent by: oracle-l-bounce_at_freelists.org Dec 16 2009 02:57 PM
Please respond to
bill_at_intactus.com

To
"Oracle-L_at_freelists.org" <oracle-l_at_freelists.org>
cc

Subject
OCP Question

Listers -

I took the Oracle 10g OCP exam and one question in the exam was something I have not come across in several years working with Oracle. I searched google, but only found someone has had this happen, but they didn't understand why - it was during a database cloning process.

It went something like - You rebuild your controlfile and open your database and discover several datafiles have been renamed to /somepath/MISSING##### (where ##### is a 5-digit number).

What might that signify?

A. Those are corrupt files?
B. Those are read-only tablespace files?
C. .....
D. .....
E. .....

I don't remember the five choices, but does anyone know why Oracle would rename datafiles to .....MISSING#####.

Thanks
Bill--
http://www.freelists.org/webpage/oracle-l

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Dec 16 2009 - 14:02:02 CST