OraFAQ Forum: Server Administration » Db Migration from 9i to 10g

Home » RDBMS Server » Server Administration » Db Migration from 9i to 10g (oracle 10g (10.2.0.4), windows 2008 R2)

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

Db Migration from 9i to 10g [message #492678]

Tue, 01 February 2011 14:45

patdev
Messages: 73
Registered: August 2008

Member

hi all,

i have to migrate the current production database to test 10.2.0.4 on windows. would you please suggest non-export way to upgrade 9i to 10 g?

i have following steps please let me know if i am wrong?
1) ALTER DATABASE BACKUP CONTROLFILE TO TRACE

2) shutdown oracle 9i database on server A

3) copy database file, controlfile, redolog, and other files to new server B

4) alter the controlfile backup with new location of bdump, udump, and log file and data file locations

5) user oradim ORADIM -NEW -SID SID [-INTPWD PASSWORD ]-MAXUSERS USERS
-STARTMODE AUTO -PFILE ORACLE_HOME\DATABASE\INITSID.ORA

6) start dabase in upgrade mode

7) run catpat.sql and util102.sql (please correct me if i am wrong)

Cool

take backup

9) open database for users

please guide!! thanks

Report message to a moderator

Re: Db Migration from 9i to 10g [message #492679 is a reply to message #492678]

Tue, 01 February 2011 14:53

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

why upgrading from 1 unsupported version to another unsupported version?

Steps #2 & #3 imply cold backup.
Why not use dbua against cloned DB?

Report message to a moderator

Re: Db Migration from 9i to 10g [message #492680 is a reply to message #492679]

Tue, 01 February 2011 15:04

patdev
Messages: 73
Registered: August 2008

Member

hi,

the production is in 9i and application we have cannot support 11g at all ( which i want to go) so we have to settle with 10.2.0.4.

what do you mean but dbua cloned db?

Report message to a moderator