이상하네???
용량이 내가 정해 놓은 용량에서 늘어나서 올라왔네?
auto extend 되서 올라온걸까?
auto extend 를 끄고 다시 도전~!
어~~ 올라오긴 올라온다.
근데, 용량이 늘어난 채로 올라온다?
ALTIBASE SR 문의를 해봐야 겠군!
실제 Cnf 에 설정한 용량과 왜 차이가 발생하면서 올라오는지?
6.1.1 기준으로 이게 start 되는 사항이 맞는건지?
-> 우선 답변은 insert 에 대해서는 undo를 사용하지 않는다고 한다.
해당 용량이 차이가 발생하는 것은 답변을 현재로써 기다리는 중이다.(2015-08-19 15:09)
실제 실행한 명령문
ALTER TABLESPACE SYS_TBS_DISK_UNDO ALTER DATAFILE 'undo001.dbf' AUTOEXTEND OFF;
server stop
rename undo001.dbf undo001_bak.dbf /alti_dbs_disk0/disk_dat/undo001.dbf
dd if=/alti_dbs_disk0/disk_dat/undo001_bak.dbf of=/alti_dbs_disk0/disk_dat/undo001.dbf bs=101376 count=1
server start
ps -ef | grep altibase
jyj:[/alti_dbs_disk0/disk_dat]ps -ef | grep altibase
root 3661 3476 0 Aug17 pts/0 00:00:00 su - altibase
altibase 3662 3661 0 Aug17 pts/0 00:00:00 -bash
root 3939 3735 0 Aug17 pts/0 00:00:00 su - altibase
altibase 3940 3939 0 Aug17 pts/0 00:00:00 -bash
root 17562 4406 0 09:16 pts/1 00:00:00 su - altibase
altibase 17566 17562 0 09:16 pts/1 00:00:00 -bash
altibase 17758 1 0 09:23 pts/0 00:00:00 /altibase/altibase_home/bin/isql -u sys -p manager -sysdba -noprompt
altibase 20621 1 0 10:38 ? 00:00:13 /altibase/altibase_home/bin/altibase -p boot from admin
altibase 21526 3940 0 11:14 pts/0 00:00:00 ps -ef
altibase 21527 3940 0 11:14 pts/0 00:00:00 grep altibase
jyj:[/alti_dbs_disk0/disk_dat]is -u sys -p manager -sysdba
-----------------------------------------------------------------
Altibase Client Query utility.
Release Version 6.1.1.4.2
Copyright 2000, ALTIBASE Corporation or its subsidiaries.
All Rights Reserved.
-----------------------------------------------------------------
ISQL_CONNECTION = UNIX, SERVER = localhost, PORT_NO = 20300
iSQL(sysdba)> ALTER TABLESPACE SYS_TBS_DISK_UNDO ALTER DATAFILE 'undo001.dbf' AUTOEXTEND OFF;
Alter success.
iSQL(sysdba)> exit
jyj:[/alti_dbs_disk0/disk_dat]server stop
-----------------------------------------------------------------
Altibase Client Query utility.
Release Version 6.1.1.4.2
Copyright 2000, ALTIBASE Corporation or its subsidiaries.
All Rights Reserved.
-----------------------------------------------------------------
ISQL_CONNECTION = UNIX, SERVER = localhost, PORT_NO = 20300
Ok..Shutdown Proceeding....
TRANSITION TO PHASE : Shutdown Altibase
[RP] Finalization : PASS
shutdown immediate success.
jyj:[/alti_dbs_disk0/disk_dat]ls -al | grep undo*
-rw-r-----. 1 altibase altibase 135274496 Aug 18 11:16 undo001.dbf
jyj:[/alti_dbs_disk0/disk_dat]rename undo001.dbf undo001_bak.dbf /alti_dbs_disk0/disk_dat/undo001.dbf
jyj:[/alti_dbs_disk0/disk_dat]ls -al | grep undo*
-rw-r-----. 1 altibase altibase 135274496 Aug 18 11:16 undo001_bak.dbf
jyj:[/alti_dbs_disk0/disk_dat]dd if=/alti_dbs_disk0/disk_dat/undo001_bak.dbf of=/alti_dbs_disk0/disk_dat/undo001.dbf bs=101376 count=1
1+0 records in
1+0 records out
101376 bytes (101 kB) copied, 0.000288957 s, 351 MB/s
jyj:[/alti_dbs_disk0/disk_dat]ls -al | grep undo*
jyj:[/alti_dbs_disk0/disk_dat]ls -al
total 337028
drwxrwxr-x. 2 altibase altibase 4096 Aug 18 11:17 ./
drwxr-xr-x. 3 altibase dba 4096 Aug 18 09:21 ../
-rw-r-----. 1 altibase altibase 104865792 Aug 18 11:16 system001.dbf
-rw-r-----. 1 altibase altibase 104865792 Aug 18 10:17 temp001.dbf
-rw-rw-r--. 1 altibase altibase 101376 Aug 18 11:17 undo001.dbf
-rw-r-----. 1 altibase altibase 135274496 Aug 18 11:16 undo001_bak.dbf
jyj:[/alti_dbs_disk0/disk_dat]server start
-----------------------------------------------------------------
Altibase Client Query utility.
Release Version 6.1.1.4.2
Copyright 2000, ALTIBASE Corporation or its subsidiaries.
All Rights Reserved.
-----------------------------------------------------------------
ISQL_CONNECTION = UNIX, SERVER = localhost, PORT_NO = 20300
[ERR-910FB : Connected to idle instance]
Connecting to the DB server... Connected.
TRANSITION TO PHASE : PROCESS
To be expired at 2015-11-17.
TRANSITION TO PHASE : CONTROL
TRANSITION TO PHASE : META
[SM] Recovery Phase - 1 : Preparing Database
: Dynamic Memory Version => Parallel Loading
[SM] Recovery Phase - 2 : Loading Database
[SM] Recovery Phase - 3 : Skipping Recovery & Starting Threads...
Refining Disk Table
[SM] Refine Memory Table : ......................................................................................................... [SUCCESS]
[SM] Rebuilding Indices [Total Count:105] ......................................................................................................... [SUCCESS]
TRANSITION TO PHASE : SERVICE
[CM] Listener started : TCP on port 20300 [IPV4]
[CM] Listener started : UNIX
[CM] Listener started : IPC
[RP] Initialization : [PASS]
--- STARTUP Process SUCCESS ---
Command executed successfully.
jyj:[/alti_dbs_disk0/disk_dat]ls -al
total 337512
drwxrwxr-x. 2 altibase altibase 4096 Aug 18 11:17 ./
drwxr-xr-x. 3 altibase dba 4096 Aug 18 09:21 ../
-rw-r-----. 1 altibase altibase 104865792 Aug 18 11:18 system001.dbf
-rw-r-----. 1 altibase altibase 104865792 Aug 18 10:17 temp001.dbf
-rw-rw-r--. 1 altibase altibase 15769600 Aug 18 11:18 undo001.dbf
-rw-r-----. 1 altibase altibase 135274496 Aug 18 11:16 undo001_bak.dbf