Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

datafile missing form controlfile after refresh

rkalraApr 19 2011 — edited Apr 19 2011
Hello experts,

I have a query. We are using Oracle database 10gr2 (10.2.0.4) on RHEL 4 (Nahant Update 8).

We had to recreate a Test database from cold backup of production.

The problem is that while recreating the Test database from Production 3 datafiles got missed while creating the control file on Test.

Now these datafiles are being reported as missing from the expected tablespace.

Though the affected tablespaces have datafiles and transactions are not affected,

My question is that is it possible to reattach these datafiles that were missed while recreating controlfile?

The second question is that is there a way to rename these missing (missing01, 02 ...) datafiles from the the affected tablespaces?

Please let me know your views.

Thanks in advance
Rohan
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 17 2011
Added on Apr 19 2011
#general-database-discussions
14 comments
1,162 views