Why Standby Redo logfiles are required. How to troubleshoot node-eviction in RAC. RTO and RPO. Extended RAC. Managed Database.

Question

Accepted Answer

Standby Redo logfiles are required for data protection and disaster recovery in Oracle databases.

Standby Redo logfiles are essential for maintaining a standby database in Oracle Data Guard for disaster recovery purposes.
They contain a record of changes made to the primary database, which can be applied to the standby database to keep it synchronized.
In case of a primary database failure, the standby database can be activated quickly using the standby redo logfiles to minimize downtime.
Without standby redo logfiles, the standby database would not be able to stay synchronized with the primary database and provide data protection.
Regular monitoring and maintenance of standby redo logfiles is important to ensure they are functioning properly and can be used effectively in case of a disaster.

Popular interview questions of Senior Database Administrator