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 [2896]
PostgreSQL [103]
기타정보 [150]
운영체제 [583]
04.Q/A Book
Q/A [53]
05.방명록
방명록 [54]
레벨업 [37]
구인/구직 [2]

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

 회원가입

RMAN> validate database ; [ dbv DBV-00201: Block, DBA 50513350, marked corrupt for invalid redo application ]
최길호 [LIST]   2021-09-22 11:41:37, 조회 : 293


backup as copy database auxiliary format '/oradata/DB19/%N.%f.dbf' reuse;
ORA-01578: ORACLE data block corrupted [ archvielog에 logging=no로 인해 데이터가 없어서 발생 가능 ]

dbv file=xxxx blocksize=8192
DBV-00201: Block, DBA 50513350, marked corrupt for invalid redo application
=> Error DBV-201 Marked Corrupt For Invalid Redo Application (Doc ID 453278.1)
     LOGGING=NO 인경우 발생

Standby DB는 수시로 dbv 체크가 필요 하다.

$ rman target /

Recovery Manager: Release 19.0.0.0.0 - Production on Wed Sep 22 11:48:22 2021
Version 19.11.0.0.0

Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved.

connected to target database: DB19 (DBID=3912457685)

RMAN> validate database ;

Starting validate at 2021/09/22 11:48
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=2737 device type=DISK
channel ORA_DISK_1: starting validation of datafile
channel ORA_DISK_1: specifying datafile(s) for validation
input datafile file number=00102 name=/oradata/DB19/TS_DATIS20_D01.102.dbf
input datafile file number=00104 name=/oradata/DB19/TS_DATIS20_D01.104.dbf
input datafile file number=00106 name=/oradata/DB19/TS_DATIS20_I01.106.dbf
....
input datafile file number=00031 name=/oradata/DB19/TS_ICPRO_DAT.31.dbf
input datafile file number=00032 name=/oradata/DB19/TS_ICPRO_IDX.32.dbf
input datafile file number=00033 name=/oradata/DB19/TS_NOTES_D01.33.dbf
input datafile file number=00004 name=/oradata/DB19/USERS.4.dbf
channel ORA_DISK_1: validation complete, elapsed time: 00:57:54
List of Datafiles
=================
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
2    OK     0              5509         1640947         16688041792712
  File Name: /oradata/DB19/UNDOTBS1.2.dbf
  Block Type Blocks Failing Blocks Processed
  ---------- -------------- ----------------
  Data       0              0              
  Index      0              0              
  Other      0              1635438
....
....

channel ORA_DISK_1: starting validation of datafile
channel ORA_DISK_1: specifying datafile(s) for validation
input datafile file number=00003 name=/oradata/DB19/SYSAUX.3.dbf
input datafile file number=00001 name=/oradata/DB19/SYSTEM.1.dbf
input datafile file number=00005 name=/oradata/DB19/EXAMPLE.5.dbf
channel ORA_DISK_1: validation complete, elapsed time: 00:57:26
List of Datafiles
=================
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
1    OK     0              42193        256000          16688041795946
  File Name: /oradata/DB19/SYSTEM.1.dbf
  Block Type Blocks Failing Blocks Processed
  ---------- -------------- ----------------
  Data       0              140426          
  Index      0              41117          
  Other      0              32264  
....
....

channel ORA_DISK_1: starting validation of datafile
channel ORA_DISK_1: specifying datafile(s) for validation
including current control file for validation
channel ORA_DISK_1: validation complete, elapsed time: 00:00:01
List of Control File and SPFILE
===============================
File Type    Status Blocks Failing Blocks Examined
------------ ------ -------------- ---------------
Control File OK     0              3508            
Finished validate at 2021/09/22 13:44



COLUMN owner FORMAT A20
COLUMN segment_name FORMAT A30

SELECT DISTINCT owner, segment_name
FROM   v$database_block_corruption dbc
       JOIN dba_extents e ON dbc.file# = e.file_id AND dbc.block# BETWEEN e.block_id and e.block_id+e.blocks-1
ORDER BY 1,2;
18.207.157.152


  LIST

제목 작성자 작성일 조회
Install and Config  ASM Filter / asmcmd afd_label / asmcmd afd_lslbl / gridSetup.sh 설치전 asm disk    최길호 2021/10/07 288
Troubleshoot  sqlplus: /lib64/libc.so.6: version `GLIBC_2.14' not found    최길호 2021/10/06 692
Troubleshoot  19c _optimizer_cost_based_transformation off bug [ SR 확인 ] lv:9   최길호 2021/10/05 889
Troubleshoot  ORA-12609: TNS: Receive timeout occurred    최길호 2021/10/03 1009
Troubleshoot  EXP-00083: The previous problem occurred when calling SYS.DBMS_AUTO_TASK_EXPORT.system_info_exp    최길호 2021/10/02 796
Troubleshoot  grid 19c crsctl start has / CRS-41053 / Infrastructure has 재구축    최길호 2021/10/01 833
Troubleshoot  ORA-04036: PGA memory used by the instance exceeds PGA_AGGREGATE_LIMIT    최길호 2021/09/30 277
Admin  alter table add column large table [ 11gR2 부터 빠르다 ]    최길호 2021/09/29 261
Troubleshoot  ORA-15411 alter diskgroup data2 offline disks in failgroup fg1 / alter diskgroup data2 add failgroup fg1    최길호 2021/09/29 486
Troubleshoot  alter diskgroup data1 add failgroup fg1 DISK '/dev/sdb' name DATA1_0000 / drop disk    최길호 2021/09/28 3969
Install and Config  create diskgroup data1 normal redundancy failgroup fg1 disk    최길호 2021/09/28 310
Troubleshoot  [INS-30525] Insufficient number of failure groups specified for Normal Redundancy level.    최길호 2021/09/28 291
Troubleshoot  PRVG-11095 : The TCP system call "connect" failed with error "113"    최길호 2021/09/28 341
Troubleshoot  ORA-00600: internal error code, arguments: [tsdrv1-Bug#24841100]    최길호 2021/09/25 345
Install and Config  ORA-24247: network access denied by access control list (ACL)    최길호 2021/09/24 314
Troubleshoot  ORA-12805 Parallel Query Server Died    최길호 2021/09/23 369

    목록보기   이전페이지   다음페이지 [1][2][3][4][5][6] 7 [8][9][10]..[145]   [다음 10개]
       

Copyright 1999-2022 Zeroboard / skin by 최길호(gilho.kr@gmail.com)
최근 댓글
2021/06/30
윈도우 서버에서 sqlplus .... ORA-...
by 최길호
2021/06/30
ORA-28500: connection from O...
by 최길호
2019/05/02
pkg 확인 SELECT * FROM AL...
by 최길호
최근 게시물
08/10
[운영체제]
mobaxterm Remote desktop (RDP,....
by 최길호
08/09
[ORACLE]
ORA-12521 listener does not cu....
by 최길호
08/08
[ORACLE]
ogg save table DML total count....
by 최길호