OraFAQ Forum: Server Administration » Database Migration (8i to 10g)

Home » RDBMS Server » Server Administration » Database Migration (8i to 10g)

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

Database Migration (8i to 10g) [message #168791]

Sat, 22 April 2006 18:31

suryamz
Messages: 17
Registered: March 2006

Junior Member

Hi

We have 2 environments

Envt 1: Oracle 8.1.7 /Win NT
Database Size = 80GB

Envt 2: Oracle 10.1.0.3 / Windows 2003

We have to perform a database migration from 1 to 2.

Iam aware of creating a similar database and add the same set of tablespaces on 2.

Anyone please suggest me the ideal way of migrating the Database data from 1 to 2.

Also, Iam wondering if doing a full export and import of this 80GB data and import on Envt 2 would be okie.

Please let me know if there is any other better approach for this.
Any input or suggestions (things that i need make sure while migrating data)from you all is appreciated.

Thanks
Sj

Report message to a moderator

Re: Database Migration (8i to 10g) [message #168792 is a reply to message #168791]

Sat, 22 April 2006 18:49

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

Report message to a moderator

Re: Database Migration (8i to 10g) [message #168793 is a reply to message #168791]

Sat, 22 April 2006 18:50

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>Please let me know if there is any other better approach for this.
Better based upon which metric; downtime, simplicity, reliability?
For example if you have 7x24 OLTP with zero downtime the migration will likely be different than where the DB can be down the whole weekend.

Report message to a moderator

Re: Database Migration (8i to 10g) [message #169225 is a reply to message #168791]

Tue, 25 April 2006 16:17

suryamz
Messages: 17
Registered: March 2006

Junior Member

Thanks for the reply
I have one more question,

Now on 8.1.7, we have a set of RBS created under RBS tablespaces.

And on 10g, i noticed the UNDOTBS tablespace.

Now, when we generally create the required tablespaces on 10g, do we also have to created the RBS tablespace on 10g...

Please clarify on this

Thanks
Sj

Report message to a moderator

Re: Database Migration (8i to 10g) [message #169274 is a reply to message #169225]

Wed, 26 April 2006 00:51

madhusunkara
Messages: 59
Registered: March 2006
Location: hyderabad,india

Member

no , you don't have to create RBS, use auto undo management, if you can afford down time you can go for exp/imp

Thanks
Madhu

Report message to a moderator

Previous Topic:	DBMS_JOB
Next Topic:	Login into database without correct password in SYS user

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 12:54:45 CDT 2024