?
Solved

Restore database from backup

Posted on 2004-07-31
3
Medium Priority
?
616 Views
Last Modified: 2012-05-05
Hi!

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,

Tom-Erik

0
Comment
Question by:tomerikv
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 35

Accepted Solution

by:
Mark Geerlings earned 800 total points
ID: 11686472
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.
0
 
LVL 1

Author Comment

by:tomerikv
ID: 11687500
Thanks!

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
SET NLS_LANG = NORWEGIAN_NORWAY.WE8ISO8859P1

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,

Tom-Erik







0
 
LVL 35

Expert Comment

by:Mark Geerlings
ID: 11693305
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.
0

Featured Post

On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
Via a live example, show how to take different types of Oracle backups using RMAN.

718 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question