Procedure :
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
-------------------------------------------------------------------------------
BR0662I Enter your choice:
2
BR0280I BRTOOLS time stamp: 2020-01-29 14:09:42
BR0663I Your choice: '2'
-------------------------------------------------------------------------------
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
-------------------------------------------------------------------------------
BR0662I Enter your choice:
1
BR0280I BRTOOLS time stamp: 2020-01-29 14:09:49
BR0663I Your choice: '1'
-------------------------------------------------------------------------------
BRSPACE options for tablespace extension
1 - BRSPACE profile (profile) ...... [init<SID>.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 init<SID>.sap -s 20 -l E -f tsextend]
Standard keys: c - cont, b - back, s - stop, r - refr
-------------------------------------------------------------------------------
BR0662I Enter your choice:
3
BR0280I BRTOOLS time stamp: 2020-01-29 14:09:51
BR0663I Your choice: '3'
BR0681I Enter string value for "tablespace" []:
PSAPSR3
-------------------------------------------------------------------------------
BRSPACE options for tablespace extension
1 - BRSPACE profile (profile) ...... [init<SID>.sap]
2 - Database user/password (user) .. [/]
3 ~ Tablespace name (tablespace) ... [PSAPSR3]
4 - Confirmation mode (confirm) .... [yes]
5 - Scrolling line count (scroll) .. [20]
6 - Message language (language) .... [E]
7 - BRSPACE command line (command) . [-p init<SID>.sap -s 20 -l E -f tsextend -t PSAPSR3]
Standard keys: c - cont, b - back, s - stop, r - refr
-------------------------------------------------------------------------------
BR0662I Enter your choice:
c
BR0280I BRTOOLS time stamp: 2020-01-29 14:09:57
BR0663I Your choice: 'c'
-------------------------------------------------------------------------------
Options for extension of tablespace PSAPSR3 (1. file)
1 * Last added file name (lastfile) ....... [/oracle/<SID>/sapdata3/sr3_223/sr3.data223]
2 * Last added file size in MB (lastsize) . [10000]
3 - New file to be added (file) ........... [/oracle/<SID>/sapdata3/sr3_224/sr3.data224]
4 # Raw disk / link target (rawlink) ...... []
5 - Size of the new file in MB (size) ..... [10000]
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 PSAPSR3 add datafile '/oracle/<SID>/sapdata3/sr3_224/sr3.data224' size 10000M autoextend off]
Standard keys: c - cont, b - back, s - stop, r - refr
-------------------------------------------------------------------------------
BR0662I Enter your choice:
3
BR0280I BRSPACE time stamp: 2020-01-29 14:10:11
BR0663I Your choice: '3'
-------------------------------------------------------------------------------
Options for extension of tablespace PSAPSR3 (1. file)
1 * Last added file name (lastfile) ....... [/oracle/<SID>/sapdata3/sr3_223/sr3.data223]
2 * Last added file size in MB (lastsize) . [10000]
3 - New file to be added (file) ........... [/oracle/<SID>/sapdata2/sr3_224/sr3.data224]
4 # Raw disk / link target (rawlink) ...... []
5 - Size of the new file in MB (size) ..... [10000]
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 PSAPSR3 add datafile '/oracle/<SID>/sapdata2/sr3_224/sr3.data224' size 10000M autoextend off]
Standard keys: c - cont, b - back, s - stop, r - refr
-------------------------------------------------------------------------------
BR0662I Enter your choice:
c
BR0280I BRSPACE time stamp: 2020-01-29 14:10:41
BR0663I Your choice: 'c'
BR0259I Program execution will be continued...
BR0370I Directory /oracle/<SID>/sapreorg/sfdadqyw created
BR0370I Directory /oracle/<SID>/sapdata2/sr3_224 created
BR1016I SQL statement 'alter tablespace PSAPSR3 add datafile '/oracle/<SID>/sapdata2/sr3_224/sr3.data224' size 10000M autoextend off' executed successfully
BR1051I Tablespace PSAPSR3 extended successfully with file(s): /oracle/<SID>/sapdata2/sr3_224/sr3.data224 10000M
No comments:
Post a Comment