|
|
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
|
|
|
|
Copyright 1999-2022 Zeroboard / skin by 최길호(gilho.kr@gmail.com)
|
|
|
08/10 