TCS Oracle Database Administrator Interview Questions, Process, and Tips for Experienced

Issues faced during datapatch include conflicts with existing patches, errors during patching process, and compatibility issues.

• Conflicts with existing patches can cause datapatch to fail

• Errors during the patching process may require troubleshooting and reapplying the patch

• Compatibility issues with the database version or components can lead to issues with datapatch

Physical stand-by is a standby database that is an exact replica of the primary database, while snapshot standby is a read-only standby database that allows for testing and reporting.

• Physical stand-by is an exact replica of the primary database, maintained through redo apply.

• Snapshot standby is a read-only standby database that allows for testing and reporting.

• Snapshot standby can be converted back to a physical stand-

Restoration steps in RAC involve restoring the database files, recovering the database, and reconfiguring the RAC environment.

• Restore the database files from backup using RMAN

• Recover the database using RMAN

• Reconfigure the RAC environment by starting the instances and services

Configuration parameters play a crucial role in setting up Data Guard for Oracle databases.

• LOG_ARCHIVE_DEST_1 and LOG_ARCHIVE_DEST_2 are used to specify the locations where archived redo logs are stored.

• FAL_SERVER and FAL_CLIENT parameters are used for automatic recovery in case of a failover.

• DB_UNIQUE_NAME parameter is used to uniquely identify each database in a Data Guard configuration.

• LOG_ARCHIVE_CONFIG parameter i...read more