bLOCKRECOVER in 11G?

From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Fri, 17 Aug 2012 15:00:02 +0000 (UTC)
Message-ID: <pan.2012.08.17.14.59.28_at_gmail.com>

I've had some brief corruption caused by sunspots (actually, it was a proof of concept DR test, the corrupt blocks were caused by NOLOGGING operations) and I decided to repair blocks by using BLOCKRECOVER CORRUPTION LIST. The database version is 11.2. Everything worked as planned. I then went to check the RMAN manual for 11G and BLOCKRECOVER command is no longer there, it is replaced by the new options to RECOVER

commands. However, BLOCKRECOVER still works as a charm. So does "BACKUP 
VALIDATE" which was superseded by the VALIDATE command. Oh well, the old 
dog is learning the new terminology for the old tricks. VALIDATE command 

in 11G produces a beautiful report:

RMAN> validate database;

Starting validate at 2012-08-17 10:43:38 using channel ORA_DISK_1
channel ORA_DISK_1: starting validation of datafile channel ORA_DISK_1: specifying datafile(s) for validation

input datafile file number=00007 name=/data/oracle/data/O11/test_lob.dbf
input datafile file number=00001 name=/data/oracle/data/O11/system01.dbf
input datafile file number=00002 name=/data/oracle/data/O11/sysaux01.dbf
input datafile file number=00006 name=/data/oracle/data/O11/test_tbs.dbf
input datafile file number=00003 name=/data/oracle/data/O11/undotbs01.dbf
input datafile file number=00005 name=/data/oracle/data/O11/example01.dbf
input datafile file number=00004 name=/data/oracle/data/O11/users01.dbf

channel ORA_DISK_1: validation complete, elapsed time: 00:03:15 List of Datafiles

---

File Status Marked Corrupt Empty Blocks Blocks Examined High SCN ---- ------ -------------- ------------ --------------- ---------- 1 OK 0 246114 327720 2715101   File Name: /data/oracle/data/O11/system01.dbf   Block Type Blocks Failing Blocks Processed

• -------------- ---------------- Data 0 62724 Index 0 13756 Other 0 5086

File Status Marked Corrupt Empty Blocks Blocks Examined High SCN ---- ------ -------------- ------------ --------------- ---------- 2 OK 0 257793 327682 2715099   File Name: /data/oracle/data/O11/sysaux01.dbf   Block Type Blocks Failing Blocks Processed

• -------------- ---------------- Data 0 19854 Index 0 18063 Other 0 31970

File Status Marked Corrupt Empty Blocks Blocks Examined High SCN ---- ------ -------------- ------------ --------------- ---------- 3 OK 0 13977 65536 2715101   File Name: /data/oracle/data/O11/undotbs01.dbf   Block Type Blocks Failing Blocks Processed

• -------------- ---------------- Data 0 0 Index 0 0 Other 0 51559

File Status Marked Corrupt Empty Blocks Blocks Examined High SCN ---- ------ -------------- ------------ --------------- ---------- 4 OK 0 30623 32795 2624870   File Name: /data/oracle/data/O11/users01.dbf   Block Type Blocks Failing Blocks Processed

• -------------- ---------------- Data 0 523 Index 0 100 Other 0 1522

File Status Marked Corrupt Empty Blocks Blocks Examined High SCN ---- ------ -------------- ------------ --------------- ---------- 5 OK 0 54947 65537 2675272   File Name: /data/oracle/data/O11/example01.dbf   Block Type Blocks Failing Blocks Processed

• -------------- ---------------- Data 0 6600 Index 0 1148 Other 0 2841

File Status Marked Corrupt Empty Blocks Blocks Examined High SCN ---- ------ -------------- ------------ --------------- ---------- 6 OK 0 261993 262144 1900091   File Name: /data/oracle/data/O11/test_tbs.dbf   Block Type Blocks Failing Blocks Processed

• -------------- ---------------- Data 0 18 Index 0 0 Other 0 133

File Status Marked Corrupt Empty Blocks Blocks Examined High SCN ---- ------ -------------- ------------ --------------- ---------- 7 OK 0 37402 393216 1900091   File Name: /data/oracle/data/O11/test_lob.dbf   Block Type Blocks Failing Blocks Processed

• -------------- ---------------- Data 0 0 Index 0 95 Other 0 355719

channel ORA_DISK_1: starting validation of datafile channel ORA_DISK_1: specifying datafile(s) for validation including current control file for validation including current SPFILE in backup set
channel ORA_DISK_1: validation complete, elapsed time: 00:00:01 List of Control File and SPFILE

---

File Type Status Blocks Failing Blocks Examined ------------ ------ -------------- ---------------

SPFILE       OK     0              2               
Control File OK     0              600             

Finished validate at 2012-08-17 10:46:55

RMAN>

-- 
Mladen Gogala
http://mgogala.freehostia.com

Received on Fri Aug 17 2012 - 10:00:02 CDT