http://help.sap.com/saphelp_srm30/helpdata/en/15/c9df3b6ac34b44e10000000a114084/content.htm
http://help.sap.com/SAPHELP_NW04S/helpdata/EN/43/f0ed9f81917063e10000000a1553f6/content.htm
SAP Data Archiving - References
http://help.sap.com/saphelp_srm30/helpdata/en/15/c9df3b6ac34b44e10000000a114084/content.htm
http://help.sap.com/SAPHELP_NW04S/helpdata/EN/43/f0ed9f81917063e10000000a1553f6/content.htm
Aplicação de Technical Level
Before you begin
the installation of this package, please note the following:
1.
You must be logged in as the root user to install this package.
2.
IBM recommends creating a system backup
before starting the installation procedure.
3.
The latest AIX installation hints and tips
for your version of AIX are available from the IBM Subscription service for
Unix and Linux web site:
These tips
contain important information that should be reviewed before installing this
update.
4.
IBM recommends creating a separate file system for/usr/sys/inst.images for the following reasons:
o
Downloaded fix packages require a
significant amount of disk space.
o
By creating a separate file system, you
prevent the expansion of the/usr file
system.
|
Follow
these steps to install the update package:
1.
Always run the inutoc command to ensure the installation
subsystem will recognize the new fix packages you download. This command
creates a new .toc file for the fix
package. Run the inutoc command
in the same directory where you downloaded the package filesets. For example,
if you downloaded the filesets to /usr/sys/inst.images,
run the following command:
inutoc /usr/sys/inst.images
(Optional):
Renaming the *.bff files is not necessary, but does help you see which
filesets are affected by the downloaded files. To rename the downloaded files
to their fileset name, run the bffcreate command.
After renaming the files, run the inutoc command
again. For example, if you downloaded the filesets to /usr/sys/inst.images,
run the following command to rename them:
bffcreate -c -d /usr/sys/inst.images
2. For all updates
To install
all updates from this package that apply to the installed filesets on your
system, use the following command:
smit update_all
It is
highly recommended that you apply all updates from this package.
3.
Reboot the system. A reboot
is required for this update to take effect.
|
You may
wish to retain this package for future use. When you install additional
operating system software you will want to use this package to bring the
additional software up to this level.
You can
create a list of the APARs closed in this package, which you can then view
(and search) in an ASCII editor, such as vi or emacs. First, create the .toc file for the package by using the inutoc command described above. Then, run the
following command to extract the APAR listings from the .tocfile:
grep ^I .toc
> apar.list
Run the
following command to eliminate duplicate entries from the apar.listfile:
sort
-u apar.list -o sorted.apars
|
Font: IBM
A prova!!!!!! SAP FORUM 2014
Olá!!!
Comemorando mais de 10 mil visualizações no blog e minha participação no SAP Forum 2014....
Muito obrigado a todos!
Comemorando mais de 10 mil visualizações no blog e minha participação no SAP Forum 2014....
Muito obrigado a todos!
Denis Fernandes Gomes no SAP Forum Brasil 2014
Boa tarde!
Serei palestrante no SAP Forum Brasil 2014 com o seguinte tema "Case Unifi: Otimizando processos de armazenagem".
No dia 12/02/14, às 01:30 PM no Transamérica Expo Center em São Paulo.
Abordaremos a utilização do SAP ITSMobile na solução de problemas de armazenagem.
Nos encontramos em Fevereiro!
Abraços
Serei palestrante no SAP Forum Brasil 2014 com o seguinte tema "Case Unifi: Otimizando processos de armazenagem".
No dia 12/02/14, às 01:30 PM no Transamérica Expo Center em São Paulo.
Abordaremos a utilização do SAP ITSMobile na solução de problemas de armazenagem.
Nos encontramos em Fevereiro!
Abraços
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
Postagens
