/*
rename undo001.dbf undo001_bak.dbf /home/jyj/altibase/dbs/undo001.dbf
rename undo001_bak.dbf undo001.dbf /home/jyj/altibase/dbs/undo001_bak.dbf
*/
--Touch 로 빈파일 만들고 DB 기동이 되는지?
>> 결론은 안됨!
[jyj@jyj dbs]$ rename undo001.dbf undo001_bak.dbf /home/jyj/altibase/dbs/undo001.dbf
[jyj@jyj dbs]$ ls -al
-rw-r-----. 1 jyj jyj 10493952 2015-08-13 18:16 test_db_tmp.dbf
-rw-r-----. 1 jyj jyj 268443648 2015-08-17 13:33 undo001_bak.dbf
-rw-r-----. 1 jyj jyj 268443648 2015-08-17 13:33 undo002.dbf
[jyj@jyj dbs]$ touch undo001.dbf
[jyj@jyj dbs]$ ls -al
-rw-rw-r--. 1 jyj jyj 0 2015-08-17 13:33 undo001.dbf
-rw-r-----. 1 jyj jyj 268443648 2015-08-17 13:33 undo001_bak.dbf
-rw-r-----. 1 jyj jyj 268443648 2015-08-17 13:33 undo002.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
[FAILURE] The data file '/home/jyj/altibase/dbs/undo001.dbf' has an invalid header. : DATABASE SID=3, FID=0, RedoLSN=control[0, 842, 4807439], [0, 0, 0], CreateLSN=control[0, 0, 2583], [0, 0, 0], DBVer=84148224, CtrVer=84148224, FileVer=0
Startup Failed....
[ERR-91015 : Communication failure.]
[jyj@jyj dbs]$
-- 용량을 줄여보자~!
: 어~~ ?! 사용되지 않은 용량까진 줄어드는데, 그 이상까지 줄이려고 하면 안되는구나~~
iSQL> ALTER TABLESPACE SYS_TBS_DISK_UNDO ALTER DATAFILE 'undo002.dbf' SIZE 100M;
Alter success.
iSQL> ALTER TABLESPACE SYS_TBS_DISK_UNDO ALTER DATAFILE 'undo002.dbf' SIZE 10M;
[ERR-11122 : It is impossible to shrink this file. ( Request Size : 1280 pages, Used File Size : 8194 pages )]
-- 일부 용량으로 생성해 보자~!
1) 서버 내린다.
2) 기존 파일명을 변경하고 새로운 파일을 생성한다.
3) 일부 파일을 생성한다.
4) 서버 올린다.
어~~ 된다!
/*
변경
rename undo001.dbf undo001_bak.dbf /home/jyj/altibase/dbs/undo001.dbf
원복
rename undo001_bak.dbf undo001.dbf /home/jyj/altibase/dbs/undo001_bak.dbf
dd if=/home/jyj/altibase/dbs/undo001.dbf of=/home/jyj/altibase/dbs/undo001.dbf bs=134221680 count=1
*/
[jyj@jyj dbs]$ 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 dbs]$
[jyj@jyj dbs]$ rename undo001.dbf undo001_bak.dbf /home/jyj/altibase/dbs/undo001.dbf
[jyj@jyj dbs]$ touch undo001.dbf
[jyj@jyj dbs]$ ls -al
-rw-rw-r--. 1 jyj jyj 0 2015-08-17 14:35 undo001.dbf
-rw-r-----. 1 jyj jyj 268443648 2015-08-17 14:35 undo001_bak.dbf
-rw-r-----. 1 jyj jyj 104865792 2015-08-17 14:35 undo002.dbf
[jyj@jyj dbs]$ dd if=/home/jyj/altibase/dbs/undo001_bak.dbf of=/home/jyj/altibase/dbs/undo001.dbf bs=134221680 count=1
1+0 records in
1+0 records out
134221680 bytes (134 MB) copied, 0.125077 s, 1.1 GB/s
[jyj@jyj dbs]$ ps -ef | grep altibase
jyj 9224 6033 0 14:36 pts/1 00:00:00 grep altibase
[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 134221680 2015-08-17 14:36 undo001.dbf
-rw-r-----. 1 jyj jyj 268443648 2015-08-17 14:35 undo001_bak.dbf
-rw-r-----. 1 jyj jyj 104865792 2015-08-17 14:36 undo002.dbf
[jyj@jyj dbs]$