The main purpose is to check for corrupt blocks and missing files.
There are two types of corruptions
1. Physical corruption
2. Logical corruption
In physical corruption/media corruption, the database does not recognize the block at all and the checksum is invalid.
In a logical corruption, the contents of the block are logically inconsistent. By default RMAN doesn’t check for logical corruption. Use “CHECK LOGICAL” with BACKUP or RESTORE command to check for logical and physical corruption using RMAN.
It’s advised to set DB_BLOCK_CHECKSUM=typical in the initialization parameter file of a database, set so that the database calculates datafile checksums automatically (not for backups). The BACKUP command computes checksum for each block and stores it in the backup. If you specify NOCHECKSUM while creating backup then RMAN does not perform a checksum of the blocks.
Note that Automatic Diagnostic Repository (ADR) tracks all types of corruptions.
VALIDATE:-
Run below command to validate Database
RMAN> VALIDATE DATABASE;
Run below command to validate Backup set
RMAN> VALIDATE BACKUPSET 10;
Run below command to validate individual data blocks within a data file for block corruption
RMAN> VALIDATE DATAFILE 1 BLOCK 10;
Click here for Block recovery using RMAN.
BACKUP VALIDATE:-
Use BACKUP VALIDATE to check datafile logical/physical corruptions and check all database files exists in correct location. Do not use the BACKUPSET, MAXCORRUPT, or PROXY parameters with BACKUP VALIDATE.
Run below command to validate all database files and archived logs. This command checks for physical corruptions only.
RMAN> BACKUP VALIDATE DATABASE ARCHIVELOG ALL;
Run below command to check for logical corruptions and physical corruptions.
RMAN> BACKUP VALIDATE CHECK LOGICAL DATABASE ARCHIVELOG ALL;
Click here to Validate restore using RMAN.
Regards,
Satishbabu Gunukula
http://www.oracleracexpert.com/
Subscribe to:
Post Comments (Atom)
Great and Useful Article.
ReplyDeleteJava Online Training
Java Course Online
Java EE course
Java Course in Chennai
Java Training in Chennai
Java Training Institutes in Chennai
Java Interview Questions
Java Interview Questions
شركة نقل اثاث بالرياض
ReplyDeleteشركة نقل اثاث بجدة
شركة نقل اثاث بمكة
شركة نقل عفش مكة رخيص
ReplyDeleteأفضل شركة نقل عفش بمكة
شركة نقل عفش فى مكة
شركة نقل اثاث بمكة
نقل أثاث داخل مكة المكرمة
أرخص شركة نقل عفش بمكه
الشركة الدولية لمكافحة الحشرات بجدة
ReplyDeleteافضل شركة مكافحة حشرات بجدة
افضل شركة مكافحة حشرات بجده
أفضل شركة مكافحة بق الفراش فى جدة
أفضل شركة مكافحة الصراصير بجدة
شركة مكافحة فئران فى جدة
أفضل شركة مكافحة النمل الأبيض بجدة
This comment has been removed by the author.
ReplyDelete
ReplyDeleteIt is amazing and wonderful to visit your siteTableau Online Training
Thanks for this wonderful information. You posts are really nice and interesting. Writing style is also very amazing200 Words Independence Day Essay For Students in Malayalam 2018
ReplyDeleteThank you for giving your informational blog with valuable details about this topic. I am really happy to read your article. Keep posting such wonderful info, including us...
ReplyDeleteOracle DBA Training in Chennai
oracle dba training
Advanced Excel Training in Chennai
Spark Training in Chennai
Tableau Training in Chennai
Oracle Training in Chennai
Pega Training in Chennai
Embedded System Course Chennai
Unix Training in Chennai
Oracle DBA Training in T Nagar
Oracle DBA Training in OMR
Superb! Your blog is incredible. I am delighted with it. Thanks for sharing with me more information.
ReplyDeleteHadoop Training in Chennai
Hadoop Training in Bangalore
Big Data Course in Coimbatore
Big data training in chennai
bigdata and hadoop training in chennai
Hadoop Training in Coimbatore
DOT NET Training in Chennai
Python Training in Bangalore
Admire this blog. Keep sharing more updates like this
ReplyDeleteAWS Training in Chennai
AWS Course in Chennai
Aws training in bangalore
Aws training in coimbatore
Best Aws training in bangalore
Aws Training institutes in bangalore
Aws Certification Training in bangalore
Selenium Training in Bangalore
I want to thank for sharing this blog, really great and informative. Share more stuff like this.
ReplyDeleteEthical Hacking course in Chennai
Ethical Hacking Training in Chennai
Hacking course
ccna course in Chennai
Salesforce Training in Chennai
Angular 7 Training in Chennai
Web Designing course in Chennai
Ethical Hacking course in Thiruvanmiyur
Ethical Hacking course in Porur
Ethical Hacking course in Adyar
This comment has been removed by a blog administrator.
ReplyDeleteWonderful Blog!!! Thanks for sharing this post with us... and it is more helpful for us.
ReplyDeleteIOS Training in Chennai
iOS Course in Chennai
Best ios Training institutes in Chennai
ios developer course in chennai
IOS Training in Tnagar
IOS training in Thiruvanmiyur
Big data training in chennai
Software testing training in chennai
Selenium Training in Chennai
JAVA Training in Chennai
python training in bangalore | python online training
ReplyDeleteaws training in bangalore | aws online training
artificial intelligence training in bangalore | artificial intelligence online training
machine learning training in bangalore | machine learning online training
blockchain training in bangalore | blockchain online training
uipath training in bangalore | uipath online training
Nice post. Thanks for sharing! I want people to know just how good this information is in your article. It’s interesting content and Great work. keep it up
ReplyDeleteastrologers in india
astrology online
best astrologer in andhra pradesh
best astrology online
astrology
famous astrologer in andhra pradesh
best astrologer near me
top 10 astrologers in andhra pradesh
Big data is a term that describes the large volume of data – both structured and unstructured – that inundates a business on a day-to-day basis. big data projects for students But it’s not the amount of data that’s important.Project Center in Chennai
ReplyDeleteSpring Framework has already made serious inroads as an integrated technology stack for building user-facing applications. Corporate TRaining Spring Framework the authors explore the idea of using Java in Big Data platforms.
Spring Training in Chennai
The new Angular TRaining will lay the foundation you need to specialise in Single Page Application developer. Angular Training
Cognex is the AWS Training in Chennai. Cognex offer so many courses depends upon the students requriments.
ReplyDeleteThank you for your post. This is excellent information. It is amazing and wonderful to visit your site
ReplyDeleteRAC Training in Bangalore
This blog very easily understandable. Thanks for sharing such an informative post with us. This is a nice post in an interesting line of content.
ReplyDeleteRAC Training in Bangalore
golden goose
ReplyDeletejordan shoes
kyrie 7
kawhi leonard shoes
steph curry shoes
curry shoes
kd 12
jordan shoes
off white
retro jordans