Home » RDBMS Server » Backup & Recovery » Restore 8 to 10
Restore 8 to 10 [message #220093] Sun, 18 February 2007 19:49 Go to next message
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 Go to previous messageGo to next message
BlackSwan
Messages: 25046
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.
Re: Restore 8 to 10 [message #220099 is a reply to message #220093] Sun, 18 February 2007 20:04 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
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.
Re: Restore 8 to 10 [message #220115 is a reply to message #220093] Sun, 18 February 2007 22:53 Go to previous messageGo to next message
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.
Re: Restore 8 to 10 [message #220116 is a reply to message #220093] Sun, 18 February 2007 22:58 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
Migration of a functioning clone is the BEST option.
Re: Restore 8 to 10 [message #220117 is a reply to message #220093] Sun, 18 February 2007 23:02 Go to previous messageGo to next message
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 Go to previous message
Mahesh Rajendran
Messages: 10672
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.
Previous Topic: whole database backup
Next Topic: BUFFER Parameter
Goto Forum:
  


Current Time: Thu Dec 08 04:13:45 CST 2016

Total time taken to generate the page: 0.10387 seconds