SAP表空间溢出扩容

已于 2024-04-07 16:40:35 修改
阅读量375 收藏 8
点赞数 8
分类专栏： 数据库 文章标签： 数据库
于 2024-01-08 17:01:56 首次发布
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/qq_22981239/article/details/135461762
版权

[sapprd01:root:/]df -g
Filesystem    GB blocks      Free %Used    Iused %Iused Mounted on
/dev/hd4           2.00      1.55   23%    11048     3% /
/dev/hd2           4.00      1.28   68%    55721    16% /usr
/dev/hd9var        8.00      2.99   63%    12766     2% /var
/dev/hd3          20.00     11.19   45%    19759     1% /tmp
/dev/hd1           0.25      0.15   42%     8958    21% /home
/dev/hd11admin      0.25      0.25    1%        5     1% /admin
/proc                 -         -    -         -     -  /proc
/dev/hd10opt       0.50      0.15   70%     9020    20% /opt
/dev/livedump      0.25      0.25    1%        4     1% /var/adm/ras/livedump
/dev/fslv02      350.00     70.55   80%     6852     1% /backup
/dev/sapmntlv     30.00     11.06   64%   119470     5% /export/sapmnt
/dev/oraclelv     30.00      9.81   68%   235436    10% /oracle
/dev/orahomelv     15.00      7.83   48%    38686     3% /oracle/PRD/11202
/dev/archive001lv    300.00    259.13   14%       29     1% /oracle/PRD/archive01
/dev/mirrlogAlv      3.00      1.05   66%        8     1% /oracle/PRD/mirrlogA
/dev/mirrlogBlv      3.00      1.05   66%        8     1% /oracle/PRD/mirrlogB
/dev/oraarchlv    198.00    192.46    3%       19     1% /oracle/PRD/oraarch
/dev/origlogAlv      3.00      1.03   66%       10     1% /oracle/PRD/origlogA
/dev/origlogBlv      3.00      1.03   66%       10     1% /oracle/PRD/origlogB
/dev/sapdata1lv    400.00    132.83   67%       38     1% /oracle/PRD/sapdata1
/dev/sapdata2lv    400.00    112.53   72%       22     1% /oracle/PRD/sapdata2
/dev/sapdata3lv    400.00     92.53   77%       24     1% /oracle/PRD/sapdata3
/dev/sapdata4lv    400.00    100.27   75%       28     1% /oracle/PRD/sapdata4
/dev/sapdata5lv    400.00    116.20   71%       34     1% /oracle/PRD/sapdata5
/dev/sapdata6lv    400.00    112.34   72%       32     1% /oracle/PRD/sapdata6
/dev/sapdata7lv    400.00    118.93   71%       34     1% /oracle/PRD/sapdata7
/dev/sapdata8lv    400.00    119.93   71%       33     1% /oracle/PRD/sapdata8
/dev/fslv01      600.00    244.32   60%       36     1% /oracle/PRD/sapdata9
/dev/usrsaplv     20.00      6.63   67%    49599     4% /usr/sap
/dev/sapbackup   2560.00    161.14   94%       13     1% /sapbackup
[sapprd01:root:/]su - oraprd
sapprd01:oraprd 1> brtools
BR0651I BRTOOLS 7.20 (40)

BR0280I BRTOOLS time stamp: 2023-12-26 15.35.45
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: 2023-12-26 15.35.46
BR0663I Your choice: '2'

BR0280I BRTOOLS time stamp: 2023-12-26 15.35.46
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: 2023-12-26 15.35.48
BR0663I Your choice: '1'

