增量恢复DG备库（备库出现坏块）.txt
10墨值下载
某数据库 DG 备库 alert 如下：
Sat Jan 04 06:01:23 2020
Primary database is in MAXIMUM PERFORMANCE mode
RFS[9091]: Assigned to RFS process 8839
RFS[9091]: Selected log 8 for thread 2 sequence 7135 dbid -77625695 branch
897561377
Recovery of Online Redo Log: Thread 2 Group 8 Seq 7135 Reading mem 0
Mem# 0: /picclife/app/oracle/oradata/dgzpdb/onlinelog/group_8.273.979309971
Sat Jan 04 06:11:43 2020
Hex dump of (file 2, block 66000) in trace file
/picclife/app/oracle/diag/rdbms/dgzpdb/dgzpdb/trace/dgzpdb_pr02_2388.trc
Reading datafile '/picclife/app/oracle/oradata/dgzpdb/sysaux.261.897561385' for
corruption at rdba: 0x008101d0 (file 2, block 66000)
Reread (file 2, block 66000) found same corrupt data (logically corrupt)
Errors in file
/picclife/app/oracle/diag/rdbms/dgzpdb/dgzpdb/trace/dgzpdb_pr02_2388.trc
(incident=6273):
ORA-00600: internal error code, arguments: [3020], [2], [66000], [8454608], [],
[], [], [], [], [], [], []
ORA-10567: Redo is inconsistent with data block (file# 2, block# 66000, file
offset is 540672000 bytes)
ORA-10564: tablespace SYSAUX
ORA-01110: data file 2:
'/picclife/app/oracle/oradata/dgzpdb/sysaux.261.897561385'
ORA-10560: block type 'FIRST LEVEL BITMAP BLOCK'
Incident details in:
/picclife/app/oracle/diag/rdbms/dgzpdb/dgzpdb/incident/incdir_6273/dgzpdb_pr02_2
388_i6273.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Slave exiting with ORA-600 exception
Errors in file
/picclife/app/oracle/diag/rdbms/dgzpdb/dgzpdb/trace/dgzpdb_pr02_2388.trc:
ORA-00600: internal error code, arguments: [3020], [2], [66000], [8454608], [],
[], [], [], [], [], [], []
ORA-10567: Redo is inconsistent with data block (file# 2, block# 66000, file
offset is 540672000 bytes)
ORA-10564: tablespace SYSAUX
ORA-01110: data file 2:
'/picclife/app/oracle/oradata/dgzpdb/sysaux.261.897561385'
ORA-10560: block type 'FIRST LEVEL BITMAP BLOCK'
Sat Jan 04 06:11:45 2020
Dumping diagnostic data in directory=[cdmp_20200104061145], requested by
(instance=1, osid=2388 (PR02)), summary=[incident=6273].
Sat Jan 04 06:11:46 2020
Errors in file
/picclife/app/oracle/diag/rdbms/dgzpdb/dgzpdb/trace/dgzpdb_mrp0_2382.trc
(incident=6233):
ORA-00600: internal error code, arguments: [3020], [2], [66000], [8454608], [],
[], [], [], [], [], [], []
ORA-10567: Redo is inconsistent with data block (file# 2, block# 66000, file
offset is 540672000 bytes)
ORA-10564: tablespace SYSAUX
ORA-01110: data file 2:
'/picclife/app/oracle/oradata/dgzpdb/sysaux.261.897561385'
ORA-10560: block type 'FIRST LEVEL BITMAP BLOCK'
Incident details in:
/picclife/app/oracle/diag/rdbms/dgzpdb/dgzpdb/incident/incdir_6233/dgzpdb_mrp0_2
382_i6233.trc
Sat Jan 04 06:11:46 2020
Sweep [inc][6273]: completed
Sweep [inc][6233]: completed
Sweep [inc2][6273]: completed
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Recovery Slave PR02 previously exited with exception 600
Sat Jan 04 06:11:47 2020
MRP0: Background Media Recovery terminated with error 448
Errors in file
/picclife/app/oracle/diag/rdbms/dgzpdb/dgzpdb/trace/dgzpdb_pr00_2384.trc:
ORA-00448: normal completion of background process
Managed Standby Recovery not using Real Time Apply
Recovery interrupted!
Tue Jan 07 15:15:09 2020
Managed Standby Recovery starting Real Time Apply
Parallel Media Recovery started with 4 slaves
Waiting for all non-current ORLs to be archived...
All non-current ORLs have been archived.
Media Recovery Log
/picclife/app/oracle/arch/DGZPDB/archivelog/2020_01_04/o1_mf_2_7135_h0zm0g77_.ar
c
Media Recovery Log
/picclife/app/oracle/arch/DGZPDB/archivelog/2020_01_04/o1_mf_1_7624_h0zm0h9l_.ar
c
Tue Jan 07 15:15:09 2020
Errors in file
/picclife/app/oracle/diag/rdbms/dgzpdb/dgzpdb/trace/dgzpdb_pr02_23335.trc
(incident=6258):
ORA-00600: internal error code, arguments: [3020], [2], [66000], [8454608], [],
[], [], [], [], [], [], []
ORA-10567: Redo is inconsistent with data block (file# 2, block# 66000, file
offset is 540672000 bytes)
ORA-10564: tablespace SYSAUX
ORA-01110: data file 2:
'/picclife/app/oracle/oradata/dgzpdb/sysaux.261.897561385'
ORA-10560: block type 'FIRST LEVEL BITMAP BLOCK'
Incident details in:
/picclife/app/oracle/diag/rdbms/dgzpdb/dgzpdb/incident/incdir_6258/dgzpdb_pr02_2
3335_i6258.trc
Completed: alter database recover managed standby database using
current logfile disconnect from session
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Slave exiting with ORA-600 exception
Errors in file
/picclife/app/oracle/diag/rdbms/dgzpdb/dgzpdb/trace/dgzpdb_pr02_23335.trc:
ORA-00600: internal error code, arguments: [3020], [2], [66000], [8454608], [],
[], [], [], [], [], [], []
ORA-10567: Redo is inconsistent with data block (file# 2, block# 66000, file
offset is 540672000 bytes)
ORA-10564: tablespace SYSAUX
ORA-01110: data file 2:
'/picclife/app/oracle/oradata/dgzpdb/sysaux.261.897561385'
ORA-10560: block type 'FIRST LEVEL BITMAP BLOCK'
Errors in file
/picclife/app/oracle/diag/rdbms/dgzpdb/dgzpdb/trace/dgzpdb_mrp0_23319.trc
(incident=6235):
ORA-00600: internal error code, arguments: [3020], [2], [66000], [8454608], [],
[], [], [], [], [], [], []
ORA-10567: Redo is inconsistent with data block (file# 2, block# 66000, file
offset is 540672000 bytes)
ORA-10564: tablespace SYSAUX
ORA-01110: data file 2:
'/picclife/app/oracle/oradata/dgzpdb/sysaux.261.897561385'
of 7
10墨值下载
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文档的来源（墨天轮），文档链接，文档作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
下载排行榜
评论