Is there any commands for checking the complete database individual objects for corruption?
What is consistency check procedures and its requirment?
Kindly share your views here.
Thanks in advance.
Consistency check procedures is nothing but various procedures for identifying corruption, corruption is also referred to as an inconsistency. A consistency check is required to periodically verify that your database is not corrupted. Also, in the event of a corruption being found, a consistency check needs to be carried out on the complete database in order to detect possible further corruption.
You can check your complete database or individual objects for corruption by testing archive logs.
Read here How to Test Archive Logs into Standby Database?
Sign up for STechies
Ask Question From Our Experts