Minggu, 28 Februari 2010

Penambah table extente database

waktu kita check tcode db02 ternyata pas check space statistic table spacenya sudah sampe 95% tandanya kita harus extent table space server databasenya....
di db13 juga seh biasanya juga muncul erornya kalo udah lebih dari 95% tapi itu sangat
ga di sarankan kalo sampe 95% ga di extent table spacenya,

oke langsung aja kita buka BRTOOLS nya startdartnya SAP:
logikanya kalo soal database yang masalah maka server databasenya yang mesti kita lakukan perbaikan
1.Loggin ke database server

login: root
Password:
Last login: Mon Dec 3 11:01:04 from 172.17.102.76:0
Sun Microsystems Inc. SunOS 5.9 Generic May 2002
You have mail.
Sourcing //.profile-EIS.....

2. loggin ke adm
itu SAP nya punya kita
contoh saya pake di sini sech pakenya adalah tpr
root@tasdb1 # su - tpradm
Sun Microsystems Inc. SunOS 5.9 Generic May 2002

3. jalankan BRTOOLS

tasdb1:tpradm 1% brtools
BR0651I BRTOOLS 6.40 (39)

BR0280I BRTOOLS time stamp: 2007-12-04 10.59.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
------------------------------------------------------------------------------
dari logika kita akan benerin spacenya bearti kita pilih nomer 2

BR0662I Enter your choice:
2
BR0280I BRTOOLS time stamp: 2007-12-04 11.00.02
BR0663I Your choice: '2'

BR0280I BRTOOLS time stamp: 2007-12-04 11.00.02
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
-------------------------------------------------------------------------------

dari sana kita pilih nomer 1 karena kita akan meng-extent table space

BR0662I Enter your choice:
1
BR0280I BRTOOLS time stamp: 2007-12-04 11.00.03
BR0663I Your choice: '1'

BR0280I BRTOOLS time stamp: 2007-12-04 11.00.03
BR0657I Input menu 81 - please check/enter input values
-------------------------------------------------------------------------------
BRSPACE options for tablespace extension

1 - BRSPACE profile (profile) ...... [initTPR.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 initTPR.sap -s 20 -l E -f tsextend]

Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------

untuk Table space name dapat di lihat dari tcode db02


nah setelah kita tau tabel spacenya maka kita pilih tabel spacenya

BR0662I Enter your choice:
3
BR0280I BRTOOLS time stamp: 2007-12-04 11.00.18
BR0663I Your choice: '3'

BR0280I BRTOOLS time stamp: 2007-12-04 11.00.18
BR0681I Enter string value for "tablespace" []:
PSAPTPR
BR0280I BRTOOLS time stamp: 2007-12-04 11.00.27
BR0683I New value for "tablespace": 'PSAPTPR'

BR0280I BRTOOLS time stamp: 2007-12-04 11.00.27
BR0657I Input menu 81 - please check/enter input values
-------------------------------------------------------------------------------

BRSPACE options for tablespace extension

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

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

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

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

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

BR1001I BRSPACE 6.40 (39)
BR1002I Start of BRSPACE processing: sdwsvmvv.tse 2007-12-04 11.02.23

BR0280I BRSPACE time stamp: 2007-12-04 11.02.26
BR1009I Name of database instance: TPR
BR1010I BRSPACE action ID: sdwsvmvv
BR1011I BRSPACE function ID: tse
BR1012I BRSPACE function: tsextend

BR0280I BRSPACE time stamp: 2007-12-04 11.02.27
BR0657I Input menu 303 - please check/enter input values
-------------------------------------------------------------------------------
Options for extension of tablespace PSAPTPR (1. file)

1 * Last added file name (lastfile) ....... [/oracle/TPR/sapdata4/tpr_15/tpr.data15]
2 * Last added file size in MB (lastsize) . [2000]
3 - New file to be added (file) ........... [/oracle/TPR/sapdata4/tpr_16/tpr.data16]
4 ~ Raw disk / link target (rawlink) ...... []
5 - Size of the new file in MB (size) ..... [2000]
6 - File autoextend mode (autoextend) ..... [yes]
7 - Maximum file size in MB (maxsize) ..... [10000]
8 - File increment size in MB (incrsize) .. [20]
9 - SQL command (command) ................. [alter tablespace PSAPTPR add datafile '/oracle/TPR/sapdata4/tpr_16/tpr.data16' size 2000M autoextend on next 20M maxsize 10000M]

Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------
setelah kita sudah yakin dengan besarnya space yang akan kita gedein maka kita pilih continue

