Re: Question about IMPORT utility

When a media failure occurs, you can:

1. If you want to use OS copy and if the database is in ARCHIVELOG mode:

    restore damaged datafiles and apply the archive log. I all your logs are available, you will not lose any data.

    else

    restore all files. You will lose all changes made since last full backup.

2) If you want to use EXPORT/IMPORT:

    recreate the database and do a full import. You will lose all changes made since last full export.

If you want to use OS copy and IMPORT, you should delete all objects before import. You can also drop some objects and import them after, but usually, the best way to recover a database is to use OS backup or export file but not both in same time.

--

Jon <jzuazoa_at_nexo.es> a écrit dans le message :
8mu0ld$dch$1_at_unbe.sarenet.es...


> I have a recent OS copy of all the files of the database and I made a

> logical FULL EXPORT copy yesterday. If due to a media failure y lose the

> HARD DISK I would have to copy the files and afterwards I would have to

 use


> a FULL IMPORT. My question is if I would have to delete the database

 objects


> before I do the IMPORT as this utility does not allow to override the

> objects in the database

>

> Thanks

>

>