Re: Adding datafiles to the newly built database after restore from Prod
- From: Mark Brinsmead <pythianbrinsmead@xxxxxxxxx>
- To: "andy@xxxxxxxxxxxxxxx" <andy@xxxxxxxxxxxxxxx>
- Date: Mon, 16 May 2011 20:32:47 -0400
does a solution exist for this problem?
yes.
RMAN. :-)
it is too late for RMAN to help you on this recovery, but in the
"lessons learned" category, it may be a good time to suggest using
rman to manage your backups and recoveries going forward. the problem
you face now could have easily been avoided with rman.
On Monday, May 16, 2011, Andy Klock <andy@xxxxxxxxxxxxxxx> wrote:
> 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
>
>
>
>
>
>
>
>
>
>
>
--
Cheers,
-- Mark Brinsmead
Senior DBA,
The Pythian Group
http://www.pythian.com/blogs
--
//www.freelists.org/webpage/oracle-l
Other related posts:
