SQL> select tablespace_name, status, count(*) from dba_rollback_segs group by tablespace_name, status;
TABLESPACE_NAME STATUS COUNT(*)
------------------------------ ---------------- ----------
PSAPUNDO OFFLINE 406
SYSTEM ONLINE 1
PSAPUNDO2 ONLINE 321
SYSTEM OFFLINE 1
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Linux_server>:oraORA_DB 25> ps -ef |grep tns
oraORA_DB 14773 11460 1 10:02:36 pts/1 0:00 grep tns
Linux_server>:oraORA_DB 26> brtools
BR0651I BRTOOLS 7.20 (42)
BR0280I BRTOOLS time stamp: 2021-07-30 10.03.00
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: 2021-07-30 10.03.14
BR0663I Your choice: '2'
BR0280I BRTOOLS time stamp: 2021-07-30 10.03.14
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: 2021-07-30 10.03.27
BR0663I Your choice: '3'
BR0280I BRTOOLS time stamp: 2021-07-30 10.03.27
BR0657I Input menu 83 - please enter/check input values
-------------------------------------------------------------------------------
BRSPACE options for drop tablespace
1 - BRSPACE profile (profile) ...... [initORA_DB.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 initORA_DB.sap -s 20 -l E -f tsdrop]
Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------
BR0662I Enter your choice:
PSAPUNDO
BR0280I BRTOOLS time stamp: 2021-07-30 10.03.49
BR0664W Invalid choice: 'PSAPUNDO'
BR0662I Enter your choice:
3
BR0280I BRTOOLS time stamp: 2021-07-30 10.03.56
BR0663I Your choice: '3'
BR0681I Enter string value for "tablespace" []:
PSAPUNDO
BR0280I BRTOOLS time stamp: 2021-07-30 10.03.59
BR0683I New value for "tablespace": 'PSAPUNDO'
BR0280I BRTOOLS time stamp: 2021-07-30 10.03.59
BR0657I Input menu 83 - please enter/check input values
-------------------------------------------------------------------------------
BRSPACE options for drop tablespace
1 - BRSPACE profile (profile) ...... [initORA_DB.sap]
2 - Database user/password (user) .. [/]
3 ~ Tablespace name (tablespace) ... [PSAPUNDO]
4 - Confirmation mode (confirm) .... [yes]
5 - Scrolling line count (scroll) .. [20]
6 - Message language (language) .... [E]
7 - BRSPACE command line (command) . [-p initORA_DB.sap -s 20 -l E -f tsdrop -t PSAPUNDO]
Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------
BR0662I Enter your choice:
4
BR0280I BRTOOLS time stamp: 2021-07-30 10.04.30
BR0663I Your choice: '4'
BR0681I Enter string value for "confirm" (yes|no|force) [yes]:
no
BR0280I BRTOOLS time stamp: 2021-07-30 10.05.54
BR0683I New value for "confirm": 'no'
BR0280I BRTOOLS time stamp: 2021-07-30 10.05.54
BR0657I Input menu 83 - please enter/check input values
-------------------------------------------------------------------------------
BRSPACE options for drop tablespace
1 - BRSPACE profile (profile) ...... [initORA_DB.sap]
2 - Database user/password (user) .. [/]
3 ~ Tablespace name (tablespace) ... [PSAPUNDO]
4 - Confirmation mode (confirm) .... [no]
5 - Scrolling line count (scroll) .. [20]
6 - Message language (language) .... [E]
7 - BRSPACE command line (command) . [-p initORA_DB.sap -c -s 20 -l E -f tsdrop -t PSAPUNDO]
Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------
BR0662I Enter your choice:
c
BR0280I BRTOOLS time stamp: 2021-07-30 10.05.59
BR0663I Your choice: 'c'
BR0259I Program execution will be continued...
BR0291I BRSPACE will be started with options '-p initORA_DB.sap -c -s 20 -l E -f tsdrop -t PSAPUNDO'
BR0280I BRTOOLS time stamp: 2021-07-30 10.05.59
BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:
c
BR0280I BRTOOLS time stamp: 2021-07-30 10.06.02
BR0257I Your reply: 'c'
BR0259I Program execution will be continued...
###############################################################################
BR1001I BRSPACE 7.20 (42)
BR1002I Start of BRSPACE processing: sfgzuvlz.tsd 2021-07-30 10.06.03
BR0484I BRSPACE log file: /oracle/ORA_DB/sapreorg/sfgzuvlz.tsd
BR0280I BRSPACE time stamp: 2021-07-30 10.06.13
BR1009I Name of database instance: ORA_DB
BR1010I BRSPACE action ID: sfgzuvlz
BR1011I BRSPACE function ID: tsd
BR1012I BRSPACE function: tsdrop
BR0126I Unattended mode active - no operator confirmation required
BR0280I BRSPACE time stamp: 2021-07-30 10.06.51
BR0657I Input menu 310 - please enter/check input values
-------------------------------------------------------------------------------
Options for dropping of tablespace PSAPUNDO
1 * Number of files in tablespace (files) . [12]
2 * Total tablespace size in MB (size) .... [266480]
3 - Force tablespace drop (force) ......... [no]
4 - SQL command (command) ................. [drop tablespace PSAPUNDO]
Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------
BR0662I Enter your choice:
c
BR0280I BRSPACE time stamp: 2021-07-30 10.07.49
BR0663I Your choice: 'c'
BR0259I Program execution will be continued...
BR0370I Directory /oracle/ORA_DB/sapreorg/sfgzuvlz created
BR0280I BRSPACE time stamp: 2021-07-30 10.07.58
BR0319I Control file copy created: /oracle/ORA_DB/sapreorg/sfgzuvlz/cntrlORA_DB.old 133906432
BR0280I BRSPACE time stamp: 2021-07-30 10.08.11
BR0768I Tablespace PSAPUNDO set OFFLINE
BR0280I BRSPACE time stamp: 2021-07-30 10.08.11
BR1090I Dropping tablespace PSAPUNDO ...
BR0280I BRSPACE time stamp: 2021-07-30 10.08.28
BR1016I SQL statement 'drop tablespace PSAPUNDO' executed successfully
BR1069I Tablespace PSAPUNDO dropped successfully
BR0794I Database file /oracle/ORA_DB/sapdata888/undo_1/undo.data1 deleted
BR0480I Directory /oracle/ORA_DB/sapdata888/undo_1 deleted
BR0794I Database file /oracle/ORA_DB/sapdata888/undo_2/undo.data2 deleted
BR0480I Directory /oracle/ORA_DB/sapdata888/undo_2 deleted
BR0794I Database file /oracle/ORA_DB/sapdata888/undo_3/undo.data3 deleted
BR0480I Directory /oracle/ORA_DB/sapdata888/undo_3 deleted
BR0794I Database file /oracle/ORA_DB/sapdata888/undo_4/undo.data4 deleted
BR0480I Directory /oracle/ORA_DB/sapdata888/undo_4 deleted
BR0794I Database file /oracle/ORA_DB/sapdata888/undo_5/undo.data5 deleted
BR0480I Directory /oracle/ORA_DB/sapdata888/undo_5 deleted
BR0794I Database file /oracle/ORA_DB/sapdata888/undo_6/undo.data6 deleted
BR0480I Directory /oracle/ORA_DB/sapdata888/undo_6 deleted
BR0794I Database file /oracle/ORA_DB/sapdata888/undo_7/undo.data7 deleted
BR0480I Directory /oracle/ORA_DB/sapdata888/undo_7 deleted
BR0794I Database file /oracle/ORA_DB/sapdata888/undo_8/undo.data8 deleted
BR0480I Directory /oracle/ORA_DB/sapdata888/undo_8 deleted
BR0794I Database file /oracle/ORA_DB/sapdata888/undo_9/undo.data9 deleted
BR0480I Directory /oracle/ORA_DB/sapdata888/undo_9 deleted
BR0794I Database file /oracle/ORA_DB/sapdata888/undo_10/undo.data10 deleted
BR0480I Directory /oracle/ORA_DB/sapdata888/undo_10 deleted
BR0794I Database file /oracle/ORA_DB/sapdata888/undo_11/undo.data11 deleted
BR0252W Function rmdir() failed for '/oracle/ORA_DB/sapdata888/undo_11' at location BrDirDelete-5
BR0253W errno 17: File exists
BR0794I Database file /oracle/ORA_DB/sapdata888/undo_12/undo.data12 deleted
BR0480I Directory /oracle/ORA_DB/sapdata888/undo_12 deleted
BR0280I BRSPACE time stamp: 2021-07-30 10.08.28
BR0340I Switching to the next online redolog file for database instance ORA_DB ...
BR0321I Switch to the next online redolog file for database instance ORA_DB successful
BR0280I BRSPACE time stamp: 2021-07-30 10.08.36
BR0319I Control file copy created: /oracle/ORA_DB/sapreorg/sfgzuvlz/cntrlORA_DB.new 133906432
BR0280I BRSPACE time stamp: 2021-07-30 10.08.36
BR1020I Number of tablespaces processed: 1
BR1003I BRSPACE function 'tsdrop' completed
BR1008I End of BRSPACE processing: sfgzuvlz.tsd 2021-07-30 10.08.36
BR0280I BRSPACE time stamp: 2021-07-30 10.08.37
BR1006I BRSPACE completed successfully with warnings
###############################################################################
BR0292I Execution of BRSPACE finished with return code 1
BR0280I BRTOOLS time stamp: 2021-07-30 10.08.37
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:
s
BR0280I BRTOOLS time stamp: 2021-07-30 10.08.53
BR0257I Your reply: 's'
BR0679I Do you really want to cancel BRTOOLS? Enter y[es]/n[o]:
y
BR0280I BRTOOLS time stamp: 2021-07-30 10.08.55
BR0257I Your reply: 'y'
BR0260E BRTOOLS cancelled by user
BR0280I BRTOOLS time stamp: 2021-07-30 10.08.55
BR0654I BRTOOLS terminated with errors
No comments:
Post a Comment