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';
dd of=/u01/app/oracle/oradata/DEVDB/users01.dbf bs=8192 conv=notrunc seek=147 -- EOF
corruption test
EOF
alter system flush buffer_cache;
select * from scott.emp;
backup validate database archivelog all;
select * from V$DATABASE_BLOCK_CORRUPTION;
select * from scott.emp;
docs.oracle.com/cd/B10501_01/...
dbv file=/u01/app/oracle/oradata/DEVDB/users01.dbf blocksize=8192
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;
select * from scott.emp;
#BlockCorruption #RMANRecovery #DatafileBlockCorruption #Restore #Recovery #ASM #Oracle #RAC #Database #Exadata #ASM
Please do follow me and support me on,
LinkedIn: / mallik034
CZcams: / mallik034
Fakebook: / mallik034
Blog: mallik034.blogspot.com
twitter: / mallik034
Instagram: / mallik034
FBPage: / mallik034oracledba
Skype: malluramadurg
Regards,
Mallikarjun Ramadurg
Mobile: [phone]
WhatsApp: [phone]
Email: [e-mail]
LinkedIn: / mallik034
CZcams: / mallik034
Fakebook: / mallik034
Blog: mallik034.blogspot.com
twitter: / mallik034
Instagram: / mallik034
FBPage: / mallik034oracledba
Skype: malluramadurg

[@padmajarani9392]

Very informative and useful video. Thank you so much brother

[@omarc4ut]

Good scenario and explanation. Well done. 👍

[@kirandaware9003]

Awesome explanation..thanks a lot :)

[@ChanduPanther]

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

[@BHARARHROYAL]

Good 👍 session and clear explanation.

[@Mallik034]

Thanks

[@anandparmar6106]

Thankew its very helpful video of Block corruption

[@Mallik034]

You are welcome

[@vinukondakalyan9798]

Thank you very much sir
Please make more videos

[@Mallik034]

Sure noted

[@vaishakhsvaish5017]

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 ?

[@vigneshs1779]

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

[@sachinmaurya9107]

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

[@anusab1099]

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 name............I have seen solution in oracle support but not help me .Do you any suggestion on this .
Reply

[@vinukondakalyan9798]

Can we recover corrupt block without rman backup??

[@asnvijayasimhareddy9746]

Hi Mallik
Is it possible to share the document..

[@Mallik034]

All the commands are in the video description.
You can get it from there.

[@asnvijayasimhareddy9746]

@@Mallik034 sure thank you