본문 바로가기
카테고리 없음

Altibase Undo Test 3

by Driving 2015. 8. 17.

근데,

일부 파일 생성 시 용량이 이상하게 해도 될까?(99MB 이하로 생성)


실제 실행한 명령문


server stop

rename undo001.dbf undo001_bak.dbf /home/jyj/altibase/dbs/undo001.dbf 

dd if=/home/jyj/altibase/dbs/undo001_bak.dbf of=/home/jyj/altibase/dbs/undo001.dbf bs=101376 count=1

server start

ps -ef | grep altibase



[jyj@jyj ~]$ server stop

-----------------------------------------------------------------

     Altibase Client Query utility.

     Release Version 5.5.1.4.10

     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@jyj ~]$ 

[jyj@jyj ~]$ rename undo001.dbf undo001_bak.dbf /home/jyj/altibase/dbs/undo001.dbf 

[jyj@jyj ~]$ cd altibase/

[jyj@jyj altibase]$ cd dbs

[jyj@jyj dbs]$ ls

dwfile0.dwf  dwfile1.dwf  system001.dbf  temp001.dbf  test_db.dbf  test_db_tmp.dbf  undo001_bak.dbf

[jyj@jyj dbs]$ ll

-rw-r-----. 1 jyj jyj  268443648 2015-08-17 15:24 undo001_bak.dbf

[jyj@jyj dbs]$ dd if=/home/jyj/altibase/dbs/undo001_bak.dbf of=/home/jyj/altibase/dbs/undo001.dbf bs=101376 count=1

1+0 records in

1+0 records out

101376 bytes (101 kB) copied, 0.0270317 s, 3.8 MB/s

[jyj@jyj dbs]$ ll

-rw-rw-r--. 1 jyj jyj     101376 2015-08-17 15:25 undo001.dbf

-rw-r-----. 1 jyj jyj  268443648 2015-08-17 15:24 undo001_bak.dbf

[jyj@jyj dbs]$ server start

-----------------------------------------------------------------

     Altibase Client Query utility.

     Release Version 5.5.1.4.10

     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-12.



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:101] ..................................................................................................... [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@jyj dbs]$ ls -al

-rw-rw-r--.  1 jyj jyj  133996544 2015-08-17 15:25 undo001.dbf

-rw-r-----.  1 jyj jyj  268443648 2015-08-17 15:24 undo001_bak.dbf

[jyj@jyj dbs]$ ps -ef | grep altibase

jyj       3998     1  2 15:25 ?        00:00:01 /home/jyj/altibase/bin/altibase -p boot from admin

jyj       4336  3328  0 15:26 pts/1    00:00:00 grep altibase

[jyj@jyj dbs]$ 



이상하네???

용량이 내가 정해 놓은 용량에서 늘어나서 올라왔네?

auto extend 되서 올라온걸까?