missing DBF file
I was clonning my DB.
I did the following steps:
1.Shutdown the source DB
2.take the backup of all the DBF files.
3.alter database backup control file to trace , of Source DB.
Now While creating the control file I missed one dbf file anyhow.
Control files are created and destination(clonned)
I gave alter database openresetlogs
DB is up.
But while working on the clonned DB, got an error , because one of the dbf file is missed.
By default oracle made a dbf file named like missing1000000, in the respective tablespace.
Now my problem is :
How can I take the DBF file which I left?I mean how can i include the reaminning dbf in my clonned DB
Click Here to Expand Forum to Full Width