Re: Adding datafiles to the newly built database after restore from Prod
- From: Andy Klock <andy@xxxxxxxxxxxxxxx>
- To: nileshkum@xxxxxxxxx
- Date: Mon, 16 May 2011 10:05:54 -0400
The resetlogs was the problem with your data file restore. If this is
enterprise edition you can do a tablespace point in time recovery or if
standard you could have possibly done a datapump export of the
tablespace(s).
On Mon, May 16, 2011 at 2:39 AM, nilesh kumar <nileshkum@xxxxxxxxx> wrote:
> Hello All,
>
> Good Morning/Afternoon,
>
> Hope every one is doing a good job!!
>
> I had a problem yesterday,
>
> OS:- SOLARIS
> database version:- ORACLE 10G (10.2.0.4)
>
> 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.
>
> Thanks
> Nilesh
>
>
>
>
>
>
>
>
>
>
Other related posts:
