Assuming that the test database was built from the production database and
was opened with reset logs then it is not possible to use the production
archives as the test database is of a different incarnation.
The only way you can use the production archive logs is if you can restore
the test database back to the scn at which the test copy was taken, the
test database must also be in archive log mode,
Regards,
Barry
Barry Scott
M&G Technical Services
Tel: 020 7548 3110
eMail: barry.[Email address protected]
|---------+--------------------------------------------------------->
| | "Degand Xavier " |
| | <oracledba-ezmlmshield-x59439777.[Email Address Removed] | azyDBA.com> |
| | |
| | 29/12/2004 15:13 |
|---------+--------------------------------------------------------->
>--------------------------------------------------------------------------------------------------|
| |
| To: "LazyDBA Discussion" <[Email address protected] |
| cc: (bcc: Barry Scott/LON/M&G) |
| Subject: Re: Using archive to recover |
>--------------------------------------------------------------------------------------------------|
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
--------
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
Message ID - T6e2bcc889bc0a8fab14bc
The information contained in this message may be CONFIDENTIAL and is intended for the addressee only. Any unauthorised use, dissemination of the information, or copying of this message is prohibited. If you are not the addressee, please notify the sender immediately by return e-mail and delete this message. M&G cannot accept liability for statements made which are clearly the sender's own and not made on behalf of M&G. In addition no statement should be construed as giving investment advice within or outside the United Kingdom. Although this e-mail and any attachments are believed to be free of any virus, or other defect which might affect any computer or system into which they are received and opened, it is the responsibility of the recipient to ensure that they are virus free and no responsibility is accepted by M&G for any loss or damage from receipt or use thereof.
Please note that all e-mail messages are subject to interception for lawful business purposes.
Oracle LazyDBA home page