RE: OCP Question
- From: "Blanchard, William" <wblanchard@xxxxxxxxxxxxxxxxxxxx>
- To: <Santhosh.Channa@xxxxxxxxxxxx>, <bill@xxxxxxxxxxxx>, "Oracle-L@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 16 Dec 2009 14:12:23 -0600
So, if I read this correctly, when the controlfile was recreated, not
all of the datafiles were included. Since the Dictionary knows about
them but the controlfile doesn't, they are added to the controlfile with
the MISSINGnnnn filename.
WGB
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Channa, Santhosh
Sent: Wednesday, December 16, 2009 2:06 PM
To: bill@xxxxxxxxxxxx; Oracle-L@xxxxxxxxxxxxx
Subject: RE: OCP Question
Hope this helps.
This is an extract from Oracle Manual:
Checking for Missing or Extra Files
After creating a new control file and using it to open the database,
check the alert log to see if the database has detected inconsistencies
between the data dictionary and the control file, such as a datafile in
the data dictionary includes that the control file does not list.
If a datafile exists in the data dictionary but not in the new control
file, the database creates a placeholder entry in the control file under
the name MISSINGnnnn, where nnnn is the file number in decimal.
MISSINGnnnn is flagged in the control file as being offline and
requiring media recovery.
If the actual datafile corresponding to MISSINGnnnn is read-only or
offline normal, then you can make the datafile accessible by renaming
MISSINGnnnn to the name of the actual datafile. If MISSINGnnnn
corresponds to a datafile that was not read-only or offline normal, then
you cannot use the rename operation to make the datafile accessible,
because the datafile requires media recovery that is precluded by the
results of RESETLOGS. In this case, you must drop the tablespace
containing the datafile.
Conversely, if a datafile listed in the control file is not present in
the data dictionary, then the database removes references to it from the
new control file. In both cases, the database includes an explanatory
message in the alert log to let you know what was found.
Regards,
Santhosh Channa
-----Original Message-----
From: Bill Zakrzewski [mailto:bill@xxxxxxxxxxxx]
Sent: Wednesday, December 16, 2009 2: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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
