Bagaimana Cara Extend Table Space pada Oracle?

Bagaimana Cara Extend Table Space pada Oracle

  1. Check table space sebelum di extend
  2. Logon ke SAP GUI
  3. Check menggunakan SQL pada Operating System dan pilih datafiles dari tablespaces.
  4. Extend Table space pada oracle.
  5. Login ke console from <orasid> user.
  6. Run brtools dengan options pada comand prompt.
  7. Verify table-space yang akan di extend melalui SAP GUI
  8. Check menggunakan SQL pada OS dan pilih datafiles dari tablespaces.

Tulisan ini bertujuan untuk menunjukkan bagaimana untuk extend table space database menggunakan BRTOOLS dalam LINUX dan kemudian memverifikasi apakah dalam data files baru telah ditambahkan dengan benar atau tidak.

Tulisan ini akan memandu kita untuk menggunakan: CMD dan penggunaan GUI untuk task tertentu dan berlaku untuk SAP NetWeaver R / 3 Sistem

Check table space sbelum extend menggunakan SAP GUI

Gunakan TCODE DB02 dan dan check ukuran database. (contoh gambar di bawah ini The Ukuran Total 293.97 GB)

Gambar

Gunakan tcode DB02 pilih tablespace yang akan di extend. Contoh: PSAPSR3

[= PSAPSR3]

Gambar

Gambar di atas menampilkan datafile terakhir sr3.data18.

Check menggunakan SQL pada OS dan select datafiles dari tablespaces.

Login ke SQL dari user <oraSID>

Erppi1# su orapi1

erppi1:orapi1 54>

erppi1:orapi1 53> sqlplus / as sysdba

SQL>

SQL> pilih file_name from dba_data_files;

kemudian akan display datafiles sampai yang terakhir

Contoh : /oracle/PI1/sapdata4/sr3_18/sr3.data18

Extend Table space pada Login oracle pada console dari <orasid> user

Log in ke operating system dengan user yang mempunyai authorisasi untuk Oracle DBA dan run command BRTOOLS.

Erppi1# su orapi1

erppi1:orapi1 54>

Run brtools

Run brtools and then follow the following steps.

erppi1:orapi1 54> brtools

BR0651I BRTOOLS 7.00 (32)

BR0280I BRTOOLS time stamp: 2012-06-26 09.51.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: 2012-06-26 09.51.56

BR0663I Your choice: ‘2’

BR0280I BRTOOLS time stamp: 2012-06-26 09.51.56

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: 2012-06-26 09.51.56

BR0663I Your choice: ‘1’

BR0280I BRTOOLS time stamp: 2012-06-26 09.51.56

BR0657I Input menu 81 – please check/enter input values

——————————————————————————-

BRSPACE options for tablespace extension

