Solved

Restore database from backup

Posted on 2004-07-31
3
605 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
  • 2
3 Comments
 
LVL 34

Accepted Solution

by:
Mark Geerlings earned 200 total points
Comment Utility
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
Comment Utility
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 34

Expert Comment

by:Mark Geerlings
Comment Utility
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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

Suggested Solutions

Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: http://www.e-e.com/A_9074.html So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: http://www.e-e.com/A_8429.html Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
This video shows how to recover a database from a user managed backup

763 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now