BR0280I BRTOOLS time stamp: 2023-12-26 15.35.48
BR0657I Input menu 81 - please enter/check input values
-------------------------------------------------------------------------------
BRSPACE options for tablespace extension

 1 - BRSPACE profile (profile) ...... [initPRD.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 initPRD.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: 2023-12-26 15.35.49
BR0663I Your choice: 'c'
BR0259I Program execution will be continued...

BR0291I BRSPACE will be started with options '-p initPRD.sap -s 20 -l E -f tsextend'

BR0280I BRTOOLS time stamp: 2023-12-26 15.35.49
BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:
c
BR0280I BRTOOLS time stamp: 2023-12-26 15.35.53
BR0257I Your reply: 'c'
BR0259I Program execution will be continued...

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

BR1001I BRSPACE 7.20 (40)
BR1002I Start of BRSPACE processing: sfnjyhbt.tse 2023-12-26 15.35.53
BR0484I BRSPACE log file: /oracle/PRD/sapreorg/sfnjyhbt.tse

BR0280I BRSPACE time stamp: 2023-12-26 15.35.53
BR1009I Name of database instance: PRD
BR1010I BRSPACE action ID: sfnjyhbt
BR1011I BRSPACE function ID: tse
BR1012I BRSPACE function: tsextend

BR0280I BRSPACE time stamp: 2023-12-26 15.35.53
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: 2023-12-26 15.35.55
BR0663I Your choice: '1'

BR0280I BRSPACE time stamp: 2023-12-26 15.35.57
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 - PSAPSR3          99/23     2446561280    100.00       44992   2446561280
  2 - PSAPSR3702        3/0        61317120     73.84    16038208     61317120
  3 - PSAPSR3USR        2/0         2129920     97.69       49216      2129920
  4 - PSAPTEMP          9/0       214384640      0.00   214384640    214384640
  5 - PSAPUNDO          4/0       106229760      1.38   104767616    106229760
  6 - SYSAUX            2/0         2097152     97.99       42112      2097152
  7 - SYSTEM            2/0         2097152     55.11      941504      2097152

Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------
BR0662I Enter your selection:
1
BR0280I BRSPACE time stamp: 2023-12-26 15.36.04
BR0663I Your selection: '1'

BR0280I BRSPACE time stamp: 2023-12-26 15.36.04
BR0657I Input menu 303 - please enter/check input values
-------------------------------------------------------------------------------
Options for extension of tablespace PSAPSR3 (1. file)

 1 * Last added file name (lastfile) ....... [/oracle/PRD/sapdata9/sr3_99/sr3.data99]
 2 * Last added file size in MB (lastsize) . [32000]
 3 - New file to be added (file) ........... [/oracle/PRD/sapdata9/sr3_100/sr3.data100]
 4 ~ Raw disk / link target (rawlink) ...... []
 5 - Size of the new file in MB (size) ..... [32000]
 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 PSAPSR3 add datafile '/oracle/PRD/sapdata9/sr3_100/sr3.data100' size 32000M autoextend off]

Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------
BR0662I Enter your choice:
5
BR0280I BRSPACE time stamp: 2023-12-26 15.36.07
BR0663I Your choice: '5'
BR0682I Enter integer value for "size" (1-32767) [32000]:
10000
BR0280I BRSPACE time stamp: 2023-12-26 15.36.10
BR0683I New value for "size": '10000'

BR0280I BRSPACE time stamp: 2023-12-26 15.36.10
BR0657I Input menu 303 - please enter/check input values
-------------------------------------------------------------------------------
Options for extension of tablespace PSAPSR3 (1. file)

 1 * Last added file name (lastfile) ....... [/oracle/PRD/sapdata9/sr3_99/sr3.data99]
 2 * Last added file size in MB (lastsize) . [32000]
 3 - New file to be added (file) ........... [/oracle/PRD/sapdata9/sr3_100/sr3.data100]
 4 ~ Raw disk / link target (rawlink) ...... []
 5 - Size of the new file in MB (size) ..... [10000]
 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 PSAPSR3 add datafile '/oracle/PRD/sapdata9/sr3_100/sr3.data100' size 10000M autoextend off]

Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------
BR0662I Enter your choice:
6        
BR0280I BRSPACE time stamp: 2023-12-26 15.36.20
BR0663I Your choice: '6'
BR0681I Enter string value for "autoextend" (yes|no) [no]:
yes
BR0280I BRSPACE time stamp: 2023-12-26 15.36.23
BR0683I New value for "autoextend": 'yes'

