Restore database from backup


We might need to restore our database from backup. What I have discovered is that the backup has been made while the database has been open/running. (it was just filecopying of the whole server).

Does anyone have any idea or experience of the chances that this backup will work properly? (it is a 9i database)

Thanks in advance!

Best regards,


Who is Participating?

Improve company productivity with a Business Account.Sign Up

Mark GeerlingsConnect With a Mentor Database AdministratorCommented:
No, it will not work.  At least according to Oracle's documentation and my experience it will not work.  Now if your database was very quiet at the time of the backup, and if the database is quite small and your backup is quite fast, there is a slim chance that it will work, but I do not expect that it will.

Also, with some operating systems (like Windows) doing an O/S backup with an Oracle database open will tend to crash Oracle, since the backup will try to get a lock on database files that Oracle will try to write to periodically.

Do you have an export as an alternative?  I never like to depend on just one form of recovery.  I like having backups plus export.  Also, is your database in archivelog mode?  If not, and you ever need to restore from backup, any/all changes made after the backup will be lost.
tomerikvAuthor Commented:

I understand.

The database is quite large, so I also think there is no chance that the backup will work.

I also did a back with this command in DOS (this inn win 2000 server):

set ORACLE_HOME= F:\ora9ias
set ORACLE_SID=iasdb1

exp system/XXXXXX full=Y file=H:\database_bck\juli_infra_bck.dmp log=H:\database_bck\juli_infra_bck.log compress=Y grants=Y rows=Y

The problem is that when I try to import a .dmp file on my local database I get into two problems (depending on if I'm using IGNORE=Y or no).

If I don't use ignore I get:
object alreay exists (or something like that) and no data is imported in those objects/tables

If I use IGNORE=Y all the data are doubled, but as I understand this is solved if there are primary keys on every table. Else the data will be doubled?? I also got a weird error doing this on my local database:
colomn1 1kgepop: no error frame to pop to for error 21500

I import into the same database as I export from.

So I don't really trust this import either.

If you have a tip on what wrong with my import. please let me know!

Best regards,


Mark GeerlingsDatabase AdministratorCommented:
Yes, if you do a full import into the same database the export was from, you will have the two problems you mentioned.  Normally a full import is not done into the same database that created the export.  A full import can be used to create a copy of a production database on a different server for test purposes for example.  Also, import can be used to just recover a particular table (or group of tables) if a table or tables were accidentally dropped or truncated.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.