Adding datafiles to the newly built database after restore from Prod

  • From: nilesh kumar <nileshkum@xxxxxxxxx>
  • To: ORACLE-L <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 16 May 2011 12:09:54 +0530

Hello All,

Good Morning/Afternoon,

Hope every one is doing a good job!!

I had a problem yesterday,

database version:- ORACLE 10G (

Task assigned to me was:- To create a replica of the Production database
from the cold backup to a test server, which could be used for application
team as testing database.

we have the backup taken using Netbackup, backup team missed to restore 3
file from the cold backup, I assumed all the files are restored and i
created the control file from all the files backup team restored to test
server(expect 3 files). database was opened using resetlogs and I also
changed the dbid of the database and database name too. After 2 0r 3 days,
application team complained that we see 3 datafiles are offline.
When i checked, I could see the zero kb files in the oracle home with the
name being as ($ORACLE_HOME/missingfileid).
I asked the BUR to restore the 3 files they had missed so that i will try to
rename and do a recovery,  but was not able to do. It prompted that database
id mis-match error.
Finally I needed to clear all the files and ask the BUR team to restore from
start and was able to build the DB.

Do any solution exists for the above problem without doing a full  restore
again. Kindly advise.

Waiting for your reply.


Other related posts: