Checking the Physical Standby Database

Physical standby database check

If the source Oracle database is in the incremental migration phase, the instance type of the source must be the same as that of the destination. Otherwise, the migration fails.

Item to be confirmed:

1. The physical standby database does not generate logs. It replicates them from the primary database. Check whether supplemental logging of the primary database meets the incremental synchronization requirements.

   Handling suggestion: Check Oracle supplemental logging.

2. The physical standby database does not generate logs, which results in delay for the synchronization task. You can shorten the interval for archiving logs from the primary database to the physical standby database. However, extremely low values can result in a large number of logs, so your advised to synchronize data from the logical standby database. Run the following statement on the primary database to specify the log archive interval:

   alter system set archive_lag_target=seconds;