on 10-16-2008 7:37 AM
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.
This message was moderated.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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:
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
User | Count |
---|---|
91 | |
7 | |
7 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.