oracle block recover笔记



select * from dba_segments where owner='TEST';--header_block=10
[oracle@oel ~]$ dd of=/u01/app/oracle/oradata/orcl/test01.dbf bs=8192 conv=notrunc seek=11 <<EOF
> asdfsdfadf
> EOF
0+1 records in
0+1 records out
11 bytes (11 B) copied, 0.000609742 s, 18.0 kB/s
[oracle@oel ~]$
SQL> alter system flush buffer_cache;

 

System altered.

 

SQL> select * from test.employees;
select * from test.employees
*
ERROR at line 1:
ORA-01578: ORACLE data block corrupted (file # 7, block # 11)
ORA-01110: data file 7: '/u01/app/oracle/oradata/orcl/test01.dbf'

 

SQL>

 

[oracle@oel ~]$ dbv file=/u01/app/oracle/oradata/orcl/test01.dbf blocksize=8192

 

DBVERIFY: Release 11.2.0.4.0 - Production on Thu Feb 15 22:36:23 2018

 

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

 

DBVERIFY - Verification starting : FILE = /u01/app/oracle/oradata/orcl/test01.dbf
Page 11 is marked corrupt
Corrupt block relative dba: 0x01c0000b (file 7, block 11)
Bad header found during dbv:
Data in bad block:
 type: 97 format: 3 rdba: 0x61666473
 last change scn: 0x0000.000a6664 seq: 0x2 flg: 0x04
 spare1: 0x64 spare2: 0x66 spare3: 0x0
 consistency value in tail: 0x9b560602
 check value in block header: 0xe6ef
 computed block checksum: 0x4ef4

 

 

 

DBVERIFY - Verification complete

 

Total Pages Examined         : 128
Total Pages Processed (Data) : 1
Total Pages Failing   (Data) : 0
Total Pages Processed (Index): 0
Total Pages Failing   (Index): 0
Total Pages Processed (Other): 66
Total Pages Processed (Seg)  : 0
Total Pages Failing   (Seg)  : 0
Total Pages Empty            : 60
Total Pages Marked Corrupt   : 1
Total Pages Influx           : 0
Total Pages Encrypted        : 0
Highest block SCN            : 1153882 (0.1153882)
[oracle@oel ~]$
----------------------------------------------------

 

RMAN> recover corruption list;

 

Starting recover at 15-FEB-18
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=69 device type=DISK

 

channel ORA_DISK_1: restoring block(s)
channel ORA_DISK_1: specifying block(s) to restore from backup set
restoring blocks of datafile 00007
channel ORA_DISK_1: reading from backup piece /u01/app/oracle/fast_recovery_area/ORCL/backupset/2018_02_15/o1_mf_nnndf_TAG20180215T221003_f8dlwvoo_.bkp
channel ORA_DISK_1: piece handle=/u01/app/oracle/fast_recovery_area/ORCL/backupset/2018_02_15/o1_mf_nnndf_TAG20180215T221003_f8dlwvoo_.bkp tag=TAG20180215T221003
channel ORA_DISK_1: restored block(s) from backup piece 1
channel ORA_DISK_1: block restore complete, elapsed time: 00:00:01

 

starting media recovery
media recovery complete, elapsed time: 00:00:01

 

Finished recover at 15-FEB-18

 

RMAN>
----------------------------------------------------------
RMAN> blockrecover datafile 7 block 11;

 

Starting recover at 15-FEB-18
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=8 device type=DISK

 

channel ORA_DISK_1: restoring block(s)
channel ORA_DISK_1: specifying block(s) to restore from backup set
restoring blocks of datafile 00007
channel ORA_DISK_1: reading from backup piece /u01/app/oracle/fast_recovery_area/ORCL/backupset/2018_02_15/o1_mf_nnndf_TAG20180215T221003_f8dlwvoo_.bkp
channel ORA_DISK_1: piece handle=/u01/app/oracle/fast_recovery_area/ORCL/backupset/2018_02_15/o1_mf_nnndf_TAG20180215T221003_f8dlwvoo_.bkp tag=TAG20180215T221003
channel ORA_DISK_1: restored block(s) from backup piece 1
channel ORA_DISK_1: block restore complete, elapsed time: 00:00:01

 

starting media recovery
media recovery complete, elapsed time: 00:00:03

 

Finished recover at 15-FEB-18

RMAN>
----------------------------------------------------------------