Environment for oracle RAC + DG 11.2.0.4.0 double node, the main library file stored in Shared memory, for the inventory in the local found last archive logs should not be used, and wait for the next log application, please help to see how real time synchronization, real-time applications, don't delay, thank you





Check the MRP0 WAIT_FOR_LOG

CodePudding user response:

Show parameter log_archive;
Select the name, SWITCHOVER_STATUS open_mode PROTECTION_MODE, DATABASE_ROLE from v $database;
The select DEST_NAME, STATUS, RECOVERY_MODE from v $archive_dest_status;
Select the process, the status, sequence# from v $managed_standby;
Lord for libraries to see where the