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

사용자

ID:
PW:

INDEX
01.게시판
게시판 [71]
02.File Book
File 자료실 [95]
Site Link [17]
개인폴더 [200]
03.Field Book
Altibase [19]
Tibero [30]
MS-SQL [18]
MySQL [43]
DB2 [79]
ORACLE [2973]
PSQL [133]
기타정보 [155]
운영체제 [600]
04.Q/A Book
Q/A [53]
05.방명록
방명록 [54]
레벨업 [37]
구인/구직 [2]

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

 회원가입

TBR-1024 : Database needs media recovery
최길호 [LIST]   2020-12-20 09:39:46, 조회 : 2,586

tbboot
********************************************************
* Critical Warning : Raise svmode failed. The reason is
*   TBR-1024 :  Database needs media recovery: file needs end backup(/data1/tbdata/system001.tdf).
*   Current server mode is MOUNT.
********************************************************
tbsql sys/tibero
SQL>
select * from v$recover_file;

SQL> alter database recover automatic database;

Database altered.

SQL> exit
tbdown
tbboot

export TB_NLS_DATE_FORMAT='YYYY/MM/DD HH24:MI:SS'
alter database recover automatic database until time '2013/06/13 15:58:50';


참고: https://technet.tmaxsoft.com/download.do?filePath=/nas/technet/technet/upload/kss/tbook/tibero/2014/05/&fileName=FILE-20140103-000080_140528091743_1.pdf

복구 메모

dbms.log
2020/12/20 08:44:50.125 [CLL][0]  68 checksum error: log block LF#65535(member=0, blkno=0)
2020/12/20 08:44:50.146 [CLL][0]  68 checksum error: log block LF#65535(member=0, blkno=0)
2020/12/20 08:44:50.159 [CLL][0]  68 checksum error: log block LF#65535(member=0, blkno=0)
2020/12/20 08:44:50.181 [CLL][0]  68 checksum error: log block LF#65535(member=0, blkno=0)
2020/12/20 08:44:50.193 [CLL][0]  68 checksum error: log block LF#65535(member=0, blkno=0)
....
2020/12/20 08:45:03.383 [CLL][0]  68 checksum error: log block LF#65535(member=0, blkno=0)
2020/12/20 09:04:54.100 [CLC][0]  68 DATAFILES OPEN: for recovery (stop 0002.b577207d) [ archivelog 복구 ]
2020/12/20 09:05:01.978 [CLC][0]  68 DATAFILES OPEN: for recovery (stop 0002.b577bf35)
2020/12/20 09:05:09.837 [CLC][0]  68 DATAFILES OPEN: for recovery (stop 0002.b578413d)
2020/12/20 09:05:17.804 [CLC][0]  68 DATAFILES OPEN: for recovery (stop 0002.b578fba7)
2020/12/20 09:05:24.966 [CLC][0]  68 DATAFILES OPEN: for recovery (stop 0002.b5799d88)
2020/12/20 09:05:32.107 [CLC][0]  68 DATAFILES OPEN: for recovery (stop 0002.b57a4abd)
2020/12/20 09:05:39.455 [CLC][0]  68 DATAFILES OPEN: for recovery (stop 0002.b57af852)
2020/12/20 09:05:47.139 [CLC][0]  68 DATAFILES OPEN: for recovery (stop 0002.b57ba3bd)
2020/12/20 09:05:54.038 [CLC][0]  68 DATAFILES OPEN: for recovery (stop ffff.ffffffff)
2020/12/20 09:05:57.617 [DDL][0]  68 Alter database type 0 succeeded.

