Excluindo tablespace via brtools
Referencia
http://help.sap.com/saphelp_nw70/helpdata/en/99/364d3f51a9995ee10000000a114084/content.htm
Solução
- Execute o comando no formato abaixo:
brspace -f tsdrop -t tablespace_nome
onde,
tablespace_nome = Nome da tablespace que se deseja excluir. Caso o nome da sua tablespace possua espaço, utilize aspas duplas.
Exemplo
maqtst:oratst 5> brspace -f tsdrop -t "PSAPCLUI ADD"
BR1001I BRSPACE 7.20 (34)
BR1002I Start of BRSPACE processing: semuadom.tsd 2013-12-18 13.45.40
BR0484I BRSPACE log file: /oracle/TST/sapreorg/semuadom.tsd
BR0280I BRSPACE time stamp: 2013-12-18 13.45.41
BR1009I Name of database instance: TST
BR1010I BRSPACE action ID: semuadom
BR1011I BRSPACE function ID: tsd
BR1012I BRSPACE function: tsdrop
BR0280I BRSPACE time stamp: 2013-12-18 13.45.42
BR0657I Input menu 310 - please enter/check input values
-------------------------------------------------------------------------------
Options for dropping of tablespace PSAPCLUI ADD
1 * Number of files in tablespace (files) . [1]
2 * Total tablespace size in MB (size) .... [40]
3 - Force tablespace drop (force) ......... [no]
4 - SQL command (command) ................. [drop tablespace PSAPCLUI ADD]
Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------
BR0662I Enter your choice:
c
BR0259I Program execution will be continued...
BR0280I BRSPACE time stamp: 2013-12-18 13.47.36
BR1090I Dropping tablespace PSAPCLUI ADD ...
BR0280I BRSPACE time stamp: 2013-12-18 13.47.36
BR1016I SQL statement 'drop tablespace "PSAPCLUI ADD"' executed successfully
BR1069I Tablespace PSAPCLUI ADD dropped successfully
BR0794I Database file /oracle/TST/sapdata1/clui_1/clui.data1 deleted
BR0480I Directory /oracle/TST/sapdata1/clui_1 deleted
BR1821I Table data class (tabart) handling will be executed now
BR0280I BRSPACE time stamp: 2013-12-18 13.47.36
BR0675I This is a recommended action - do you want to execute it now?
BR0676I Enter 'y[es]/c[ont]' to execute the action, 'n[o]' to skip it, 's[top]' to abort:
y
BR0280I BRSPACE time stamp: 2013-12-18 13.47.56
BR0257I Your reply: 'y'
BR0677I The action will be executed...
BR1822I Table data class (tabart) handling executed successfully
BR0280I BRSPACE time stamp: 2013-12-18 13.47.57
BR0340I Switching to the next online redolog file for database instance TST ...
BR0321I Switch to the next online redolog file for database instance TST successful
BR0280I BRSPACE time stamp: 2013-12-18 13.47.59
BR0319I Control file copy created: /oracle/TST/sapreorg/semuadom/cntrlTST.new 15056896
BR0280I BRSPACE time stamp: 2013-12-18 13.47.59
BR0256I Enter 'c[ont]' to continue, 's[top]' to cancel BRSPACE:
Abraços
Extend a tablespace via brtools
Problema
- Extend uma tablespace via brtools
Solução
- Faça login com o usuário ora<.sid>.
- Execute o comando brtools.
- Siga os passos abaixo.
maqtst:oratst 2> brtools
BR0651I BRTOOLS 7.20 (34)
BR0280I BRTOOLS time stamp: 2013-12-18 08.15.17
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: 2013-12-18 08.21.05
BR0663I Your choice: '2'
BR0280I BRTOOLS time stamp: 2013-12-18 08.21.05
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: 2013-12-18 08.21.13
BR0663I Your choice: '1'
BR0280I BRTOOLS time stamp: 2013-12-18 08.21.13
BR0657I Input menu 81 - please enter/check input values
-------------------------------------------------------------------------------
BRSPACE options for tablespace extension
1 - BRSPACE profile (profile) ...... [initTST.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 initTST.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: 2013-12-18 08.21.22
BR0663I Your choice: 'c'
BR0259I Program execution will be continued...
BR0291I BRSPACE will be started with options '-p initTST.sap -s 20 -l E -f tsextend'
BR0280I BRTOOLS time stamp: 2013-12-18 08.21.22
BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:
c
BR0280I BRTOOLS time stamp: 2013-12-18 08.22.24
BR0257I Your reply: 'c'
BR0259I Program execution will be continued...
###############################################################################
BR1001I BRSPACE 7.20 (34)
BR1002I Start of BRSPACE processing: semtzawm.tse 2013-12-18 08.22.24
BR0484I BRSPACE log file: /oracle/TST/sapreorg/semtzawm.tse
BR0280I BRSPACE time stamp: 2013-12-18 08.22.25
BR1009I Name of database instance: TST
BR1010I BRSPACE action ID: semtzawm
BR1011I BRSPACE function ID: tse
BR1012I BRSPACE function: tsextend
BR0280I BRSPACE time stamp: 2013-12-18 08.22.25
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:
1
BR0280I BRSPACE time stamp: 2013-12-18 08.22.42
BR0663I Your choice: '1'
BR0280I BRSPACE time stamp: 2013-12-18 08.22.43
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 - PSAPBTABD 3/0 9977856 40.75 5911808 9977856
2 - PSAPBTABI 2/0 5267456 52.02 2527488 5267456
3 - PSAPCLUD 2/0 302080 15.17 256256 302080
4 - PSAPCLUI 1/0 204800 6.91 190656 204800
5 - PSAPCLUI ADD 1/0 40960 0.16 40896 40960
6 - PSAPDDICD 3/0 8956928 29.72 6295040 8956928
7 - PSAPDDICI 3/0 4313088 29.25 3051328 4313088
8 - PSAPTST 10/0 15861760 0.00 15861120 15861760
9 - PSAPTST46C 9/0 13414400 0.00 13413824 13414400
10 - PSAPTSTUSR 1/0 20480 0.31 20416 20480
11 - PSAPDIMD 1/0 104448 0.12 104320 104448
12 - PSAPDIMI 1/0 104448 0.12 104320 104448
13 - PSAPDOCUD 1/0 204800 23.38 156928 204800
14 - PSAPDOCUI 1/0 276480 13.08 240320 276480
15 - PSAPEL702D 3/2 1801216 0.01 1801024 3107840
16 - PSAPEL702DX 1/0 6518784 51.55 3158144 6518784
17 - PSAPEL702I 1/0 1048576 0.01 1048512 1048576
18 - PSAPEL702IX 1/0 2099200 0.56 2087360 2099200
19 - PSAPES702D 2/0 35622912 0.00 35622784 35622912
20 - PSAPES702DX 2/0 23173120 75.11 5767616 23173120
Press <Rtn> - scroll, <n> - select, c - cont, s - skip, b - back, h - header
c
21 - PSAPES702I 2/0 21060608 0.00 21060480 21060608
22 - PSAPES702IX 1/0 14927872 75.09 3717888 14927872
23 - PSAPFACTD 1/0 104448 0.18 104256 104448
24 - PSAPFACTI 1/0 104448 0.31 104128 104448
25 - PSAPLOADD 3/0 2244608 2.99 2177536 2244608
26 - PSAPLOADI 2/0 1316864 0.54 1309696 1316864
27 - PSAPODSD 1/0 114688 0.33 114304 114688
28 - PSAPODSI 1/0 114688 0.45 114176 114688
29 - PSAPPOOLD 4/0 12429312 67.92 3987072 12429312
30 - PSAPPOOLI 4/0 9472000 63.48 3458816 9472000
31 - PSAPPROTD 4/0 1476608 12.25 1295744 1476608
32 - PSAPPROTI 3/0 489472 19.61 393472 489472
33 - PSAPSOURCED 4/0 950272 60.96 371008 950272
34 - PSAPSOURCEI 4/0 2096128 61.25 812224 2096128
35 - PSAPSR3USR 1/0 1048576 0.02 1048320 1048576
36 - PSAPSTABD 4/0 10102784 57.57 4286464 10102784
37 - PSAPSTABI 3/0 10244096 61.94 3898624 10244096
38 - PSAPSTAI 1/0 2560000 0.00 2559936 2560000
39 - PSAPTEMP 1/0 3072000 0.00 3072000 3072000
40 - PSAPUNDO 2/0 7954432 0.00 7954304 7954432
41 - PSAPUSER1D 1/0 102400 1.81 100544 102400
42 - PSAPUSER1I 1/0 204800 0.94 202880 204800
43 - SYSAUX 2/0 1126400 95.27 53248 1126400
44 - SYSTEM 3/1 1996800 76.44 470400 3686400
Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------
BR0662I Enter your selection:
43
BR0280I BRSPACE time stamp: 2013-12-18 08.23.20
BR0663I Your selection: '43'
BR0280I BRSPACE time stamp: 2013-12-18 08.23.20
BR0657I Input menu 303 - please enter/check input values
-------------------------------------------------------------------------------
Options for extension of tablespace SYSAUX (1. file)
1 * Last added file name (lastfile) ....... [/oracle/TST/sapdata2/system_4/sysaux04.dbf]
2 * Last added file size in MB (lastsize) . [1000]
3 - New file to be added (file) ........... [/oracle/TST/sapdata2/system_5/sysaux04.dbf]
4 ~ Raw disk / link target (rawlink) ...... []
5 - Size of the new file in MB (size) ..... [1000]
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 SYSAUX add datafile '/oracle/TST/sapdata2/system_5/sysaux04.dbf' size 1000M autoextend off]
Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------
BR0662I Enter your choice:
3
BR0280I BRSPACE time stamp: 2013-12-18 08.24.55
BR0663I Your choice: '3'
BR0681I Enter string value for "file" (<file>|<sapdata>|<N>) [/oracle/TST/sapdata2/system_5/sysaux04.dbf]:
/oracle/TST/sapdata2/system_5/sysaux05.dbf
BR0280I BRSPACE time stamp: 2013-12-18 08.25.02
BR0683I New value for "file": '/oracle/TST/sapdata2/system_5/sysaux05.dbf'
BR0280I BRSPACE time stamp: 2013-12-18 08.25.02
BR0657I Input menu 303 - please enter/check input values
-------------------------------------------------------------------------------
Options for extension of tablespace SYSAUX (1. file)
1 * Last added file name (lastfile) ....... [/oracle/TST/sapdata2/system_4/sysaux04.dbf]
2 * Last added file size in MB (lastsize) . [1000]
3 - New file to be added (file) ........... [/oracle/TST/sapdata2/system_5/sysaux05.dbf]
4 ~ Raw disk / link target (rawlink) ...... []
5 - Size of the new file in MB (size) ..... [1000]
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 SYSAUX add datafile '/oracle/TST/sapdata2/system_5/sysaux05.dbf' size 1000M autoextend off]
Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------
BR0662I Enter your choice:
c
BR0280I BRSPACE time stamp: 2013-12-18 08.25.21
BR0663I Your choice: 'c'
BR0259I Program execution will be continued...
BR1091I Next data file can be specified now
BR0280I BRSPACE time stamp: 2013-12-18 08.25.21
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:
n
BR0280I BRSPACE time stamp: 2013-12-18 08.25.42
BR0257I Your reply: 'n'
BR0678I The action will be skipped...
BR0370I Directory /oracle/TST/sapreorg/semtzawm created
BR0280I BRSPACE time stamp: 2013-12-18 08.25.43
BR0319I Control file copy created: /oracle/TST/sapreorg/semtzawm/cntrlTST.old 15056896
BR0370I Directory /oracle/TST/sapdata2/system_5 created
BR0280I BRSPACE time stamp: 2013-12-18 08.25.43
BR1088I Extending tablespace SYSAUX ...
BR0280I BRSPACE time stamp: 2013-12-18 08.26.27
BR1016I SQL statement 'alter tablespace SYSAUX add datafile '/oracle/TST/sapdata2/system_5/sysaux05.dbf' size 1000M autoextend off' executed successfully
BR1051I Tablespace SYSAUX extended successfully with file: /oracle/TST/sapdata2/system_5/sysaux05.dbf 1000M
BR0280I BRSPACE time stamp: 2013-12-18 08.26.27
BR0340I Switching to the next online redolog file for database instance TST ...
BR0321I Switch to the next online redolog file for database instance TST successful
BR0280I BRSPACE time stamp: 2013-12-18 08.26.29
BR0319I Control file copy created: /oracle/TST/sapreorg/semtzawm/cntrlTST.new 15056896
BR0280I BRSPACE time stamp: 2013-12-18 08.26.29
BR0256I Enter 'c[ont]' to continue, 's[top]' to cancel BRSPACE:
Abraços
Modificando a SYSAUX após ajuste de retenção AWR
Problema
- Após o ajuste de retenção do AWR indicado no post Increasing AWR Retention, percebemos que o espaço livre na tablespace SYSAUX diminuiu.
Solução
- Faça um extend na tablespace SYSAUX via brtools.
Internal error CREATE_TEMPLATE in CL_W3_TEMPLATE->ADD - W3_TOOL001
Problema
Internal
error CREATE_TEMPLATE in CL_W3_TEMPLATE->ADD; inform person
responsible
Message no. W3_TOOL001
responsible
Message no. W3_TOOL001
Referencia
Solução
- Execute a transação SIAC_PUBLISH_ALL_INT
Setando caracteres por linha no sqlplus
Referencia
http://docs.oracle.com/cd/B19306_01/server.102/b14357/ch12040.htm#i2678481
Sintaxe
SET LIN[ESIZE] {80 | n} SET LIN[ESIZE] {150 | n}
Explicação
- Configura o número total de caracteres que o SQL Plus exibe em uma linha antes de começar uma nova.
Exemplo
- Exibindo as informações sobre tablespaces.
TABLESPACE TOTAL_SPACE FREE_SPACE TOTAL_SPACE_MB
------------------------------ ----------- ---------- --------------
USED_SPACE_MB FREE_SPACE_MB PCT_FREE
------------- ------------- ----------
SYSAUX 1384120320 458293248 1320
883 437 33.11
SYSTEM 3135242240 1517944832 2990
1542 1448 48.42
- Executando o comando set linesize antes:
TABLESPACE TOTAL_SPACE FREE_SPACE TOTAL_SPACE_MB USED_SPACE_MB FREE_SPACE_MB PCT_FREE
------------------------------ ----------- ---------- -------------- ------------- ------------- ----------
SYSAUX 1384120320 458293248 1320 883 437 33.11
SYSTEM 3135242240 1517944832 2990 1542 1448 48.42
ABAP - Setando o Foco em um campo
Referencia
http://scn.sap.com/thread/621726
Sintaxe
SET CURSOR { { FIELD field [LINE line] [[DISPLAY] OFFSET off] }
| { col lin } }.
Explicação
- Por exemplo, caso sua tela tenha três campos e com seus respectivos nomes name, address e cell. Queremos colocar o foco no campo address, podemos fazer:
SET CURSOR FIELD 'ADDRESS'.
Type of role XXXXXX is undetermined
Problema
Type
of role XXXXXX is undetermined
Message no. S#431
Diagnosis
The type of the role XXXXXX
is undetermined, since there is no entry for the type COLL_AGR for this role in
the table AGR_FLAGS.
System
Response
The operation cannot
be performed for this role.
Procedure
Enter the missing
type indicator for this and all other affected roles in accordance with the
instructions in SAP Note 770358, then repeat the process.
Solução
- Aplique a
nota 770358.
Postagens
