Oracle 9i to 10g upgrade (Raw Device to GPFS)
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 12

Thread: Oracle 9i to 10g upgrade (Raw Device to GPFS)

  1. #1
    Join Date
    Sep 2000
    Location
    Chennai, India
    Posts
    865

    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?

    1. DBUA
    2. Manual Upgrade
    3. 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.

  2. #2
    Join Date
    Mar 2008
    Posts
    28
    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?

  3. #3
    Join Date
    Sep 2000
    Location
    Chennai, India
    Posts
    865
    Quote 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.

  4. #4
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    if its me I will try upgrade instead of exp/imp

    plus you cannot use impdp for a export file

  5. #5
    Join Date
    Sep 2000
    Location
    Chennai, India
    Posts
    865
    Quote 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.

  6. #6
    Join Date
    Jan 2001
    Posts
    2,828
    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 03:38 AM.

  7. #7
    Join Date
    Sep 2000
    Location
    Chennai, India
    Posts
    865
    Quote Originally Posted by hrishy
    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
    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 07:55 AM.

  8. #8
    Join Date
    Jan 2001
    Posts
    2,828
    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

  9. #9
    Join Date
    Sep 2000
    Location
    Chennai, India
    Posts
    865
    Quote 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.

  10. #10
    Join Date
    Jan 2001
    Posts
    2,828
    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 09: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
  •  


Click Here to Expand Forum to Full Width