BR0662I Enter your choice:
c
BR0280I BRSPACE time stamp: 2007-12-04 11.03.56
BR0663I Your choice: 'c'
BR0259I Program execution will be continued...

BR0280I BRSPACE time stamp: 2007-12-04 11.03.56
BR1091I Next data file can be specified now
BR0675I Do you want to perform this action?
BR0676I Enter 'y[es]' to perform the action, 'n[o]/c[ont]' to skip it, 's[top]' to abort:
c
BR0280I BRSPACE time stamp: 2007-12-04 11.04.26
BR0257I Your reply: 'c'
BR0678I The action will be skipped...
BR0259I Program execution will be continued...

BR0280I BRSPACE time stamp: 2007-12-04 11.04.27
BR0370I Directory /oracle/TPR/sapreorg/sdwsvmvv created

BR0280I BRSPACE time stamp: 2007-12-04 11.04.28
BR0319I Control file copy created: /oracle/TPR/sapreorg/sdwsvmvv/cntrlTPR.old 6791168

BR0280I BRSPACE time stamp: 2007-12-04 11.04.28
BR0370I Directory /oracle/TPR/sapdata4/tpr_16 created

BR0280I BRSPACE time stamp: 2007-12-04 11.04.28
BR1088I Extending tablespace PSAPTPR...

BR0280I BRSPACE time stamp: 2007-12-04 11.05.25
BR1016I SQL statement 'alter tablespace PSAPTPR add datafile '/oracle/TPR/sapdata4/tpr_16/tpr.data16' size 2000M autoextend on next 20M maxsize 10000M' executed successfully
BR1051I Tablespace PSAPTPR extended successfully with file: /oracle/TPR/sapdata4/tpr_16/tpr.data16 2000M

BR0280I BRSPACE time stamp: 2007-12-04 11.05.25
BR0340I Switching to next online redo log file for database instance TPR ...
BR0321I Switch to next online redo log file for database instance TPR successful

BR0280I BRSPACE time stamp: 2007-12-04 11.05.28
BR0319I Control file copy created: /oracle/TPR/sapreorg/sdwsvmvv/cntrlTPR.new 6791168

BR0280I BRSPACE time stamp: 2007-12-04 11.05.28
BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:
c
BR0280I BRSPACE time stamp: 2007-12-04 11.06.11
BR0257I Your reply: 'c'
BR0259I Program execution will be continued...

BR0280I BRSPACE time stamp: 2007-12-04 11.06.11
BR1020I Number of tablespaces processed: 1
BR1003I BRSPACE function 'tsextend' completed

BR1008I End of BRSPACE processing: sdwsvmvv.tse 2007-12-04 11.06.11
BR0280I BRSPACE time stamp: 2007-12-04 11.06.11
BR1005I BRSPACE completed successfully

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

BR0292I Execution of BRSPACE finished with return code 0
BR0280I BRTOOLS time stamp: 2007-12-04 11.06.11

kalo udah setesai pilih aja contingu lagi aja

BR0256I Enter 'c[ont]' to continue, 's[top]' to cancel BRTOOLS:
c
BR0280I BRTOOLS time stamp: 2007-12-04 11.06.21
BR0257I Your reply: 'c'
BR0259I Program execution will be continued...

BR0280I BRTOOLS time stamp: 2007-12-04 11.06.21
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:
b
BR0280I BRTOOLS time stamp: 2007-12-04 11.06.29
BR0663I Your choice: 'b'
BR0673I Going back to the previous menu...

BR0280I BRTOOLS time stamp: 2007-12-04 11.06.29
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:
9
BR0280I BRTOOLS time stamp: 2007-12-04 11.06.31
BR0663I Your choice: '9'
BR0280I BRTOOLS time stamp: 2007-12-04 11.06.31
BR0680I Do you really want to exit BRTOOLS? Enter y[es]/n[o]:
y
BR0280I BRTOOLS time stamp: 2007-12-04 11.06.37
BR0257I Your reply: 'y'

BR0280I BRTOOLS time stamp: 2007-12-04 11.06.37
BR0652I BRTOOLS completed successfully

keluar dari BRTOOLS
tasdb1:tpradm 2% exit

Logout dari SAP administrator
tasdb1:tpradm 3% logout

root@tasdb1 #

Selesai........
coba check di tcode db02 nya dengan klik refesh



Tidak ada komentar:

Posting Komentar