http://iotn.co.kr 연락처: gilho.kr@gmail.com [ The Japanese government should apologize to Japanese Military Sexual Slavery victim. / 日本政府は日本軍の性的奴隷?牲者に謝罪すべき. ]

사용자

ID:
PW:

INDEX
01.게시판
게시판 [69]
02.File Book
File 자료실 [95]
Site Link [18]
개인폴더 [194]
03.Field Book
Altibase [19]
Tibero [30]
MS-SQL [18]
MySQL [40]
DB2 [79]
ORACLE [2888]
PostgreSQL [103]
기타정보 [150]
운영체제 [577]
04.Q/A Book
Q/A [53]
05.방명록
방명록 [54]
레벨업 [37]
구인/구직 [2]

기념일
Search
LINK
+ 가족 Hompy
+ DNSEver
IOTN :: Field Book :: Altibase

 회원가입

[FAILURE] Unable to invoke the open() function on [/home/altibase/altibase-HDB-server-6.1.1-2/logs/logfile100]
최길호 [LIST]   2020-10-07 23:57:05, 조회 : 343


LOG_FILE_SIZE = 10M
변경해도 안먹는다. DB 생성시 Fix 된다.

용량이 커져서 삭제 했더니 복구 불가 [ update: Max 1.2G 자동 운영 / 자동 삭제 된다. ]
rm /home/altibase/altibase-HDB-server-6.1.1-2/logs/logfile*
이후 발생
본사로 보내면 복구 가능하다는... doc


node2:[altibase@localhost ~]$ server start
-----------------------------------------------------------------
     Altibase Client Query utility.
     Release Version 6.1.1.3.4
     Copyright 2000, ALTIBASE Corporation or its subsidiaries.
     All Rights Reserved.
-----------------------------------------------------------------
ISQL_CONNECTION = UNIX, SERVER = localhost, PORT_NO = 22300
[ERR-910FB : Connected to idle instance]
Connecting to the DB server... Connected.
TRANSITION TO PHASE : PROCESS
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 : Starting Recovery
                            Initializing Active Transaction List
                            Redo
[FAILURE] Unable to invoke the open() function on [/home/altibase/altibase-HDB-server-6.1.1-2/logs/logfile100]
Startup Failed....
[ERR-91015 : Communication failure.]
node2:[altibase@localhost ~]$ is -sysdba
-----------------------------------------------------------------
     Altibase Client Query utility.
     Release Version 6.1.1.3.4
     Copyright 2000, ALTIBASE Corporation or its subsidiaries.
     All Rights Reserved.
-----------------------------------------------------------------
ISQL_CONNECTION = UNIX, SERVER = localhost, PORT_NO = 22300
[ERR-910FB : Connected to idle instance]
iSQL(sysdba)> startup control
Connecting to the DB server... Connected.
TRANSITION TO PHASE : PROCESS
TRANSITION TO PHASE : CONTROL
Command executed successfully.

iSQL(sysdba)> alter database syncdb meta resetlogs;
TRANSITION TO PHASE : META
[FAILURE]
[FAILURE] Execution impossible in NO ARCHIVE mode.
Startup Failed....
[ERR-91015 : Communication failure.]

node2:[altibase@localhost ~]$ touch /home/altibase/altibase-HDB-server-6.1.1-2/logs/logfile102
node2:[altibase@localhost ~]$ server start
-----------------------------------------------------------------
     Altibase Client Query utility.
     Release Version 6.1.1.3.4
     Copyright 2000, ALTIBASE Corporation or its subsidiaries.
     All Rights Reserved.
-----------------------------------------------------------------
ISQL_CONNECTION = UNIX, SERVER = localhost, PORT_NO = 22300
[ERR-910FB : Connected to idle instance]
Connecting to the DB server... Connected.


TRANSITION TO PHASE : PROCESS


TRANSITION TO PHASE : CONTROL


TRANSITION TO PHASE : META
[FAILURE] Logfile /home/altibase/altibase-HDB-server-6.1.1-2/logs/logfile103 nonexistent.
Startup Failed....
[ERR-91015 : Communication failure.]
node2:[altibase@localhost ~]$ touch /home/altibase/altibase-HDB-server-6.1.1-2/logs/logfile103
node2:[altibase@localhost logs]$ ls -al
total 133416
drwxr-xr-x  2 altibase dba     4096 Oct  7 21:50 .
drwxr-xr-x 18 altibase dba     4096 Nov 18  2016 ..
-rw-r-----  1 altibase dba    17872 Oct  7 15:18 loganchor0
-rw-r-----  1 altibase dba    17872 Oct  7 15:18 loganchor1
-rw-r-----  1 altibase dba    17872 Oct  7 15:18 loganchor2
-rw-r--r--  1 altibase dba        0 Oct  7 21:50 logfile103
-rw-r-----  1 altibase dba 10485760 Oct  7 15:18 logfile193
-rw-r-----  1 altibase dba 10485760 Oct  7 15:18 logfile194
-rw-r-----  1 altibase dba 10485760 Oct  7 15:18 logfile195
-rw-r-----  1 altibase dba 10485760 Oct  7 15:18 logfile196
-rw-r-----  1 altibase dba 10485760 Oct  7 15:19 logfile197
-rw-r-----  1 altibase dba 10485760 Oct  7 15:19 logfile198
-rw-r-----  1 altibase dba 10485760 Oct  7 15:19 logfile199
-rw-r-----  1 altibase dba 10485760 Oct  7 15:19 logfile200
-rw-r-----  1 altibase dba 10485760 Oct  7 15:18 logfile201
-rw-r-----  1 altibase dba 10485760 Oct  7 15:18 logfile202
-rw-r-----  1 altibase dba 10485760 Oct  7 15:19 logfile203
-rw-r-----  1 altibase dba 10485760 Oct  7 15:19 logfile204
-rw-r-----  1 altibase dba 10485760 Oct  7 15:19 logfile205
node2:[altibase@localhost logs]$
server start
touch /home/altibase/altibase-HDB-server-6.1.1-2/logs/logfile104
select 'touch /home/altibase/altibase-HDB-server-6.1.1-2/logs/logfile'||rownum from dual connect by level < 193;


