-
Oracle 9i to 10g upgrade (Raw Device to GPFS)
For a database upgrade from 9i (Raw device storage) to 10g (GPFS), what options from the following can be considered?
- DBUA
- Manual Upgrade
- Export/Import
I was considering 9i exp & 10g impdp (data pump import). The size of the database is about 300 GB. Any suggestions & learnings that can be shared?
Thanks in advance.
-
The third option is less complicated. But if you are using packages/procedures then you need to verify its execution. I had an experience using the 3rd option and resulted in "ora-06502 PL/QL Numeric or Value - Character string buffer too small". Then it has resolved by setting the parameter blank_trimming to true
BTW, what platform the database is running?
-
Originally Posted by Ravi_2008
The third option is less complicated. But if you are using packages/procedures then you need to verify its execution. I had an experience using the 3rd option and resulted in "ora-06502 PL/QL Numeric or Value - Character string buffer too small". Then it has resolved by setting the parameter blank_trimming to true
BTW, what platform the database is running?
Thanks for the input.
The OS is AIX.
-
if its me I will try upgrade instead of exp/imp
plus you cannot use impdp for a export file
-
Originally Posted by pando
plus you cannot use impdp for a export file
Thanks for pointing that out. I now realize that we cannot use 10g impdp on a 9i exp file.
However, when using DBUA even though the OS is AIX; the source storage is raw device (9i) & target is GPFS (10g). Can we still use a 9i backup (raw device data files) to restore in a 10g environment (GPFS)?
Thanks in advance.
-
Hi
Just a thought have you investigated rman backups for doing this ?
my choice would be rman or dd
http://youngcow.net/doc/oracle10g/se...8/appa_aix.htm
regards
Hrishy
Last edited by hrishy; 04-08-2008 at 02:38 AM.
-
Originally Posted by hrishy
Many thanks for the input. Very useful information on 'Backing Up Raw Devices' in the link provided.
Can you please confirm that such a 'dd' raw device database backup can be restored successfully in a GPFS environment?
Thanks in advance.
Last edited by ggnanaraj; 04-08-2008 at 06:55 AM.
-
Hi
Yes RMAN can backup to a GPFS environment.
well outside rman only dd is the command that can do raw device copy.
And my guess is yes dd can copy from raw devices to GPFS.
regards
Hrishy
-
Originally Posted by hrishy
Yes RMAN can backup to a GPFS environment.
Thanks. Can you help point to docs on RMAN backup in 9i on AIX (raw device) & RMAN restore in GPFS (AIX)?
Thanks again.
-
Hmmm
well did you look at the rman copy command ?
http://igor.gold.ac.uk/oracle/9i/ser...ckp.htm#422767
copy datafile 1 format to TO '/GPFS or regular filesystem/system01.dbf'
all unix commands work with GPFS file sysytem
regards
Hrishy
Last edited by hrishy; 04-08-2008 at 08:17 AM.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|