BR0280I BRSPACE time stamp: 2023-12-26 15.36.23
BR0657I Input menu 303 - please enter/check input values
-------------------------------------------------------------------------------
Options for extension of tablespace PSAPSR3 (1. file)

 1 * Last added file name (lastfile) ....... [/oracle/PRD/sapdata9/sr3_99/sr3.data99]
 2 * Last added file size in MB (lastsize) . [32000]
 3 - New file to be added (file) ........... [/oracle/PRD/sapdata9/sr3_100/sr3.data100]
 4 ~ Raw disk / link target (rawlink) ...... []
 5 - Size of the new file in MB (size) ..... [10000]
 6 - File autoextend mode (autoextend) ..... [yes]
 7 ? Maximum file size in MB (maxsize) ..... []
 8 ? File increment size in MB (incrsize) .. []
 9 - SQL command (command) ................. [alter tablespace PSAPSR3 add datafile '/oracle/PRD/sapdata9/sr3_100/sr3.data100' size 10000M autoextend on next M maxsize M]

Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------
BR0662I Enter your choice:
7
BR0280I BRSPACE time stamp: 2023-12-26 15.36.24
BR0663I Your choice: '7'
BR0682I Enter integer value for "maxsize" (0-32767) []:
32000
BR0280I BRSPACE time stamp: 2023-12-26 15.36.26
BR0683I New value for "maxsize": '32000'

BR0280I BRSPACE time stamp: 2023-12-26 15.36.26
BR0657I Input menu 303 - please enter/check input values
-------------------------------------------------------------------------------
Options for extension of tablespace PSAPSR3 (1. file)

 1 * Last added file name (lastfile) ....... [/oracle/PRD/sapdata9/sr3_99/sr3.data99]
 2 * Last added file size in MB (lastsize) . [32000]
 3 - New file to be added (file) ........... [/oracle/PRD/sapdata9/sr3_100/sr3.data100]
 4 ~ Raw disk / link target (rawlink) ...... []
 5 - Size of the new file in MB (size) ..... [10000]
 6 - File autoextend mode (autoextend) ..... [yes]
 7 - Maximum file size in MB (maxsize) ..... [32000]
 8 ? File increment size in MB (incrsize) .. []
 9 - SQL command (command) ................. [alter tablespace PSAPSR3 add datafile '/oracle/PRD/sapdata9/sr3_100/sr3.data100' size 10000M autoextend on next M maxsize 32000M]

Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------
BR0662I Enter your choice:
8
BR0280I BRSPACE time stamp: 2023-12-26 15.36.28
BR0663I Your choice: '8'
BR0682I Enter integer value for "incrsize" (1-32767) []:
50
BR0280I BRSPACE time stamp: 2023-12-26 15.36.30
BR0683I New value for "incrsize": '50'

BR0280I BRSPACE time stamp: 2023-12-26 15.36.30
BR0657I Input menu 303 - please enter/check input values
-------------------------------------------------------------------------------
Options for extension of tablespace PSAPSR3 (1. file)

 1 * Last added file name (lastfile) ....... [/oracle/PRD/sapdata9/sr3_99/sr3.data99]
 2 * Last added file size in MB (lastsize) . [32000]
 3 - New file to be added (file) ........... [/oracle/PRD/sapdata9/sr3_100/sr3.data100]
 4 ~ Raw disk / link target (rawlink) ...... []
 5 - Size of the new file in MB (size) ..... [10000]
 6 - File autoextend mode (autoextend) ..... [yes]
 7 - Maximum file size in MB (maxsize) ..... [32000]
 8 - File increment size in MB (incrsize) .. [50]
 9 - SQL command (command) ................. [alter tablespace PSAPSR3 add datafile '/oracle/PRD/sapdata9/sr3_100/sr3.data100' size 10000M autoextend on next 50M maxsize 32000M]

Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------
BR0662I Enter your choice:
c
BR0280I BRSPACE time stamp: 2023-12-26 15.36.32
BR0663I Your choice: 'c'
BR0259I Program execution will be continued...

BR1091I Next data file can be specified now

