Originally posted by steeve123 I have 2 years of archive log, i want to be able to recover from my full export, instead of course from the database creation.
If is it not possible, how to i apply my archive from a new database?
You cannot use an import and archive logs together.
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.
You created new database, imported database objects and data in the new database using import, but the archivelogs are from the different database, you just can't apply them.
Assume a situation when you open database after imcomplete recovery you resetlogs. After this, all the arhivelogs from prev. incarnation of database are of no use. Same way, you have different database in your situation.