SERVER_NAME:oraTEST 10> brtools
BR0651I BRTOOLS 7.00 (32)
BR0280I BRTOOLS time stamp: 2016-05-04 14.07.09
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: 2016-05-04 14.07.10
BR0663I Your choice: '2'
BR0280I BRTOOLS time stamp: 2016-05-04 14.07.10
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:
3
BR0280I BRTOOLS time stamp: 2016-05-04 14.07.17
BR0663I Your choice: '3'
BR0280I BRTOOLS time stamp: 2016-05-04 14.07.17
BR0657I Input menu 83 - please check/enter input values
-------------------------------------------------------------------------------
BRSPACE options for drop tablespace
1 - BRSPACE profile (profile) ...... [initTEST.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 initTEST.sap -s 20 -l E -f tsdrop]
Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------
BR0662I Enter your choice:
3
BR0280I BRTOOLS time stamp: 2016-05-04 14.07.19
BR0663I Your choice: '3'
BR0280I BRTOOLS time stamp: 2016-05-04 14.07.19
BR0681I Enter string value for "tablespace" []:
PSAPTEST
BR0280I BRTOOLS time stamp: 2016-05-04 14.07.24
BR0683I New value for "tablespace": 'PSAPTEST'
BR0280I BRTOOLS time stamp: 2016-05-04 14.07.24
BR0657I Input menu 83 - please check/enter input values
-------------------------------------------------------------------------------
BRSPACE options for drop tablespace
1 - BRSPACE profile (profile) ...... [initTEST.sap]
2 - Database user/password (user) .. [/]
3 ~ Tablespace name (tablespace) ... [PSAPTEST]
4 - Confirmation mode (confirm) .... [yes]
5 - Scrolling line count (scroll) .. [20]
6 - Message language (language) .... [E]
7 - BRSPACE command line (command) . [-p initTEST.sap -s 20 -l E -f tsdrop -t PSAPTEST]
Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------
BR0662I Enter your choice:
4
BR0280I BRTOOLS time stamp: 2016-05-04 14.07.39
BR0663I Your choice: '4'
BR0280I BRTOOLS time stamp: 2016-05-04 14.07.39
BR0681I Enter string value for "confirm" (yes|no|force) [yes]:
BR0280I BRTOOLS time stamp: 2016-05-04 14.07.58
BR0683I New value for "confirm": 'no'
BR0280I BRTOOLS time stamp: 2016-05-04 14.07.58
BR0657I Input menu 83 - please check/enter input values
-------------------------------------------------------------------------------
BRSPACE options for drop tablespace
1 - BRSPACE profile (profile) ...... [initTEST.sap]
2 - Database user/password (user) .. [/]
3 ~ Tablespace name (tablespace) ... [PSAPTEST]
4 - Confirmation mode (confirm) .... [no]
5 - Scrolling line count (scroll) .. [20]
6 - Message language (language) .... [E]
7 - BRSPACE command line (command) . [-p initTEST.sap -c -s 20 -l E -f tsdrop -t PSAPTEST]
Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------
BR0662I Enter your choice:
c
BR0280I BRTOOLS time stamp: 2016-05-04 14.08.05
BR0663I Your choice: 'c'
BR0259I Program execution will be continued...
BR0291I BRSPACE will be started with options '-p initTEST.sap -c -s 20 -l E -f tsdrop -t PSAPTEST'
BR0280I BRTOOLS time stamp: 2016-05-04 14.08.05
BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:
c
BR0280I BRTOOLS time stamp: 2016-05-04 14.08.17
BR0257I Your reply: 'c'
BR0259I Program execution will be continued...
###############################################################################
BR1001I BRSPACE 7.00 (32)
BR1002I Start of BRSPACE processing: setcdtev.tsd 2016-05-04 14.08.17
BR0484I BRSPACE log file: /oracle/TEST/sapreorg/setcdtev.tsd
BR0280I BRSPACE time stamp: 2016-05-04 14.08.17
BR1009I Name of database instance: TEST
BR1010I BRSPACE action ID: setcdtev
BR1011I BRSPACE function ID: tsd
BR1012I BRSPACE function: tsdrop
BR0126I Unattended mode active - no operator confirmation required
BR0280I BRSPACE time stamp: 2016-05-04 14.08.17
BR0657I Input menu 310 - please check/enter input values
-------------------------------------------------------------------------------
Options for dropping of tablespace PSAPTEST
1 * Number of files in tablespace (files) . [1]
2 * Total tablespace size in MB (size) .... [100]
3 - Force tablespace drop (force) ......... [no]
4 - SQL command (command) ................. [drop tablespace PSAPTEST]
Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------
BR0662I Enter your choice:
c
BR0280I BRSPACE time stamp: 2016-05-04 14.08.41
BR0663I Your choice: 'c'
BR0259I Program execution will be continued...
BR0280I BRSPACE time stamp: 2016-05-04 14.08.42
BR1070I Searching for segments in tablespace PSAPTEST...
BR0285I This function can take several seconds/minutes - be patient...
BR0280I BRSPACE time stamp: 2016-05-04 14.08.42
BR1071I Tablespace PSAPTEST is empty
BR0280I BRSPACE time stamp: 2016-05-04 14.08.42
BR0370I Directory /oracle/TEST/sapreorg/setcdtev created
BR0280I BRSPACE time stamp: 2016-05-04 14.08.42
BR0319I Control file copy created: /oracle/TEST/sapreorg/setcdtev/cntrlTEST.old 16302080
BR0280I BRSPACE time stamp: 2016-05-04 14.08.42
BR0768I Tablespace PSAPTEST set OFFLINE
BR0280I BRSPACE time stamp: 2016-05-04 14.08.42
BR1090I Dropping tablespace PSAPTEST...
BR0280I BRSPACE time stamp: 2016-05-04 14.08.42
BR1016I SQL statement 'drop tablespace PSAPTEST' executed successfully
BR1069I Tablespace PSAPTEST dropped successfully
BR0280I BRSPACE time stamp: 2016-05-04 14.08.42
BR0794I Database file /oracle/TEST/sapdata3/test_1/test.data1 deleted
BR0480I Directory /oracle/TEST/sapdata3/test_1 deleted
BR0280I BRSPACE time stamp: 2016-05-04 14.08.42
BR0340I Switching to next online redo log file for database instance TEST ...
BR0321I Switch to next online redo log file for database instance TEST successful
BR0280I BRSPACE time stamp: 2016-05-04 14.08.42
BR0319I Control file copy created: /oracle/TEST/sapreorg/setcdtev/cntrlTEST.new 16302080
BR0280I BRSPACE time stamp: 2016-05-04 14.08.42
BR1020I Number of tablespaces processed: 1
BR1003I BRSPACE function 'tsdrop' completed
BR1008I End of BRSPACE processing: setcdtev.tsd 2016-05-04 14.08.42
BR0280I BRSPACE time stamp: 2016-05-04 14.08.42
BR1005I BRSPACE completed successfully
###############################################################################
BR0292I Execution of BRSPACE finished with return code 0
BR0280I BRTOOLS time stamp: 2016-05-04 14.08.42
BR0256I Enter 'c[ont]' to continue, 's[top]' to cancel BRTOOLS:
s
BR0280I BRTOOLS time stamp: 2016-05-04 14.09.04
BR0257I Your reply: 's'
BR0679I Do you really want to cancel BRTOOLS? Enter y[es]/n[o]:
y
BR0280I BRTOOLS time stamp: 2016-05-04 14.09.06
BR0257I Your reply: 'y'
BR0260E BRTOOLS cancelled by user
BR0280I BRTOOLS time stamp: 2016-05-04 14.09.06
BR0654I BRTOOLS terminated with errors
BR0651I BRTOOLS 7.00 (32)
BR0280I BRTOOLS time stamp: 2016-05-04 14.07.09
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: 2016-05-04 14.07.10
BR0663I Your choice: '2'
BR0280I BRTOOLS time stamp: 2016-05-04 14.07.10
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:
3
BR0280I BRTOOLS time stamp: 2016-05-04 14.07.17
BR0663I Your choice: '3'
BR0280I BRTOOLS time stamp: 2016-05-04 14.07.17
BR0657I Input menu 83 - please check/enter input values
-------------------------------------------------------------------------------
BRSPACE options for drop tablespace
1 - BRSPACE profile (profile) ...... [initTEST.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 initTEST.sap -s 20 -l E -f tsdrop]
Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------
BR0662I Enter your choice:
3
BR0280I BRTOOLS time stamp: 2016-05-04 14.07.19
BR0663I Your choice: '3'
BR0280I BRTOOLS time stamp: 2016-05-04 14.07.19
BR0681I Enter string value for "tablespace" []:
PSAPTEST
BR0280I BRTOOLS time stamp: 2016-05-04 14.07.24
BR0683I New value for "tablespace": 'PSAPTEST'
BR0280I BRTOOLS time stamp: 2016-05-04 14.07.24
BR0657I Input menu 83 - please check/enter input values
-------------------------------------------------------------------------------
BRSPACE options for drop tablespace
1 - BRSPACE profile (profile) ...... [initTEST.sap]
2 - Database user/password (user) .. [/]
3 ~ Tablespace name (tablespace) ... [PSAPTEST]
4 - Confirmation mode (confirm) .... [yes]
5 - Scrolling line count (scroll) .. [20]
6 - Message language (language) .... [E]
7 - BRSPACE command line (command) . [-p initTEST.sap -s 20 -l E -f tsdrop -t PSAPTEST]
Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------
BR0662I Enter your choice:
4
BR0280I BRTOOLS time stamp: 2016-05-04 14.07.39
BR0663I Your choice: '4'
BR0280I BRTOOLS time stamp: 2016-05-04 14.07.39
BR0681I Enter string value for "confirm" (yes|no|force) [yes]:
BR0280I BRTOOLS time stamp: 2016-05-04 14.07.58
BR0683I New value for "confirm": 'no'
BR0280I BRTOOLS time stamp: 2016-05-04 14.07.58
BR0657I Input menu 83 - please check/enter input values
-------------------------------------------------------------------------------
BRSPACE options for drop tablespace
1 - BRSPACE profile (profile) ...... [initTEST.sap]
2 - Database user/password (user) .. [/]
3 ~ Tablespace name (tablespace) ... [PSAPTEST]
4 - Confirmation mode (confirm) .... [no]
5 - Scrolling line count (scroll) .. [20]
6 - Message language (language) .... [E]
7 - BRSPACE command line (command) . [-p initTEST.sap -c -s 20 -l E -f tsdrop -t PSAPTEST]
Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------
BR0662I Enter your choice:
c
BR0280I BRTOOLS time stamp: 2016-05-04 14.08.05
BR0663I Your choice: 'c'
BR0259I Program execution will be continued...
BR0291I BRSPACE will be started with options '-p initTEST.sap -c -s 20 -l E -f tsdrop -t PSAPTEST'
BR0280I BRTOOLS time stamp: 2016-05-04 14.08.05
BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:
c
BR0280I BRTOOLS time stamp: 2016-05-04 14.08.17
BR0257I Your reply: 'c'
BR0259I Program execution will be continued...
###############################################################################
BR1001I BRSPACE 7.00 (32)
BR1002I Start of BRSPACE processing: setcdtev.tsd 2016-05-04 14.08.17
BR0484I BRSPACE log file: /oracle/TEST/sapreorg/setcdtev.tsd
BR0280I BRSPACE time stamp: 2016-05-04 14.08.17
BR1009I Name of database instance: TEST
BR1010I BRSPACE action ID: setcdtev
BR1011I BRSPACE function ID: tsd
BR1012I BRSPACE function: tsdrop
BR0126I Unattended mode active - no operator confirmation required
BR0280I BRSPACE time stamp: 2016-05-04 14.08.17
BR0657I Input menu 310 - please check/enter input values
-------------------------------------------------------------------------------
Options for dropping of tablespace PSAPTEST
1 * Number of files in tablespace (files) . [1]
2 * Total tablespace size in MB (size) .... [100]
3 - Force tablespace drop (force) ......... [no]
4 - SQL command (command) ................. [drop tablespace PSAPTEST]
Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------
BR0662I Enter your choice:
c
BR0280I BRSPACE time stamp: 2016-05-04 14.08.41
BR0663I Your choice: 'c'
BR0259I Program execution will be continued...
BR0280I BRSPACE time stamp: 2016-05-04 14.08.42
BR1070I Searching for segments in tablespace PSAPTEST...
BR0285I This function can take several seconds/minutes - be patient...
BR0280I BRSPACE time stamp: 2016-05-04 14.08.42
BR1071I Tablespace PSAPTEST is empty
BR0280I BRSPACE time stamp: 2016-05-04 14.08.42
BR0370I Directory /oracle/TEST/sapreorg/setcdtev created
BR0280I BRSPACE time stamp: 2016-05-04 14.08.42
BR0319I Control file copy created: /oracle/TEST/sapreorg/setcdtev/cntrlTEST.old 16302080
BR0280I BRSPACE time stamp: 2016-05-04 14.08.42
BR0768I Tablespace PSAPTEST set OFFLINE
BR0280I BRSPACE time stamp: 2016-05-04 14.08.42
BR1090I Dropping tablespace PSAPTEST...
BR0280I BRSPACE time stamp: 2016-05-04 14.08.42
BR1016I SQL statement 'drop tablespace PSAPTEST' executed successfully
BR1069I Tablespace PSAPTEST dropped successfully
BR0280I BRSPACE time stamp: 2016-05-04 14.08.42
BR0794I Database file /oracle/TEST/sapdata3/test_1/test.data1 deleted
BR0480I Directory /oracle/TEST/sapdata3/test_1 deleted
BR0280I BRSPACE time stamp: 2016-05-04 14.08.42
BR0340I Switching to next online redo log file for database instance TEST ...
BR0321I Switch to next online redo log file for database instance TEST successful
BR0280I BRSPACE time stamp: 2016-05-04 14.08.42
BR0319I Control file copy created: /oracle/TEST/sapreorg/setcdtev/cntrlTEST.new 16302080
BR0280I BRSPACE time stamp: 2016-05-04 14.08.42
BR1020I Number of tablespaces processed: 1
BR1003I BRSPACE function 'tsdrop' completed
BR1008I End of BRSPACE processing: setcdtev.tsd 2016-05-04 14.08.42
BR0280I BRSPACE time stamp: 2016-05-04 14.08.42
BR1005I BRSPACE completed successfully
###############################################################################
BR0292I Execution of BRSPACE finished with return code 0
BR0280I BRTOOLS time stamp: 2016-05-04 14.08.42
BR0256I Enter 'c[ont]' to continue, 's[top]' to cancel BRTOOLS:
s
BR0280I BRTOOLS time stamp: 2016-05-04 14.09.04
BR0257I Your reply: 's'
BR0679I Do you really want to cancel BRTOOLS? Enter y[es]/n[o]:
y
BR0280I BRTOOLS time stamp: 2016-05-04 14.09.06
BR0257I Your reply: 'y'
BR0260E BRTOOLS cancelled by user
BR0280I BRTOOLS time stamp: 2016-05-04 14.09.06
BR0654I BRTOOLS terminated with errors
No comments:
Post a Comment