Hi experts,
When I extend the tablespace of SYSTEM, the system showed BR1049W Not enough free space in /oracle/IDS/sapdata1. Please see the log below:
GVSHP101:oraids 72> brtools
BR0651I BRTOOLS 7.20 (34)
BR0280I BRTOOLS time stamp: 2014-08-15 15.46.28
BR0656I Choice menu 1 - please make a selection
-------------------------------------------------------------------------------
BR*Tools main menu
1 = Instance management
2 - Space management
3 - Segment management
4 - Backup and database copy
5 - Restore and recovery
6 - Check and verification
7 - Database statistics
8 - Additional functions
9 - Exit program
Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------
BR0662I Enter your choice:
2
BR0280I BRTOOLS time stamp: 2014-08-15 15.46.32
BR0663I Your choice: '2'
BR0280I BRTOOLS time stamp: 2014-08-15 15.46.32
BR0656I Choice menu 5 - please make a selection
-------------------------------------------------------------------------------
Database space management
1 = Extend tablespace
2 - Create tablespace
3 - Drop tablespace
4 - Alter tablespace
5 - Alter data file
6 - Move data file
7 - Additional space functions
8 - Reset program status
Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------
BR0662I Enter your choice:
1
BR0280I BRTOOLS time stamp: 2014-08-15 15.46.36
BR0663I Your choice: '1'
BR0280I BRTOOLS time stamp: 2014-08-15 15.46.36
BR0657I Input menu 81 - please enter/check input values
-------------------------------------------------------------------------------
BRSPACE options for tablespace extension
1 - BRSPACE profile (profile) ...... [initIDS.sap]
2 - Database user/password (user) .. [/]
3 ~ Tablespace name (tablespace) ... []
4 - Confirmation mode (confirm) .... [yes]
5 - Scrolling line count (scroll) .. [20]
6 - Message language (language) .... [E]
7 - BRSPACE command line (command) . [-p initIDS.sap -s 20 -l E -f tsextend]
Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------
BR0662I Enter your choice:
c
BR0280I BRTOOLS time stamp: 2014-08-15 15.46.55
BR0663I Your choice: 'c'
BR0259I Program execution will be continued...
BR0291I BRSPACE will be started with options '-p initIDS.sap -s 20 -l E -f tsextend'
BR0280I BRTOOLS time stamp: 2014-08-15 15.46.55
BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:
c
BR0280I BRTOOLS time stamp: 2014-08-15 15.46.57
BR0257I Your reply: 'c'
BR0259I Program execution will be continued...
###############################################################################
BR1001I BRSPACE 7.20 (34)
BR1002I Start of BRSPACE processing: seonihqf.tse 2014-08-15 15.46.57
BR0484I BRSPACE log file: /oracle/IDS/sapreorg/seonihqf.tse
BR0280I BRSPACE time stamp: 2014-08-15 15.46.58
BR1009I Name of database instance: IDS
BR1010I BRSPACE action ID: seonihqf
BR1011I BRSPACE function ID: tse
BR1012I BRSPACE function: tsextend
BR0280I BRSPACE time stamp: 2014-08-15 15.46.58
BR0656I Choice menu 301 - please make a selection
-------------------------------------------------------------------------------
Tablespace extension main menu
1 = Extend tablespace
2 - Show tablespaces
3 - Show data files
4 - Show disk volumes
5 * Exit program
6 - Reset program status
Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------
BR0662I Enter your choice:
c
BR0280I BRSPACE time stamp: 2014-08-15 15.47.08
BR0663I Your choice: 'c'
BR0259I Program execution will be continued...
BR0280I BRSPACE time stamp: 2014-08-15 15.47.09
BR0658I List menu 302 - please select one entry
-------------------------------------------------------------------------------
List of tablespaces for extension
Pos. Tablespace Files/AuExt. Total[KB] Used[%] Free[KB] MaxSize[KB]
1 - PSAPSR3 64/64 131072000 66.98 43284224 655360000
2 - PSAPSR3700 61/61 124928000 81.85 22675840 624640000
3 - PSAPSR3DIM 1/1 204800 5.16 194240 33554416
4 - PSAPSR3FACT 1/1 204800 4.81 194944 33554416
5 - PSAPSR3ODS 1/1 204800 0.41 203968 33554416
6 - PSAPSR3USR 1/1 102400 59.13 41856 10240000
7 - PSAPTEMP 1/1 2048000 0.00 2048000 10240000
8 - PSAPUNDO 1/1 9502720 0.01 9501632 10240000
9 - SYSAUX 1/1 348160 98.62 4800 10240000
10 - SYSTEM 1/1 1413120 99.54 6528 10240000
Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------
BR0662I Enter your selection:
10
BR0280I BRSPACE time stamp: 2014-08-15 15.47.12
BR0663I Your selection: '10'
BR0280I BRSPACE time stamp: 2014-08-15 15.47.12
BR0657I Input menu 303 - please enter/check input values
-------------------------------------------------------------------------------
Options for extension of tablespace SYSTEM (1. file)
1 * Last added file name (lastfile) ....... [/oracle/IDS/sapdata1/system_1/system.data1]
2 * Last added file size in MB (lastsize) . [1380]
3 - New file to be added (file) ........... [/oracle/IDS/sapdata1/system_2/system.data2]
4 ~ Raw disk / link target (rawlink) ...... []
5 - Size of the new file in MB (size) ..... [1380]
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 SYSTEM add datafile '/oracle/IDS/sapdata1/system_2/system.data2' size 1380M autoextend on next 20M maxsize 10000M]
Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------
BR0662I Enter your choice:
c
BR0280I BRSPACE time stamp: 2014-08-15 15.47.17
BR0663I Your choice: 'c'
BR0259I Program execution will be continued...
BR1049W Not enough free space in /oracle/IDS/sapdata1 for total maximum size of all database files of tablespace PSAPSR3 located on this disk volume, missing at least 429044.291 MB
BR1049W Not enough free space in /oracle/IDS/sapdata1 for total maximum size of all database files of tablespace PSAPSR3700 located on this disk volume, missing at least 405044.291 MB
BR0280I BRSPACE time stamp: 2014-08-15 15.47.17
BR0668I Warnings or errors occurred - you can continue to ignore them or go back to repeat the last action
BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:
c
BR0280I BRSPACE time stamp: 2014-08-15 15.47.19
BR0257I Your reply: 'c'
BR0259I Program execution will be continued...
BR1091I Next data file can be specified now
BR0280I BRSPACE time stamp: 2014-08-15 15.47.19
BR0675I This is a optional action - do you want to execute it now?
BR0676I Enter 'y[es]' to execute the action, 'n[o]/c[ont]' to skip it, 's[top]' to abort:
y
BR0280I BRSPACE time stamp: 2014-08-15 15.47.22
BR0257I Your reply: 'y'
BR0677I The action will be executed...
BR0280I BRSPACE time stamp: 2014-08-15 15.47.22
BR0657I Input menu 303 - please enter/check input values
-------------------------------------------------------------------------------
Options for extension of tablespace SYSTEM (2. file)
1 * Last added file name (lastfile) ....... [/oracle/IDS/sapdata1/system_1/system.data1]
2 * Last added file size in MB (lastsize) . [1380]
3 - New file to be added (file) ........... [/oracle/IDS/sapdata1/system_3/system.data3]
4 ~ Raw disk / link target (rawlink) ...... []
5 - Size of the new file in MB (size) ..... [1380]
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 SYSTEM add datafile '/oracle/IDS/sapdata1/system_2/system.data2' size 1380M autoextend on next 20M maxsize 10000M, '/oracle/IDS/sapdata1/system_3/system.data3' size 1380M autoextend on next 20M maxsize 10000M]
Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------
BR0662I Enter your choice:
c
BR0280I BRSPACE time stamp: 2014-08-15 15.47.25
BR0663I Your choice: 'c'
BR0259I Program execution will be continued...
BR1049W Not enough free space in /oracle/IDS/sapdata1 for total maximum size of all database files of tablespace PSAPSR3 located on this disk volume, missing at least 430424.299 MB
BR1049W Not enough free space in /oracle/IDS/sapdata1 for total maximum size of all database files of tablespace PSAPSR3700 located on this disk volume, missing at least 406424.299 MB
BR0280I BRSPACE time stamp: 2014-08-15 15.47.25
BR0668I Warnings or errors occurred - you can continue to ignore them or go back to repeat the last action
BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:
c
Now I cannot extend the tablespace, Can any expert help me ?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.