I'm preparing to do my first 9i to 10g upgrade and would like to have a
solid plan in place before I start. I've prepared an implementation plan
with the following steps and would like to know if anyone sees steps I might
have missed. We also are moving from a 32-bit to 64-bit platform. The
10gR2 upgrade guide says this will be handled automatically going from 9i to
10g.
- Install latest version of OS and all necessary OS patches for the
Linux/Oracle platform.
- Install 9i and apply necessary patches to bring up to current production
level.
- Install 10g in another home and apply any necessary patches.
- Create a test 9i database.
- Set up backups for both the database and archivelogs.
- Test backup and restore.
- Upgrade the test 9i to 10g to ensure I understand the process.
- Test backup and restore again. Note any issues or changes needed.
- Restore the production 9i database from tape. Note timings. (I won't
be able to do a cold backups because of the length of the downtime
necessary.)
- Restore the production archivelogs.
- Do a P-I-T recovery.
- Point the test app server to the restored 9i database.
- Cold backup restored 9i database in case we need to retest from this
point forward. Note timings.
- Thoroughly test app against restored database. Monitor for a
performance baseline on the new node. (They tell me they can duplicate a
production load.)
- Backup archive logs. Note timings. (They're asking for this info on
archivelogs.)
- Upgrade to 10g.
- Thoroughly test app against 10g database. Monitor performance, errors,
etc.
- Make necessary parameter and code changes. (We expect this phase to be
lengthy.)
- Remove test databases from new node.
- Begin production restore, upgrade, go live.
They have never done a database restore from tape that they are aware of so
this also will be my opportunity to implement a disaster recovery plan. The
current plan is "cross your fingers and pray". I've only been on the job
for 6 weeks and this is my first time on Linux so I'm a bit nervous about
doing it the right way the first time. I've worked on Solaris, AIX, HP-UX,
and Tru64 and I'm hoping the install and upgrades will be similar to what
I've done in the past.
Sandy
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Jul 20 2006 - 16:31:12 CDT