BR0280I BRSPACE time stamp: 2023-12-26 15.36.32
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:
y
BR0280I BRSPACE time stamp: 2023-12-26 15.36.33
BR0257I Your reply: 'y'
BR0677I The action will be executed...

BR0280I BRSPACE time stamp: 2023-12-26 15.36.33
BR0657I Input menu 303 - please enter/check input values
-------------------------------------------------------------------------------
Options for extension of tablespace PSAPSR3 (2. file)

 1 * Last added file name (lastfile) ....... [/oracle/PRD/sapdata9/sr3_99/sr3.data99]
 2 * Last added file size in MB (lastsize) . [32000]
 3 - New file to be added (file) ........... [/oracle/PRD/sapdata9/sr3_101/sr3.data101]
 4 ~ Raw disk / link target (rawlink) ...... []
 5 - Size of the new file in MB (size) ..... [10000]
 6 - File autoextend mode (autoextend) ..... [yes]
 7 - Maximum file size in MB (maxsize) ..... [32000]
 8 - File increment size in MB (incrsize) .. [50]
 9 - SQL command (command) ................. [alter tablespace PSAPSR3 add datafile '/oracle/PRD/sapdata9/sr3_100/sr3.data100' size 10000M autoextend on next 50M maxsize 32000M, '/oracle/PRD/sapdata9/sr3_101/sr3.data101' size 10000M autoextend on next 50M maxsize 32000M]

Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------
BR0662I Enter your choice:
c
BR0280I BRSPACE time stamp: 2023-12-26 15.36.36
BR0663I Your choice: 'c'
BR0259I Program execution will be continued...

BR1091I Next data file can be specified now

BR0280I BRSPACE time stamp: 2023-12-26 15.36.36
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: 2023-12-26 15.36.38
BR0257I Your reply: 'n'
BR0678I The action will be skipped...

BR0370I Directory /oracle/PRD/sapreorg/sfnjyhbt created

BR0280I BRSPACE time stamp: 2023-12-26 15.36.38
BR0319I Control file copy created: /oracle/PRD/sapreorg/sfnjyhbt/cntrlPRD.old 20955136

BR0370I Directory /oracle/PRD/sapdata9/sr3_100 created
BR0370I Directory /oracle/PRD/sapdata9/sr3_101 created

BR0280I BRSPACE time stamp: 2023-12-26 15.36.38
BR1088I Extending tablespace PSAPSR3 ...

BR0280I BRSPACE time stamp: 2023-12-26 15.37.32
BR1016I SQL statement 'alter tablespace PSAPSR3 add datafile '/oracle/PRD/sapdata9/sr3_100/sr3.data100' size 10000M autoextend on next 50M maxsize 32000M, '/oracle/PRD/sapdata9/sr3_101/sr3.data101' size 10000M autoextend on next 50M maxsize 32000M' executed successfully

BR1051I Tablespace PSAPSR3 extended successfully with files:
/oracle/PRD/sapdata9/sr3_100/sr3.data100 10000M,
/oracle/PRD/sapdata9/sr3_101/sr3.data101 10000M

BR0280I BRSPACE time stamp: 2023-12-26 15.37.32
BR0340I Switching to the next online redolog file for database instance PRD ...
BR0321I Switch to the next online redolog file for database instance PRD successful

BR0280I BRSPACE time stamp: 2023-12-26 15.37.34
BR0319I Control file copy created: /oracle/PRD/sapreorg/sfnjyhbt/cntrlPRD.new 20955136

BR0280I BRSPACE time stamp: 2023-12-26 15.37.34
BR0256I Enter 'c[ont]' to continue, 's[top]' to cancel BRSPACE:
c
BR0280I BRSPACE time stamp: 2023-12-26 15.37.37
BR0257I Your reply: 'c'
BR0259I Program execution will be continued...

BR0280I BRSPACE time stamp: 2023-12-26 15.37.37
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: 2023-12-26 15.37.57
BR0663I Your choice: '1'

