Re: OCP Question
- From: Mayen.Shah@xxxxxxxxxx
- To: bill@xxxxxxxxxxxx
- Date: Wed, 16 Dec 2009 15:02:02 -0500
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@xxxxxxxxxxxx>
Sent by: oracle-l-bounce@xxxxxxxxxxxxx
Dec 16 2009 02:57 PM
Please respond to
bill@xxxxxxxxxxxx
To
"Oracle-L@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
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--
//www.freelists.org/webpage/oracle-l
Other related posts:
