OraFAQ Forum: Backup & Recovery

Home » RDBMS Server » Backup & Recovery » Restore 8 to 10

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Restore 8 to 10 [message #220093]

Sun, 18 February 2007 19:49

salnasi
Messages: 3
Registered: February 2007
Location: United States

Junior Member

I am a newbie to Oracle. I am an original SQL DBA. Is there any way to migrate an Oracle 817 database to 10g R2? The only way I know of is to export and import. But can I take an offline backup and restore it? Any help would be great. Thanks in advance.

[Updated on: Sun, 18 February 2007 19:49]

Report message to a moderator

Re: Restore 8 to 10 [message #220096 is a reply to message #220093]

Sun, 18 February 2007 19:58

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Your requirements are less than perfectly clear.
http://download-west.oracle.com/docs/cd/B19306_01/server.102/b14238/toc.htm
The manual should provide the foundation of what you need, but only if you'll take the time to read & digest.
It depends upon many factors.
exp/imp is on possiblity; but a very poor choice.

Report message to a moderator

Re: Restore 8 to 10 [message #220099 is a reply to message #220093]

Sun, 18 February 2007 20:04

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14238/toc.htm
You might want to check the official documentation for the options, pros and cons.
Exp/imp methods do work, but the reliability depends on the volume of data. And, Export / import works very good with just simple databases with plain data. If you have any of options installed better use the proper method.

Report message to a moderator

Re: Restore 8 to 10 [message #220115 is a reply to message #220093]

Sun, 18 February 2007 22:53

salnasi
Messages: 3
Registered: February 2007
Location: United States

Junior Member

Thanks for the reply. I have read this post before. But what I am do not want to upgrade my existing oracle instance. I have installed the 10g on a different server. Wanted to know what my best options are or migrating the database. I will continue reading the articles you posted to see if I can find my answer.

Thanks again.

Report message to a moderator

Re: Restore 8 to 10 [message #220116 is a reply to message #220093]

Sun, 18 February 2007 22:58

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Migration of a functioning clone is the BEST option.

Report message to a moderator

Re: Restore 8 to 10 [message #220117 is a reply to message #220093]

Sun, 18 February 2007 23:02

salnasi
Messages: 3
Registered: February 2007
Location: United States

Junior Member

Thanks anacedent. I will look that up. if you have any links to good articles it would be much appreciated.

Will this work if I clone an 817 database to 10g environment?

[Updated on: Sun, 18 February 2007 23:08]

Report message to a moderator

Re: Restore 8 to 10 [message #220186 is a reply to message #220115]

Mon, 19 February 2007 06:32

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

still the same policies will apply.
Export/Import is easy if the volume is small.
Else,
Create a new 8i environment in new machine.
Copy the datafiles.
Mount the 8i database.
Install 10g.
Upgrade.

Report message to a moderator

Previous Topic:	whole database backup
Next Topic:	BUFFER Parameter

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu May 02 13:21:10 CDT 2024