Skip to Content
author's profile photo Former Member
Former Member

extending SAP data into another file system

Dear gurus,

This is my situation,I have a SAP system ECC 6.0 running on HPUX ia64 b.11.23 using oracle 10.2.0.

These are the existing filesystems,

Filesystem kbytes used avail %used Mounted on

/dev/vg00/lvol3 5242880 489032 4716776 9% /

/dev/vg00/lvol1 1835008 127632 1694144 7% /stand

/dev/vg00/lvol8 3145728 2818752 324488 90% /var

/dev/vg00/lvol7 3080192 2575264 501000 84% /usr

/dev/vg01/lvol1 17825792 17043406 737116 96% /usr/sap

/dev/vg00/lvol4 10485760 3648688 6785080 35% /tmp

/dev/vg01/lvol2 17825792 4674684 12329437 27% /sapmnt

/dev/vg01/lvol3 100352000 100054726 284831 100% /oracle

/dev/vg00/lvol6 5373952 5172384 200008 96% /opt

/dev/vg00/lvol5 524288 74408 446416 14% /home

putra-aa-uat:/transaction

47102544 3556504 43546040 8% /usr/sap/XID/SAPSP

/dev/vg02/lvol1 102400000 41566 95961039 0% /oracle2

recently,we've just slot in a new hardisk bcoz of the insufficient space on /oracle and created a new vg02 with mountpoint /oracle2.I cannot combine the new hardisk with the existing vg01 becoz of storage capability limitations.my question is how do i make the increasing data in /oracle will be occupying the new vg02 with mountpoint /oracle2?

Please help..