trace.log [ port 변경 해서 로그인 시도 메세지 제거 ]
12/20 09:05:39.436386 [CLR][0] 68 tc_mr.c :1403 invalid logfile(/data2/tbdata/arclog/log-t0-r0-s254405.arc, seq#254405): too old
12/20 09:05:39.436491 [CLC][0] 68 tc_mr.c :1466 MR set next logfile (THREAD#0, seq 254406) - /data2/tbdata/arclog/log-t0-r0-s254406.arc
12/20 09:05:39.455334 [CLC][0] 68 tc_cf_df:1945 DATAFILES OPEN: for recovery (stop 0002.b57af852)
12/20 09:05:47.063903 [CLD][0] 68 tc_pool.:476 Wating Buffer Flushed (fileq=0, ckptq=0, recoq=1)
12/20 09:05:47.070024 [CLD][0] 68 tc_pool.:582 recoQ flushed until 0002.b57af851
12/20 09:05:47.075288 [CLC][0] 68 tc_cf.c :1846 REDO THREAD #0 CKPT updated to 0002.b57af852/0.0 (prev 0002.b57a4ad3/254406.84)
12/20 09:05:47.075334 [CLC][0] 68 tc_cf.c :1797 DB CKPT updated: 0002.b57a4ad3 => 0002.b57af852 (open count=1)
12/20 09:05:47.123398 [CLR][0] 68 tc_mr.c :1403 invalid logfile(/data2/tbdata/arclog/log-t0-r0-s254406.arc, seq#254406): too old
12/20 09:05:47.123470 [CLC][0] 68 tc_mr.c :1466 MR set next logfile (THREAD#0, seq 254407) - /data2/tbdata/arclog/log-t0-r0-s254407.arc
12/20 09:05:47.139912 [CLC][0] 68 tc_cf_df:1945 DATAFILES OPEN: for recovery (stop 0002.b57ba3bd)
12/20 09:05:53.892077 [CLD][0] 68 tc_pool.:476 Wating Buffer Flushed (fileq=0, ckptq=0, recoq=1)
12/20 09:05:53.892154 [CLD][0] 68 tc_pool.:582 recoQ flushed until 0002.b57ba3bc
12/20 09:05:53.892575 [CLC][0] 68 tc_cf.c :1846 REDO THREAD #0 CKPT updated to 0002.b57ba3bd/0.0 (prev 0002.b57af852/0.0)
12/20 09:05:53.892608 [CLC][0] 68 tc_cf.c :1797 DB CKPT updated: 0002.b57af852 => 0002.b57ba3bd (open count=1)
12/20 09:05:53.940358 [CLR][0] 68 tc_mr.c :1403 invalid logfile(/data2/tbdata/arclog/log-t0-r0-s254407.arc, seq#254407): too old
12/20 09:05:54.034310 [CLC][0] 68 tc_mr.c :1466 MR set next logfile (THREAD#0, seq 254408) - /data1/tbdata/log011.log
12/20 09:05:54.038586 [CLC][0] 68 tc_cf_df:1945 DATAFILES OPEN: for recovery (stop ffff.ffffffff)
12/20 09:05:57.352220 [CLD][0] 68 tc_pool.:476 Wating Buffer Flushed (fileq=0, ckptq=0, recoq=1)
12/20 09:05:57.352303 [CLD][0] 68 tc_pool.:582 recoQ flushed until 0002.b57c080f
12/20 09:05:57.352712 [CLC][0] 68 tc_cf.c :1846 REDO THREAD #0 CKPT updated to 0002.b57c0810/0.0 (prev 0002.b57ba3bd/0.0)
12/20 09:05:57.352745 [CLC][0] 68 tc_cf.c :1797 DB CKPT updated: 0002.b57ba3bd => 0002.b57c0810 (open count=1)
12/20 09:05:57.455833 [CLR][0] 68 tc_mr.c :1328 MR finished until 0002.b57c0810
12/20 09:05:57.624561 [DDL][0] 68 ddl_data:1487 Alter database type 0 succeeded.
12/20 09:05:57.642622 [DDL][0] 68 ddl_fram:174 DDL execution succeeded


18.232.179.37


  LIST

제목 작성자 작성일 조회
Troubleshoot  ERROR: bind error (port=8200) [Address already in use]    최길호 2022/02/18 166
Admin  Tibero 5 , SP1, patch, downgrad 메모    최길호 2021/02/10 2148
Admin  tibero jdbc driver version 확인    최길호 2021/02/01 542
Admin  rename db name / TB_SID    최길호 2021/02/01 958
Troubleshoot  T-UP / SELECT COUNT(*) FROM ALL_TYPES WHERE TYPE_NAME = 'XMLTYPE'    최길호 2021/02/01 5310
Backup and Recovery  alter database backup controlfile to trace / CREATE CONTROLFILE / alter system set _CF_DD_CHECK=N    최길호 2021/01/29 407
Troubleshoot  interal dd update failed!! [ patch 필요 ]    최길호 2020/12/20 69859
Backup and Recovery  TBR-1024 : Database needs media recovery    최길호 2020/12/20 2586
Troubleshoot  * Cannot get semaphore:errno=28    최길호 2019/03/06 4298
Backup and Recovery  tbexport TBR-90401: JDBC-90401:Connection refused by the server. - Connection refused    최길호 2019/02/15 3704
Troubleshoot  TBR-8033: Specified schema object was not found.    최길호 2018/07/11 157338
Admin  tibero6 수동 설치    최길호 2018/07/11 25930
Backup and Recovery  TBR-1004: Unable to read file TBR-7004: This DDL statement is not permitted    최길호 2017/11/26 2931
Admin  Tibero SQL Trace [ SQL_TRACE / DBMS_SYSTEM.SET_SQL_TRACE_IN_SESSION / SET AUTOTRACE ON / v$sql_plan ]    최길호 2017/09/06 16183
Admin  Tibero 모니터링 가이드 - TechNet    최길호 2017/09/05 16252
Troubleshoot  java.sql.SQLSyntaxErrorException: ORA-00924: missing BY keyword    최길호 2016/08/25 3384
Troubleshoot  Oracle dblink Tibero UTF8 DB 한글처리    최길호 2015/09/08 10914

    목록보기   다음페이지 1 [2]
       

Copyright 1999-2023 Zeroboard / skin by 최길호(gilho.kr@gmail.com)
최근 댓글
최근 게시물
09/27
[ORACLE]
auto compile [ dba_objects LAS....
by 최길호
09/25
[ORACLE]
verify_queryable_inventory ret....
by 최길호
09/11
[운영체제]
ntfy.sh / 푸시 알림 보내기.
by 최길호