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

Channel Avatar
Comment
X
Share
RMAN Recovery Scenario - Few Blocks in Datafile got corrupted - How to Restore Corrupted Blocks?
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 bs8192 convnotrunc seek147 — EOF
corruption test
EOF

alter system flush buffer_cache;

select * from scott.emp;

backup validate database archivelog all;

select * from VDATABASE_BLOCK_CORRUPTION;

select * from scott.emp;

https://docs.oracle.com/cd/B10501_01/server.920/a96652/ch13.htm

dbv file/u01/app/oracle/oradata/DEVDB/users01.dbf blocksize8192

col FILE_NAME for a50
select FILE_NAME, FILE_ID from dba_data_files;

recover datafile 4 block 147;

select * from VDATABASE_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: https://www.linkedin.com/in/mallik034
YouTube: https://www.youtube.com/c/mallik034
Fakebook: https://www.facebook.com/mallik034
Blog: https://mallik034.blogspot.com
twitter: https://twitter.com/mallik034
Instagram: https://www.instagram.com/mallik034
FBPage: https://www.facebook.com/mallik034oracledba
Skype: malluramadurg

Regards,
Mallikarjun Ramadurg
Mobile: 91 9880616848
WhatsApp: 91 9880616848
Email: [email protected]
LinkedIn: https://www.linkedin.com/in/mallik034
YouTube: https://www.youtube.com/c/mallik034
Fakebook: https://www.facebook.com/mallik034
Blog: https://mallik034.blogspot.com
twitter: https://twitter.com/mallik034
Instagram: https://www.instagram.com/mallik034
FBPage: https://www.facebook.com/mallik034oracledba
Skype: malluramadurg

Take the opportunity to connect and share this video with your friends and family if you find it useful.

Read Also

Leave a Reply

Your email address will not be published. Required fields are marked *