on 12-12-2010 5:02 PM
Dear all,
I have tried to extend the tablespace (PSAPSR3) but i got bellow error .
Options for extension of tablespace PSAPSR3 (1. file)
1 * Last added file name (lastfile) ....... [/oracle/IRP/sapdata4/sr3_22/sr3.da
ta22]
2 * Last added file size in MB (lastsize) . [9960]
3 - New file to be added (file) ........... [/oracle/IRP/sapdata4/sr3_23/sr3.da
ta23]
4 ~ Raw disk / link target (rawlink) ...... []
5 - Size of the new file in MB (size) ..... [9960]
6 - File autoextend mode (autoextend) ..... [yes]
7 - Maximum file size in MB (maxsize) ..... [10000]
8 - File increment size in MB (incrsize) .. [20]
9 - SQL command (command) ................. [alter tablespace PSAPSR3 add dataf
ile '/oracle/IRP/sapdata4/sr3_23/sr3.data23' size 9960M autoextend on next 20M m
axsize 10000M]
Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-
BR0662I Enter your choice:
c
BR0280I BRSPACE time stamp: 2010-12-12 22.11.11
BR0663I Your choice: 'c'
BR0259I Program execution will be continued...
BR1049W Not enough free space in /oracle/IRP/sapdata4 for total maximum size of
all database files of tablespace PSAPSR3700 located on this disk volume, missing
at least 6991.749 MB
BR0668I Warnings or errors occurred - you can continue to ignore them or go back
to repeat the last action
Shall i continue with above error to extend the Tablespace ?
Note :the above error shows there is no enough space in file system (/oracle/IRP/sapdata4 )
dev/prddata1lv 120.00 66.61 53.39 56% /oracle/IRP/sapdata1
dev/prddata2lv 120.00 69.17 50.83 58% /oracle/IRP/sapdata2
dev/prddata3lv 120.00 74.55 45.45 63% /oracle/IRP/sapdata3
dev/prddata4lv 120.00 89.14 30.86 75% /oracle/IRP/sapdata4
Kindly suggest
Edited by: satheesh0812 on Dec 12, 2010 6:03 PM
Edited by: satheesh0812 on Dec 12, 2010 6:05 PM
Hi,
Check with brtools and disble the auto extend of datafile which are located on /oracle/IRP/sapdata4.
Then add new datafile or you can ignore the error and continue but it will effect you in future or you can change the location of data file to any other location as /oracle/IRP/sapdata1 or /oracle/IRP/sapdata2 or /oracle/IRP/sapdata3.
Thanks
Anil
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
datafile has been added to different location(Oracle/SID/sapdata4 to Oracle/SID/sapdata2).
Thanks anil for your reply.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.