Thanks.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • Posted on Oct 16, 2008 at 08:41 AM

    somehow i do miss some filesystems like sapdata, origlog & mirrlog etc. where are these? and when you extend the database this will usually be done on datafile level; so you'd have to create new additional datafiles for the tablespaces involved within the newly added filesystem.

    what are the storage limitations you're mentioning?

    GreetZ, AH

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Daniel basis

      there will be no change in existing datafiles.

      when you add new datafile to a tablespace you have an option to specify a new volume/mount point.

      run brtools

      select 2 space management

      select 1 extend tablespace

      select 3 and type tablespace name which you want to exted.

      BRSPACE options for tablespace extension

      1 - BRSPACE profile (profile) ...... [initBWP.sap]

      2 - Database user/password (user) .. [/]

      3 ~ Tablespace name (tablespace) ... [psapbwp]

      4 - Confirmation mode (confirm) .... [yes]

      5 - Scrolling line count (scroll) .. [20]

      6 - Message language (language) .... [E]

      7 - BRSPACE command line (command) . [-p initBWP.sap -s 20 -l E -f tsextend -t psapbwp]

      Standard keys: c - cont, b - back, s - stop, r - refr, h - help

      continue

      -


      Options for extension of tablespace PSAPBWP (1. file)

      1 * Last added file name (lastfile) ....... [/oracle/BWP/sapdata2/bwp_53/bwp.data53]

      2 * Last added file size in MB (lastsize) . [2000]

      3 - New file to be added (file) ........... [/oracle/BWP/sapdata2/bwp_54/bwp.data54]

      4 ~ Raw disk / link target (rawlink) ...... []

      5 - Size of the new file in MB (size) ..... [2000]

      6 - File autoextend mode (autoextend) ..... [no]

      7 # Maximum file size in MB (maxsize) ..... []

      8 # File increment size in MB (incrsize) .. []

      9 - SQL command (command) ................. [alter tablespace PSAPBWP add datafile '/oracle/BWP/sapdata2/bwp_54/bwp.data54' size 2000M autoextend off]

      Standard keys: c - cont, b - back, s - stop, r - refr, h - help

      -


      select option 3 and replace the mountpoint ONLY (in your case /oracle/<SID>/sapdata7)

      once you changed the mount point you can see the same in option 9.

      cheers,

      -Sunil

  • author's profile photo Former Member
    Former Member
    Posted on Oct 16, 2008 at 08:59 AM

    hello,

    under oracle how many sapdata directories are there? if you have sapdadta1 to 6 then you can do simple method is install new disk and mount as new mountpoint as /oracle/<SID>/sapdata7 and then extend your database on this mount point.

    this is SAP standard and supported by SAP too.

    if you create oracle2 filesystem and extend your database on here, then this is not standard SAP structure.

    Cheers,

    -Sunil

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 17, 2008 at 11:01 AM

    I hit this error when extending the tablespace into the new filesystem,

    Options for extension of tablespace PSAPSR3 (1. file)

    1 * Last added file name (lastfile) ....... [/oracle2/sapdata6/sr3_10/sr3.data1

    0]

    2 * Last added file size in MB (lastsize) . [1024]

    3 - New file to be added (file) ........... [/oracle2/sapdata6/sr3_11/sr3.data1

    1]

    4 ~ Raw disk / link target (rawlink) ...... []

    5 - Size of the new file in MB (size) ..... [1024]

    6 - File autoextend mode (autoextend) ..... [yes]

    7 - Maximum file size in MB (maxsize) ..... [4020]

    8 - File increment size in MB (incrsize) .. [20]

    9 - SQL command (command) ................. [alter tablespace PSAPSR3 add dataf

    ile '/oracle2/sapdata6/sr3_11/sr3.data11' size 1024M autoextend on next 20M maxs

    ize 4020M]

    Standard keys: c - cont, b - back, s - stop, r - refr, h - help

    -


    BR0662I Enter your choice:

    c

    BR0280I BRSPACE time stamp: 2008-10-17 20.03.01

    BR0663I Your choice: 'c'

    BR0259I Program execution will be continued...

    BR0280I BRSPACE time stamp: 2008-10-17 20.03.01

    BR1091I Next data file can be specified now

    BR0675I Do you want to perform this action?

    BR0676I Enter 'y[es]' to perform the action, 'n[o]/c[ont]' to skip it, 's[top]'

    to abort:

    n

    BR0280I BRSPACE time stamp: 2008-10-17 20.03.03

    BR0257I Your reply: 'n'

    BR0280I BRSPACE time stamp: 2008-10-17 20.03.03

    BR0257I Your reply: 'n'

    BR0678I The action will be skipped...

    BR0280I BRSPACE time stamp: 2008-10-17 20.03.03

    BR0370I Directory /oracle/BWD/sapreorg/sdzbadwa created

    BR0280I BRSPACE time stamp: 2008-10-17 20.03.05

    BR0301E SQL error -1587 at location BrCtlCopy-1, SQL statement:

    '/* BRSPACE */ ALTER DATABASE BACKUP CONTROLFILE TO '/oracle/BWD/sapreorg/sdzbad

    wa/cntrlBWD.old''

    ORA-01587: error during control file backup file copy

    ORA-27091: unable to queue I/O

    ORA-27072: File I/O error

    HPUX-ia64 Error: 2: No such file or directory

    Additional information: 4

    Additional information: 579

    Additional information: 893952

    BR0320E Copying of control file to /oracle/BWD/sapreorg/sdzbadwa/cntrlBWD.old fa

    iled

    BR0280I BRSPACE time stamp: 2008-10-17 20.03.05

    BR0700E Fatal errors occurred - terminating processing...

    BR1020I Number of tablespaces processed: 0

    BR1004E BRSPACE function 'tsextend' failed

    BR1008I End of BRSPACE processing: sdzbadwa.tse 2008-10-17 20.03.05

    BR0280I BRSPACE time stamp: 2008-10-17 20.03.05

    BR1007I BRSPACE terminated with errors

    ###############################################################################

    BR0292I Execution of BRSPACE finished with return code 5

    BR0668I Warnings or errors occurred - you can continue to ignore them or go back

    to repeat the last action

    BR0280I BRTOOLS time stamp: 2008-10-17 20.03.05

    BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on May 18, 2015 at 01:23 PM

    This message was moderated.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.