What's the objective? The db is broken? Or do you need a special recovery?

if only the dbnames are different and one is valuable (Structure and data), import and export...

I haven't verify and I'm not sure but it seems me impossible to apply the archive on your test DB (which was not in archivelog mode, I presume).

----- Original Message -----
From: "Jautse Thabo " <oracledba-ezmlmshield-x80113846.[Email address protected]
To: "LazyDBA Discussion" <[Email address protected]
Subject: Using archive to recover
Date: Wed, 29 Dec 2004 09:39:09 +0200

>
> Hi all,
>
>
>
> Is it possible to use production DB archives to recover to the test
> system?
>
> The database structure is the same and only the DB names are different.
>
>
>
> Regards,
>
> Thabo
>
>
> ___________________________________________________________________________________________________
>
>
> The views expressed in this email are, unless otherwise stated,
> those of the author and not those
> of the FirstRand Banking Group an Authorised Financial Service
> Provider or its management.
> The information in this e-mail is confidential and is intended
> solely for the addressee.
> Access to this e-mail by anyone else is unauthorised.
> If you are not the intended recipient, any disclosure, copying,
> distribution or any action taken or
> omitted in reliance on this, is prohibited and may be unlawful.
> Whilst all reasonable steps are taken to ensure the accuracy and
> integrity of information and data
> transmitted electronically and to preserve the confidentiality
> thereof, no liability or
> responsibility whatsoever is accepted if information or data is,
> for whatever reason, corrupted
> or does not reach its intended destination.
>
> ________________________________
>
>
> --------
> website: http://www.LazyDBA.com
> Please don't reply to RTFM questions
> Oracle documentation is here: http://tahiti.oracle.com
> To unsubscribe: see http://www.lazydba.com/unsubscribe.html
> To subscribe: see http://www.lazydba.com
> By using this list you agree to these terms:http://www.lazydba.com/legal.html



DEGAND XAVIER

DX SPRL

BRUSSELS, BELGIUM


Oracle LazyDBA home page