tail -f /home/altibase/altibase-HDB-server-6.1.1-2/trc/altibase_boot.log
[2020/10/07 23:26:40] [Thread-1122715968] [Level-0]
[SUCCEESS]
[2020/10/07 23:26:40] [Thread-1122715968] [Level-0]
[SM-PREPARE] Identify Database
[2020/10/07 23:26:40] [Thread-1122715968] [Level-0]
        checking file(s) of all memory tablespace
[2020/10/07 23:26:40] [Thread-1122715968] [Level-0]
        checking file(s) of all disk tablespace
[2020/10/07 23:26:40] [Thread-1122715968] [Level-0]
        checking logfile(s)
[2020/10/07 23:26:40] [Thread-1122715968] [Level-0]
ERR-110a7(errno=2) Logfile /home/altibase/altibase-HDB-server-6.1.1-2/logs/logfile302 nonexistent.
[2020/10/07 23:26:40] [Thread-1122715968] [Level-0]
[FAILURE] Logfile /home/altibase/altibase-HDB-server-6.1.1-2/logs/logfile302 nonexistent.


node2:[altibase@localhost logs]$ rm /home/altibase/altibase-HDB-server-6.1.1-2/logs/logfile*
node2:[altibase@localhost logs]$ ls -alrt /home/altibase/altibase-HDB-server-6.1.1-2/logs/
total 88
drwxr-xr-x 18 altibase dba  4096 Nov 18  2016 ..
-rw-r-----  1 altibase dba 17872 Oct  7 15:18 loganchor2
-rw-r-----  1 altibase dba 17872 Oct  7 15:18 loganchor1
-rw-r-----  1 altibase dba 17872 Oct  7 15:18 loganchor0
drwxr-xr-x  2 altibase dba  4096 Oct  7 23:38 .
node2:[altibase@localhost logs]$

node2:[altibase@localhost logs]$ server start
-----------------------------------------------------------------
     Altibase Client Query utility.
     Release Version 6.1.1.3.4
     Copyright 2000, ALTIBASE Corporation or its subsidiaries.
     All Rights Reserved.
-----------------------------------------------------------------
ISQL_CONNECTION = UNIX, SERVER = localhost, PORT_NO = 22300
[ERR-910FB : Connected to idle instance]
Connecting to the DB server... Connected.
TRANSITION TO PHASE : PROCESS
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 : Starting Recovery
                            Initializing Active Transaction List
                            Redo
[FAILURE] Unable to invoke the open() function on [/home/altibase/altibase-HDB-server-6.1.1-2/logs/logfile100]
Startup Failed....
[ERR-91015 : Communication failure.]
node2:[altibase@localhost logs]$
3.235.78.122


  LIST

제목 작성자 작성일 조회
Admin  dbf 위치 확인 / 삭제 / create database [$ server create MS949 UTF8 ] / 서비스 시작    최길호 2020/10/08 263
Troubleshoot  [FAILURE] Unable to invoke the open() function on [/home/altibase/altibase-HDB-server-6.1.1-2/logs/logfile100]    최길호 2020/10/07 343
Admin  주소 iloader in [ csv data import ]    최길호 2020/10/07 271
Admin  altibase replication test    최길호 2016/11/17 1847
Backup & Recovery  hot backup script [ alter database backup database to '/backup/'; ]    최길호 2016/10/02 1182
Admin  -- 모든 테이블    최길호 2016/10/02 1092
Admin  [ERR-110A4 : Backup in progress. Please wait until the current backup is completed.]    최길호 2016/10/02 746
Admin  Sybase IQ 15.2 evaluation software    최길호 2013/08/21 2875
Admin  alter database rename datafile    최길호 2013/07/27 4150
Backup & Recovery  aexport lv:9   최길호 2013/07/22 1347
Admin  alter tablespace ts_disk1 alter datafile '/altibase/6.1/dbs/tbs_disk1_200.dbf' autoextend on next 200m maxsize unlimited;    최길호 2013/04/13 2784
Troubleshoot  [FAILURE] The data file '/altibase/6.1/dbs/SYS_TBS_MEM_DIC-0-0' has an invalid header. lv:9   최길호 2013/04/11 1383
Troubleshoot  oracle to altibase data type 호환     최길호 2013/04/05 2893
Admin  getdata.sql [ 오라클, 알티베이스 마이그레이션 내용 ] lv:9   최길호 2013/04/05 1299
Admin  http://support.altibase.com/kr/manual [ NLS_DATE_FORMAT = altibase.properties:DEFAULT_DATE_FORMAT ]    최길호 2013/04/04 13605
Admin  altibase 교육 자료 lv:4   최길호 2013/04/03 1497

    목록보기 1
       

Copyright 1999-2022 Zeroboard / skin by 최길호(gilho.kr@gmail.com)
최근 댓글
최근 게시물
06/29
[ORACLE]
DDE: Problem Key 'ORA 600 [133....
by 최길호
06/25
[ORACLE]
Replication may not be valid i....
by 최길호
06/22
[운영체제]
CentOS7 홈페이지 Migration 메모.
by 최길호