Home » RDBMS Server » Server Utilities » Import from 10g backup to 9i DB (windows Xp)
Import from 10g backup to 9i DB [message #537789] Sat, 31 December 2011 02:49 Go to next message
mahmud732
Messages: 73
Registered: October 2009
Location: Dhaka
Member
Dear All,

I have a backup of Oracle Database 10g (business_bk.dmp). Now I would like to import it into Oracle DB 9i. Is It possible.
If Possible then How?

Please Help me.


Regards

Mahmud
Re: Import from 10g backup to 9i DB [message #537791 is a reply to message #537789] Sat, 31 December 2011 03:01 Go to previous messageGo to next message
Michel Cadot
Messages: 59203
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
I have a backup of Oracle Database 10g (business_bk.dmp).

This is NOT a backup of your database, this is a dump of it.

Quote:
Now I would like to import it into Oracle DB 9i. Is It possible.

If it has been exported with exp version 9i.

Regards
Michel
Re: Import from 10g backup to 9i DB [message #537792 is a reply to message #537789] Sat, 31 December 2011 03:02 Go to previous messageGo to next message
John Watson
Messages: 4592
Registered: January 2010
Location: Global Village
Senior Member
I operate a one-man campaign trying to explain that an export (which I assume is what you have, from the .dmp filename suffix) is NOT a backup. I even blogged about it here a year or so ago. But never mind that.

You may be able to import into a 9i database, but some objects might fail. What happens when you try it?

[Updated on: Sat, 31 December 2011 03:03]

Report message to a moderator

Re: Import from 10g backup to 9i DB [message #537855 is a reply to message #537791] Mon, 02 January 2012 00:56 Go to previous messageGo to next message
Database admin
Messages: 365
Registered: September 2006
Location: india
Senior Member

Quote:
This is NOT a backup of your database, this is a dump of it.


Michel,

You say it is a dump and not a backup.What does it mean ?Can you explain it in detail ?

I was thinking an export is another way to backup database apart from RMAN and USER MANAGED
backup.

If you say export is not a backup , then what it is used for ?

Can you please explain it?

Thank you
Re: Import from 10g backup to 9i DB [message #537857 is a reply to message #537855] Mon, 02 January 2012 01:20 Go to previous messageGo to next message
Littlefoot
Messages: 19638
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
From the documentation:

Quote:

An export file is an Oracle binary-format dump file that is typically located on disk or tape. The dump files can be transferred using FTP or physically transported (in the case of tape) to a different site. The files can then be used with the Import utility to transfer data between databases that are on systems not connected through a network. The files can also be used as backups in addition to normal backup procedures.


From my point of view: when you have a proper backup, if anything goes wrong with your database, you can easily restore it. If you don't really care about datafiles, controlfiles, etc. etc. - for example, you are running an XE edition and use only Scott's schema for your own purposes - for example, testing your (PL/)SQL skills and such, an export file might be just "enough". If your disk crashes or whatever happens to the database, XE is easily reinstalled (*) and you'd then simply import your Scott's schema back.

________________________
(*) As we all know, this is not always true. We've seen people struggling with XE installation rather often.
Re: Import from 10g backup to 9i DB [message #537858 is a reply to message #537855] Mon, 02 January 2012 01:27 Go to previous messageGo to next message
John Watson
Messages: 4592
Registered: January 2010
Location: Global Village
Senior Member
Does the discussion here http://orafaq.com/node/2392 help explain? A backup is a copy of datafiles, an export is a copy of data segments.
Re: Import from 10g backup to 9i DB [message #537859 is a reply to message #537858] Mon, 02 January 2012 01:45 Go to previous messageGo to next message
Littlefoot
Messages: 19638
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
John
... undo tablespace the size of Jupiter


./fa/450/0/
Re: Import from 10g backup to 9i DB [message #537862 is a reply to message #537858] Mon, 02 January 2012 03:13 Go to previous messageGo to next message
Database admin
Messages: 365
Registered: September 2006
Location: india
Senior Member

John/Little

Thank you for your wonderful explanations.

Quote:
A backup is a copy of datafiles, an export is a copy of data segments


I agree with your words.But did you also mind to see the comments from Sriram and Others in the link you provided who disagree with your words.

Can you clarify their comments ?

[Updated on: Mon, 02 January 2012 03:17]

Report message to a moderator

Re: Import from 10g backup to 9i DB [message #537863 is a reply to message #537862] Mon, 02 January 2012 03:26 Go to previous messageGo to next message
John Watson
Messages: 4592
Registered: January 2010
Location: Global Village
Senior Member
No, I'm not going to comment on anything until you do some work yourself.

For example, you could explain how to protect your DB against various types of problem. Such as:
Destruction of a file system
A few corrupted blocks, as here http://www.orafaq.com/forum/mv/msg/177681/537490/0/#msg_537490
Loss of your curent logfile group
And so on.

If this isn't already in your system procedures, it should be. Over to you.
Re: Import from 10g backup to 9i DB [message #537871 is a reply to message #537863] Mon, 02 January 2012 05:26 Go to previous message
ramoradba
Messages: 2452
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
@ balaji
Read my comments again,
Quote:
What My intension is to say that Each tool/Utility has its own priority
.
Re read what John Posted on different situations for Recovery/Restore....

Your current Question(hope it is) is
Quote:
I have a backup of Oracle Database 10g (business_bk.dmp). Now I would like to import it into Oracle DB 9i. Is It possible.
If Possible then How?

Michel has already answered your Question.
Quote:
Quote:
I have a backup of Oracle Database 10g (business_bk.dmp).

This is NOT a backup of your database, this is a dump of it.

Quote:
Now I would like to import it into Oracle DB 9i. Is It possible.

If it has been exported with exp version 9i.

Regards
Michel

Please do not post multiple different question on 1 topic.


Sriram Sanka

Previous Topic: Backup determination
Next Topic: Export XML
Goto Forum:
  


Current Time: Tue Sep 23 15:27:40 CDT 2014

Total time taken to generate the page: 0.11757 seconds