RMAN Recovery Scenario - Few Blocks in Datafile got corrupted - How to Restore Corrupted Blocks?

Few Blocks in Datafile got corrupted

SELECT header_block FROM dba_segments WHERE segment_name='EMP';

select OWNER, TABLESPACE_NAME, header_block FROM dba_segments WHERE segment_name='EMP';

col FILE_NAME for a50
select FILE_NAME, TABLESPACE_NAME from dba_data_files where TABLESPACE_NAME='USERS';

corruption test
EOF

alter system flush buffer_cache;

backup validate database archivelog all;

select * from V$DATABASE_BLOCK_CORRUPTION;

col FILE_NAME for a50
select FILE_NAME, FILE_ID from dba_data_files;

recover datafile 4 block 147;

select * from V$DATABASE_BLOCK_CORRUPTION;

#BlockCorruption #RMANRecovery #DatafileBlockCorruption #Restore #Recovery #ASM #Oracle #RAC #Database #Exadata #ASM

Please do follow me and support me on,

Skype: malluramadurg

Regards,
Mallikarjun Ramadurg
Mobile: [phone]
WhatsApp: [phone]
Skype: malluramadurg

[padmajarani]

Very informative and useful video. Thank you so much brother

[omarcut]

Good scenario and explanation. Well done. 👍

[ChanduPanther]

Lovely one sir... well explanation and easy to understand.

[anandparmar]

Thankew its very helpful video of Block corruption

[vinukondakalyan]

Thank you very much sir
Please make more videos

[sachinmaurya]

sir one thing needs clarification from where did you recover the corrupted datafile.

[vaishakhsvaish]

we don't have standby db instance, this case we need to take downtime on oracle database when we are trying de-corrupt particular datafile ?

[vigneshs]

sir how did u get seek=147 in the command dd of ?

[vinukondakalyan]

Can we recover corrupt block without rman backup??

[anusab]

Hi Sir,
Hi the vedio is very useful and I am faceing issue in migration the database of 98GB from prod to test 1:It is taking huge time almost 24 hrs to finish the expdp 2:While exporting im getting errors like ORA-31693, ORA-02354: error in exporting/importing data
ORA-01555: snapshot too old: rollback segment number 55 with have seen solution in oracle support but not help me .Do you any suggestion on this .




Reply

[asnvijayasimhareddy]

Hi Mallik
Is it possible to share the document..