MISSING FILES - just need some guidance to be sure [message #515143] |
Fri, 08 July 2011 04:07 |
newbie01.oracle
Messages: 14 Registered: December 2009
|
Junior Member |
|
|
Hi,
I cloned a database by manually copying the database files but I missed some datafiles. I've already created the controlfile and did open resetlogs.
I only found out about the MISSING files when some query is giving ORA-376 which means as below:
00376, 00000, "file %s cannot be read at this time"
// *Cause: attempting to read from a file that is not readable. Most likely
// the file is offline.
// *Action: Check the state of the file. Bring it online
Before I redo the clone/copy and wait for hours, I want to know whether copying the missing files and re-creating the controlfile again will work.
Please advises. Thanks.
|
|
|
|
|