BR0280I BRSPACE time stamp: 2023-12-26 15.37.59
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 - PSAPSR3         101/25     2467041280     99.17    20522944   2512097280
  2 - PSAPSR3702        3/0        61317120     73.84    16038208     61317120
  3 - PSAPSR3USR        2/0         2129920     97.69       49216      2129920
  4 - PSAPTEMP          9/0       214384640      0.00   214384640    214384640
  5 - PSAPUNDO          4/0       106229760      1.38   104767616    106229760
  6 - SYSAUX            2/0         2097152     98.04       41088      2097152
  7 - SYSTEM            2/0         2097152     55.11      941504      2097152

Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------
BR0662I Enter your selection:
s
BR0280I BRSPACE time stamp: 2023-12-26 15.48.41
BR0663I Your selection: 's'
BR0679I Do you really want to cancel BRSPACE? Enter y[es]/n[o]:
y
BR0280I BRSPACE time stamp: 2023-12-26 15.48.42
BR0257I Your reply: 'y'
BR0260E BRSPACE cancelled by user

BR1008I End of BRSPACE processing: sfnjyhbt.tse 2023-12-26 15.48.42
BR0280I BRSPACE time stamp: 2023-12-26 15.48.42
BR1007I BRSPACE terminated with errors

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

BR0292I Execution of BRSPACE finished with return code 4

BR0280I BRTOOLS time stamp: 2023-12-26 15.48.42
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: 2023-12-26 15.48.43
BR0257I Your reply: 's'
BR0679I Do you really want to cancel BRTOOLS? Enter y[es]/n[o]:
y
BR0280I BRTOOLS time stamp: 2023-12-26 15.48.44
BR0257I Your reply: 'y'
BR0260E BRTOOLS cancelled by user

BR0280I BRTOOLS time stamp: 2023-12-26 15.48.44
BR0654I BRTOOLS terminated with errors
sapprd01:oraprd 2> df -g
Filesystem    GB blocks      Free %Used    Iused %Iused Mounted on
/dev/hd4           2.00      1.55   23%    11048     3% /
/dev/hd2           4.00      1.28   68%    55721    16% /usr
/dev/hd9var        8.00      2.99   63%    12766     2% /var
/dev/hd3          20.00     11.19   45%    19759     1% /tmp
/dev/hd1           0.25      0.15   42%     8958    21% /home
/dev/hd11admin      0.25      0.25    1%        5     1% /admin
/proc                 -         -    -         -     -  /proc
/dev/hd10opt       0.50      0.15   70%     9020    20% /opt
/dev/livedump      0.25      0.25    1%        4     1% /var/adm/ras/livedump
/dev/fslv02      350.00     70.55   80%     6852     1% /backup
/dev/sapmntlv     30.00     11.06   64%   119406     5% /export/sapmnt
/dev/oraclelv     30.00      9.77   68%   235479    10% /oracle
/dev/orahomelv     15.00      7.83   48%    38686     3% /oracle/PRD/11202
/dev/archive001lv    300.00    259.13   14%       29     1% /oracle/PRD/archive01
/dev/mirrlogAlv      3.00      1.05   66%        8     1% /oracle/PRD/mirrlogA
/dev/mirrlogBlv      3.00      1.05   66%        8     1% /oracle/PRD/mirrlogB
/dev/oraarchlv    198.00    190.59    4%       24     1% /oracle/PRD/oraarch
/dev/origlogAlv      3.00      1.03   66%       10     1% /oracle/PRD/origlogA
/dev/origlogBlv      3.00      1.03   66%       10     1% /oracle/PRD/origlogB
/dev/sapdata1lv    400.00    132.83   67%       38     1% /oracle/PRD/sapdata1
/dev/sapdata2lv    400.00    112.53   72%       22     1% /oracle/PRD/sapdata2
/dev/sapdata3lv    400.00     92.53   77%       24     1% /oracle/PRD/sapdata3
/dev/sapdata4lv    400.00    100.27   75%       28     1% /oracle/PRD/sapdata4
/dev/sapdata5lv    400.00    116.20   71%       34     1% /oracle/PRD/sapdata5
/dev/sapdata6lv    400.00    112.34   72%       32     1% /oracle/PRD/sapdata6
/dev/sapdata7lv    400.00    118.93   71%       34     1% /oracle/PRD/sapdata7
/dev/sapdata8lv    400.00    119.93   71%       33     1% /oracle/PRD/sapdata8
/dev/fslv01      600.00    224.78   63%       40     1% /oracle/PRD/sapdata9
/dev/usrsaplv     20.00      6.63   67%    49599     4% /usr/sap
/dev/sapbackup   2560.00    161.14   94%       13     1% /sapbackup
sapprd01:oraprd 3>

