cancel
Showing results for 
Search instead for 
Did you mean: 

extending SAP data into another file system

Former Member
0 Kudos

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.

Accepted Solutions (0)

Answers (4)

Answers (4)

Former Member
0 Kudos

This message was moderated.

Former Member
0 Kudos

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:

former_member204746
Active Contributor
0 Kudos

you are missing a directory (or do not have proper permission on it)

/oracle/BWD/sapreorg

Former Member
0 Kudos

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

andreas_herzog
Active Contributor
0 Kudos

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

you're right - but it's still possible

@ razman razak...how come you do not have the oracle directories mounted? who installed the system?

GreetZ, AH

former_member201054
Contributor
0 Kudos

Please let us know how to extend the database on a new mount point(sapdata7) .I may stumble on this scenario very soon .

Any guide/steps would be appreciated.

Former Member
0 Kudos

Under oracle,there are sapdata1 until sapdata 6.all the mirrolog,saparch,saptrace and oraarch are also there.others is under /usr/sap/ and sapmnt..

Former Member
0 Kudos

Hello,

ask you UNIX administrator (or if you are performing the activity) to install new disk and mount as /oracle/<SID>/sapdata7, then extend your database onto newly created mount point.

cheers,

-Sunil

andreas_herzog
Active Contributor
0 Kudos

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

Former Member
0 Kudos

Andreas ,what you mean is that we use brtools to extend the tablespace and specify the path to the new filesystem?

Former Member
0 Kudos

he mean to say, you can use brtools to extend the database and while doing so you can specify the mointpoint of new datafile.

follow http://help.sap.com/saphelp_nw70/helpdata/EN/03/101549e4617146a670dcc62991ada9/content.htm

cheers,

-Sunil

former_member201054
Contributor
0 Kudos

Can anybody give me the steps ..where to mention sapdata7 in order to extend the tablespace..If we assign as such then the tables PSAPTEMP,PSAP<SID>,PSAP<SID>UDR,PSAP<SID>700,PSAPUNDO & SYSTEM will utilize the new added data file SAPDATA7 or only PSAP<SID> will utilize.

Former Member
0 Kudos

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