RE: RE: OCP Question
- From: "Blanchard, William" <wblanchard@xxxxxxxxxxxxxxxxxxxx>
- To: <anelson77388@xxxxxxxxx>
- Date: Wed, 16 Dec 2009 14:12:53 -0600
Always a good day to learn something new.
_____
From: anelson77388@xxxxxxxxx [mailto:anelson77388@xxxxxxxxx]
Sent: Wednesday, December 16, 2009 2:11 PM
To: Blanchard, William
Cc: bill@xxxxxxxxxxxx; Oracle-L@xxxxxxxxxxxxx
Subject: Re: RE: OCP Question
You are right. If for some reason you did not get the files in the place
the controlfile thought they were they will come up MISSING in
v$datafile.
On Dec 16, 2009 2:02pm, "Blanchard, William"
<wblanchard@xxxxxxxxxxxxxxxxxxxx> wrote:
> I believe this is because the controlfile can't find the file (someone
>
> correct me if I'm wrong). I would check the path and ensure that the
>
> controlfile is pointing to the correct location.
>
>
>
>
>
> WGB
>
>
>
>
>
> -----Original Message-----
>
> From: oracle-l-bounce@xxxxxxxxxxxxx
>
> [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Bill Zakrzewski
>
> Sent: Wednesday, December 16, 2009 1:58 PM
>
> To: Oracle-L@xxxxxxxxxxxxx
>
> 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
>
>
>
>
>
>
>
> --
>
> //www.freelists.org/webpage/oracle-l
>
>
>
>
>
-
This email and any information, files, or materials transmitted with it
are confidential and are solely for the use of the intended recipient.
If you have received this email in error, please delete it and notify
the sender.
Other related posts:
