Feeds:
Posts
Comments

Posts Tagged ‘drop tablespace’

Dear Friens back to my Oracle journey after long time. In our organisation I got the opportunity to work on SAP as well from Database point of issue.I want to make my blog as complete solution for BRtools.So again here I am coming with new post to drop tablespace in DB using the BRtools.

bash-3.00$ brtools
BR0651I BRTOOLS 7.20 (1)

BR0280I BRTOOLS time stamp: 2011-08-01 00.55.52
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: 2011-08-01 00.55.58
BR0663I Your choice: ‘2’

BR0280I BRTOOLS time stamp: 2011-08-01 00.55.58
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: 2011-08-01 00.56.01
BR0663I Your choice: ‘3’

BR0280I BRTOOLS time stamp: 2011-08-01 00.56.01
BR0657I Input menu 83 – please enter/check input values
——————————————————————————-
BRSPACE options for drop tablespace

 1 – BRSPACE profile (profile) …… [initSAM.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 initSAM.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: 2011-08-01 00.56.09
BR0663I Your choice: ‘3’
BR0681I Enter string value for “tablespace” []:
PSAPSR3SAM
BR0280I BRTOOLS time stamp: 2011-08-01 00.56.34
BR0683I New value for “tablespace”: ‘PSAPSR3SAM’

BR0280I BRTOOLS time stamp: 2011-08-01 00.56.34
BR0657I Input menu 83 – please enter/check input values
——————————————————————————-
BRSPACE options for drop tablespace

 1 – BRSPACE profile (profile) …… [initSAM.sap]
 2 – Database user/password (user) .. [/]
 3 ~ Tablespace name (tablespace) … [PSAPSR3SAM]
 4 – Confirmation mode (confirm) …. [yes]
 5 – Scrolling line count (scroll) .. [20]
 6 – Message language (language) …. [E]
 7 – BRSPACE command line (command) . [-p initSAM.sap -s 20 -l E -f tsdrop -t PSAPSR3SAM]

Standard keys: c – cont, b – back, s – stop, r – refr, h – help
——————————————————————————-
BR0662I Enter your choice:
c
BR0280I BRTOOLS time stamp: 2011-08-01 00.56.42
BR0663I Your choice: ‘c’
BR0259I Program execution will be continued…

BR0291I BRSPACE will be started with options ‘-p initSAM.sap -s 20 -l E -f tsdrop -t PSAPSR3SAM’

BR0280I BRTOOLS time stamp: 2011-08-01 00.56.42
BR0670I Enter ‘c[ont]’ to continue, ‘b[ack]’ to go back, ‘s[top]’ to abort:
c
BR0280I BRTOOLS time stamp: 2011-08-01 00.56.56
BR0257I Your reply: ‘c’
BR0259I Program execution will be continued…

###############################################################################

BR1001I BRSPACE 7.20 (1)
BR1002I Start of BRSPACE processing: segljgdc.tsd 2011-08-01 00.56.56
BR0484I BRSPACE log file: /oracle/SAM/sapreorg/segljgdc.tsd

BR0280I BRSPACE time stamp: 2011-08-01 00.56.56
BR1009I Name of database instance: SAM

BR1010I BRSPACE action ID: segljgdc
BR1011I BRSPACE function ID: tsd
BR1012I BRSPACE function: tsdrop

BR0280I BRSPACE time stamp: 2011-08-01 00.56.57
BR0657I Input menu 310 – please enter/check input values
——————————————————————————-
Options for dropping of tablespace PSAPSR3SAM

 1 * Number of files in tablespace (files) . [1]
 2 * Total tablespace size in MB (size) …. [500]
 3 – Force tablespace drop (force) ……… [no]
 4 – SQL command (command) …………….. [drop tablespace PSAPSR3SAM]

Standard keys: c – cont, b – back, s – stop, r – refr, h – help
——————————————————————————-
BR0662I Enter your choice:
c
BR0280I BRSPACE time stamp: 2011-08-01 00.57.08
BR0663I Your choice: ‘c’
BR0259I Program execution will be continued…

BR0280I BRSPACE time stamp: 2011-08-01 00.57.08
BR1070I Searching for segments in tablespace PSAPSR3SAM…
BR0285I This function can take several seconds/minutes – be patient…

BR0280I BRSPACE time stamp: 2011-08-01 00.57.08
BR1071I Tablespace PSAPSR3SAM is empty

BR0280I BRSPACE time stamp: 2011-08-01 00.57.08
BR0370I Directory /oracle/SAM/sapreorg/segljgdc created

BR0280I BRSPACE time stamp: 2011-08-01 00.57.09
BR0319I Control file copy created: /oracle/SAM/sapreorg/segljgdc/cntrlSAMold 13844480

BR0280I BRSPACE time stamp: 2011-08-01 00.57.10
BR0768I Tablespace PSAPSR3SAM set OFFLINE

BR0280I BRSPACE time stamp: 2011-08-01 00.57.10
BR1090I Dropping tablespace PSAPSR3SAM…

BR0280I BRSPACE time stamp: 2011-08-01 00.57.11
BR1016I SQL statement ‘drop tablespace PSAPSR3SAM’ executed successfully
BR1069I Tablespace PSAPSR3SAM dropped successfully

BR0280I BRSPACE time stamp: 2011-08-01 00.57.11
BR0794I Database file /oracle/SAM/sapdata4/sr3sam_1/sr3sam.data1 deleted
BR0480I Directory /oracle/SAM/sapdata4/sr3sam_1 deleted

BR0280I BRSPACE time stamp: 2011-08-01 00.57.11
BR0340I Switching to next online redolog file for database instance SAM…
BR0321I Switch to next online redolog file for database instance SAM successful

BR0280I BRSPACE time stamp: 2011-08-01 00.57.13
BR0319I Control file copy created: /oracle/SAM/sapreorg/segljgdc/cntrlSAM.new 13844480

BR0280I BRSPACE time stamp: 2011-08-01 00.57.13
BR0670I Enter ‘c[ont]’ to continue, ‘b[ack]’ to go back, ‘s[top]’ to abort:
c
BR0280I BRSPACE time stamp: 2011-08-01 00.57.19
BR0257I Your reply: ‘c’
BR0259I Program execution will be continued…

BR0280I BRSPACE time stamp: 2011-08-01 00.57.19
BR1020I Number of tablespaces processed: 1
BR1003I BRSPACE function ‘tsdrop’ completed

BR1008I End of BRSPACE processing: segljgdc.tsd 2011-08-01 00.57.19
BR0280I BRSPACE time stamp: 2011-08-01 00.57.19
BR1005I BRSPACE completed successfully

###############################################################################

BR0292I Execution of BRSPACE finished with return code 0

BR0280I BRTOOLS time stamp: 2011-08-01 00.57.19
BR0256I Enter ‘c[ont]’ to continue, ‘s[top]’ to cancel BRTOOLS:
c
BR0280I BRTOOLS time stamp: 2011-08-01 00.57.26
BR0257I Your reply: ‘c’
BR0259I Program execution will be continued…

BR0280I BRTOOLS time stamp: 2011-08-01 00.57.26
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:
s
BR0280I BRTOOLS time stamp: 2011-08-01 00.57.29
BR0663I Your choice: ‘s’
BR0679I Do you really want to cancel BRTOOLS? Enter y[es]/n[o]:
y
BR0280I BRTOOLS time stamp: 2011-08-01 00.57.31
BR0257I Your reply: ‘y’
BR0260E BRTOOLS cancelled by user

BR0280I BRTOOLS time stamp: 2011-08-01 00.57.31
BR0654I BRTOOLS terminated with errors
bash-3.00$

Advertisements

Read Full Post »