1 – BRSPACE profile (profile) …… [initPI1.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 initPI1.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: 2012-06-26 09.52.04

BR0663I Your choice: ‘c’

BR0259I Program execution will be continued…

BR0291I BRSPACE will be started with options ‘-p initPI1.sap -s 20 -l E -f tsextend’

BR0280I BRTOOLS time stamp: 2012-06-26 09.52.04

BR0670I Enter ‘c[ont]’ to continue, ‘b[ack]’ to go back, ‘s[top]’ to abort:

c

BR0280I BRTOOLS time stamp: 2012-06-26 09.52.11

BR0257I Your reply: ‘c’

BR0259I Program execution will be continued…

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

BR1001I BRSPACE 7.00 (32)

BR1002I Start of BRSPACE processing: seivvhdr.tse 2012-06-26 09.52.11

BR0484I BRSPACE log file: /oracle/PI1/sapreorg/seivvhdr.tse

BR0280I BRSPACE time stamp: 2012-06-26 09.52.11

BR1009I Name of database instance: PI1

BR1010I BRSPACE action ID: seivvhdr

BR1011I BRSPACE function ID: tse

BR1012I BRSPACE function: tsextend

BR0280I BRSPACE time stamp: 2012-06-26 09.52.11

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:

c

BR0280I BRSPACE time stamp: 2012-06-26 09.52.23

BR0663I Your choice: ‘c’

BR0259I Program execution will be continued…

BR0280I BRSPACE time stamp: 2012-06-26 09.52.24

BR0658I List menu 302 – please select one entry

——————————————————————————-

List of tablespaces for extension

  1. Pos. Tablespace    Files/AuExt.   Total[KB] Used[%]    Free[KB]  MaxSize[KB]

1 – PSAPSR3          18/18      175484928     96.07 6901376    176291840

2 – PSAPSR3700        9/9        88948736     87.78 10866112     88948736

3 – PSAPSR3USR        1/1          389120     95.82 16256     10240000

4 – PSAPTEMP          1/0         2048000      0.00 2048000      2048000

5 – PSAPUNDO          1/1         7987200      0.00 7987136     10240000

6 – SYSAUX            1/1          634880     89.99 63552     10240000

7 – SYSTEM            1/1          921600     98.41 14656     10240000

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

——————————————————————————-

BR0662I Enter your selection:

1

BR0280I BRSPACE time stamp: 2012-06-26 09.52.27

BR0663I Your selection: ‘1’

BR0280I BRSPACE time stamp: 2012-06-26 09.52.27

BR0657I Input menu 303 – please check/enter input values

——————————————————————————-

Options for extension of tablespace PSAPSR3 (1. file)

1 * Last added file name (lastfile) ……. [/oracle/PI1/sapdata4/sr3_18/sr3.data18]

2 * Last added file size in MB (lastsize) . [9216]

3 – New file to be added (file) ……….. [/oracle/PI1/sapdata4/sr3_19/sr3.data19]

4 ~ Raw disk / link target (rawlink) …… []

5 – Size of the new file in MB (size) ….. [9216]

6 – File autoextend mode (autoextend) ….. [yes]

7 ? Maximum file size in MB (maxsize) ….. []

8 – File increment size in MB (incrsize) .. [20]

9 – SQL command (command) …………….. [alter tablespace PSAPSR3 add datafile ‘/oracle/PI1/sapdata4/sr3_19/sr3.data19’ size 9216M autoextend on next 20M maxsize M]

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

——————————————————————————-

BR0662I Enter your choice:

5

BR0280I BRSPACE time stamp: 2012-06-26 09.57.52

BR0663I Your choice: ‘5’

BR0280I BRSPACE time stamp: 2012-06-26 09.57.52

BR0682I Enter integer value for “size” (1-32767) [9216]:

9216

BR0280I BRSPACE time stamp: 2012-06-26 09.57.59

BR0683I New value for “size”: ‘9216’

BR0280I BRSPACE time stamp: 2012-06-26 09.57.59

BR0657I Input menu 303 – please check/enter input values

——————————————————————————-

Options for extension of tablespace PSAPSR3 (1. file)

1 * Last added file name (lastfile) ……. [/oracle/PI1/sapdata4/sr3_18/sr3.data18]

2 * Last added file size in MB (lastsize) . [9216]

3 – New file to be added (file) ……….. [/oracle/PI1/sapdata4/sr3_19/sr3.data19]

4 ~ Raw disk / link target (rawlink) …… []

5 – Size of the new file in MB (size) ….. [9216]

6 – File autoextend mode (autoextend) ….. [yes]

7 ? Maximum file size in MB (maxsize) ….. []

8 – File increment size in MB (incrsize) .. [20]

9 – SQL command (command) …………….. [alter tablespace PSAPSR3 add datafile ‘/oracle/PI1/sapdata4/sr3_19/sr3.data19’ size 9216M autoextend on next 20M maxsize M]

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

——————————————————————————-

BR0662I Enter your choice:

7

BR0280I BRSPACE time stamp: 2012-06-26 09.58.19

BR0663I Your choice: ‘7’

BR0280I BRSPACE time stamp: 2012-06-26 09.58.19

BR0682I Enter integer value for “maxsize” (0-32767) []:

9216

BR0280I BRSPACE time stamp: 2012-06-26 09.58.24

BR0683I New value for “maxsize”: ‘9216’

BR0280I BRSPACE time stamp: 2012-06-26 09.58.24

BR0657I Input menu 303 – please check/enter input values

——————————————————————————-

Options for extension of tablespace PSAPSR3 (1. file)

1 * Last added file name (lastfile) ……. [/oracle/PI1/sapdata4/sr3_18/sr3.data18]

2 * Last added file size in MB (lastsize) . [9216]

3 – New file to be added (file) ……….. [/oracle/PI1/sapdata4/sr3_19/sr3.data19]

4 ~ Raw disk / link target (rawlink) …… []

5 – Size of the new file in MB (size) ….. [9216]

6 – File autoextend mode (autoextend) ….. [yes]

7 – Maximum file size in MB (maxsize) ….. [9216]

8 – File increment size in MB (incrsize) .. [20]

9 – SQL command (command) …………….. [alter tablespace PSAPSR3 add datafile ‘/oracle/PI1/sapdata4/sr3_19/sr3.data19’ size 9216M autoextend on next 20M maxsize 9216M]

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

——————————————————————————-

BR0662I Enter your choice:

c

BR0280I BRSPACE time stamp: 2012-06-26 09.58.30

BR0663I Your choice: ‘c’

BR0259I Program execution will be continued…

BR0280I BRSPACE time stamp: 2012-06-26 09.58.30

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: 2012-06-26 09.59.30

BR0257I Your reply: ‘c’

BR0678I The action will be skipped…

BR0259I Program execution will be continued…

BR0280I BRSPACE time stamp: 2012-06-26 09.59.30

BR0370I Directory /oracle/PI1/sapreorg/seivvhdr created

BR0280I BRSPACE time stamp: 2012-06-26 09.59.33

BR0319I Control file copy created: /oracle/PI1/sapreorg/seivvhdr/cntrlPI1.old 31211520

BR0280I BRSPACE time stamp: 2012-06-26 09.59.33

BR0370I Directory /oracle/PI1/sapdata4/sr3_19 created

BR0280I BRSPACE time stamp: 2012-06-26 09.59.33

BR1088I Extending tablespace PSAPSR3…

Verify table-space yang telah di Extend Melalui SAP GUI

Use DB02 and then refresh to get oracle space statistics.

Kemudia pilih OK untuk confirm action.

up1.png

up2.pngClick Yes

up3.png

Lalu check status melalui DB02 dan ukuran database nya.

[Ukuran yang baru adalah 302.97 GB]

db02-after1.png

Lalu check tablespace yang telah di extend dan datafile yang telah ditambahkan

[= PSAPSR3] Kemudian

db02-after3.png

[Datafile baru telah ditambahkan yaitu sr3.data19 ]

Check Menggunakan SQL pada OS dan pilih datafiles dari tablespaces.

Login ke SQL dari user <oraSID>

Check menggunakan SQL pada OS dan pilih datafiles dari tablespaces.

Login ke SQL dari user <oraSID>

Erppi1# su orapi1

erppi1:orapi1 54>

erppi1:orapi1 53> sqlplus / as sysdba

SQL>

SQL> pilih file_name from dba_data_files;

kemudian akan display datafiles sampai yang terakhir

Contoh : /oracle/PI1/sapdata4/sr3_18/sr3.data18

sumber: http://scn.sap.com/docs/DOC-29484

Tinggalkan Balasan

Isikan data di bawah atau klik salah satu ikon untuk log in:

Logo WordPress.com

You are commenting using your WordPress.com account. Logout / Ubah )

Gambar Twitter

You are commenting using your Twitter account. Logout / Ubah )

Foto Facebook

You are commenting using your Facebook account. Logout / Ubah )

Foto Google+

You are commenting using your Google+ account. Logout / Ubah )

Connecting to %s