Solved

Restore database from backup

Posted on 2004-07-31
3
614 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 200 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

Get HTML5 Certified

Want to be a web developer? You'll need to know HTML. Prepare for HTML5 certification by enrolling in July's Course of the Month! It's free for Premium Members, Team Accounts, and Qualified Experts.

Question has a verified solution.

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

How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
Suggested Courses

628 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