Captainsz
关注
  • 8
    点赞
  • 踩
  • 8
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
备份sap的DEV笔记
linghao00的专栏
07-11 2546
du -h 查看目录总大小 topas 查看网络的输出KB-Out是否达到千M uname -a查看版本 #  # mount -o rw,vers=3 192.168.209.157:/backup /oracle/DEV/sapbackup # df -g Filesystem    GB blocks      Free %Used
SAP常用表关系图.rar
10-17
这个" SAP常用表关系图.rar" 文件显然包含了一份关于SAP系统中常用数据库表之间的关系图表，这对于理解和优化SAP系统的运行至关重要。下面我们将详细探讨SAP系统中的表关系以及其重要性。 首先，SAP系统基于ABAP...
Oracle-brtools 扩展表空间
ageeklet的博客
09-16 830
# su - oraep1 deliep101:oraep1 5> brtools BR0651I BRTOOLS 7.20 (34) BR0280I BRTOOLS time stamp: 2019-05-26 21.26.56 BR0656I Choice menu 1 - please make a selection -------------------------...
Spring Boot修改最大上传文件限制:The field file exceeds its maximum permitted size of 1048576 bytes.
热门推荐
Chopper的小窝
04-18 8万+
SpringBoot做文件上传时出现了The field file exceeds its maximum permitted size of 1048576 bytes.错误，显示文件的大小超出了允许的范围。查看了官方文档，原来Spring Boot工程嵌入的tomcat限制了请求的文件大小，这一点在Spring Boot的官方文档中有说明，原文如下 65.5 Handling Multipa...
Brtools扩oracle表空间
野马
01-19 5370
[/]#su - orahostname:ora> brtoolsBR0651I BRTOOLS 7.00 (32)BR0280I BRTOOLS time stamp: 2010-01-06 15.55.14BR0656I Choice menu 1 - please make a selection------------------------------------------------
安装服务器系统要多大空间,一般服务器的内存要多大
weixin_39671621的博客
08-10 730
一般服务器的内存要多大 内容精选换一换在性能优化时，需要遵循一定的原则，主要有以下几个方面：对性能进行分析时，要多方面分析系统的资源瓶颈所在，如CPU利用率达到100%时，也可能是内存容量限制，导致CPU忙于处理内存调度。一次只对一个性能指标参数进行调整。分析工具本身运行可能会带来资源损耗，导致系统某方面的资源瓶颈情况更加严重，应避免或降低对应用程序的影响。调优分析思路如下：块存储调优主要分为：均...
Oracle数据库错误代码大全总结
兰海泽的博客
09-03 1万+
ORACLE数据库错误代码大全总结 ORA-00001: 违反唯一约束条件 (.) ORA-00017: 请求会话以设置跟踪事件 ORA-00018: 超出最大会话数 ORA-00019: 超出最大会话许可数 ORA-00020: 超出最大进程数 () ORA-00021: 会话附属于其它某些进程；无法转换会话 ORA-00022: 无效的会话 ID；访问被拒绝 OR...
OLTP与OLAP的关系是什么？
_
01-27 835
OLTP（on-line transaction processing）翻译为联机事务处理， OLAP（On-Line Analytical Processing）翻译为联机分析处理，从字面上来看OLTP是做事务处理，OLAP是做分析处理。从对数据库操作来看，OLTP主要是对数据的增删改，OLAP是对数据的查询。 再从应用上来看看OLTP与OLAP的区别。 OLTP主要用来记录某类业务事件的发生，如购买行为，当行为产生后，系统会记录是谁在何时何地做了何事，这样的一行（或多行）数据会以增删改的方式在数据库
【大数据处理技术】期末复习整理
鸽子的博客
07-19 1万+
所用教材：《大数据技术原理与应用——概念、存储、处理、分析与应用（第2版）》，由厦门大学计算机科学系林子雨编著。 教材官网：http://dblab.xmu.edu.cn/post/bigdata/ 慕课：http://www.icourse163.org/course/XMU-1002335004 内容总结自PPT： 第一篇：大数据基础 第1章 大数据概述 第2章 大数据处理架构Hadoop 第二篇 大数据存储与管理 第3章 分布式文件系统HDFS 第4章 分布式数据库HBase 第5章 No
大数据技术期末复习精要（珠科版）
Kanteroa的博客
06-23 2066
珠海科技学院大数据技术期末复习
SAP所有表及关系 SAP所有表及关系
06-08
SAP所有表及关系SAP所有表及关系SAP所有表及关系SAP所有表及关系SAP所有表及关系SAP所有表及关系SAP所有表及关系SAP所有表及关系SAP所有表及关系SAP所有表及关系SAP所有表及关系SAP所有表及关系SAP所有表及关系SAP...
SAP 预留 表关系
02-07
SAP 预留 表关系 by Tiger
SAP 采购订单 表关系
02-07
SAP 采购订单 表关系 by Tiger
SAP 采购申请 表关系
02-07
SAP 采购申请 表关系 by Tiger
OAuth2.0 or Spring Session or 单点登录流程
最新发布
qq_53374893的博客
07-20 243
一句话精辟解释： 在过滤器放行的时候，偷偷的把原生的 request 和 response 对象换成了它的实现，也就是 调用getSession 的时候拿到的 其实是对redis 操作的Session。但其他的操作还是使用原生的，只不过重写的方法，调用的是子类的，也就是往 redis 里放入 Session，把原生的操作给替换了！分布式Session原理，使用子域名，的时候放入父域名的 JsessionId 然后将这个ID 的所存的内容放入Redis ，这样实现不同域名共享同一sessionID.
MySQL（事务、索引）&&MyBatis
hycccccch的博客
07-19 564
事务指的是一组操作的集合，是一个不可分割的工作单位。事务会将所有的操作作为一个整体一起向系统提交或撤销操作请求，即这些操作要么同时成功，要么同时失败默认MySQL的事务是自动提交，即当执行一条DML语句时，MySQL会立即隐式的提交事务开启事务后运行事务不会对数据改变，commit后才会改变数据如果有命令发生错误，需要进行rollback进行回滚、
Spring框架之DI依赖注入
G81948577的博客
07-18 970
我们在下面构建spring的过程中体会依赖注入；从上面的图中我们知道，在ssm框架中服务层（server）无法直接操作数据库，持久层（dao）是直接操作数据库进行数据处理的，但是我们如果在服务层有一个持久层的对象，然后我们在服务层通过对象去调用持久层的方法就可以操作数据库了。@OverrideSystem.out.println("持久层，你好");UserServiceImpl类中的代码如下@Override。
深入 Dify 源码，洞察 Dify RAG 核心机制
易迟的专栏
07-17 1130
之前深入源码对 Dify 的完整流程进行了解读，基本上梳理了 Dify 的实现流程与主要组件。但是在实际部署之后，发现 Dify 现有的 RAG 检索效果没有那么理想。因此个人结合前端页面，配置信息与实现流程，深入查看了私有化部署的 Dify 的技术细节。将核心内容整理在这边，方便大家根据实际的业务场景调整 Dify 知识库的配置，或者根据需要进行二次开发调优。
SAP财务与运营关键后台数据表详解
"SAP常用后台数据表大全(FI-CO-MM-SD-PP等).pdf"，涵盖了SAP系统中财务会计(FI)、成本与管理会计(CO)、物料管理(MM)、销售与分销(SD)、生产计划(PP)等多个模块的重要后台数据表。 在SAP系统中，后台数据表是系统...

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值