Hi,
You cannot apply archive logs to an import in order to achieve a point in time recovery....
I'm not giving you an RTFM (by any means), but here is an excerpt from teh backup recovery guide stating the above...
Exporting Data for Added Protection and Flexibility
Because the Oracle Export utility can selectively export specific objects, consider exporting portions or all of a database for supplemental protection and flexibility in a database's backup strategy. This strategy is especially useful for logical backups of the RMAN recovery catalog, because you can quickly reimport this data into any database and rebuild the catalog if the recovery catalog database is lost.
Database exports are not a substitute for whole database backups and cannot provide the same complete recovery advantages that the built-in functionality of Oracle offers. For example, you cannot apply archived logs to logical backups in order to update lost changes. An export provides a snapshot of the logical data (tables, stored procedures, and so forth) in a database when the export was made.
-----Original Message-----
From: Jautse Thabo
[mailto:oracledba-ezmlmshield-x75251097.[Email address protected]
Sent: Tuesday, December 28, 2004 9:06 AM
To: LazyDBA Discussion
Subject: Urgent: Archives and Export
Hi all,
Hope not all the gurus are on leave. I have a full export file and I
also have archives
that were created after this export was finished. I want to use the
archives and
the export to recover data up to this morning. Is this possible and how
would
I go about it?
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
Oracle LazyDBA home page