Oracle 10 Gb Standby Database real-time application of redo data

Oracle 10 Gb Standby Database real-time application of redo data

------- Physical standby database:

Standby redo log needs to be configured for real-time apply;

When real-time applications are enabled, log application service directly receives redo data without waiting for the current standby redo log archive.

The time for failover and switchover will be greatly reduced because the standby redo log has been applied to the standby database during failover or switchover.

Alter database recover managed standby database using current logfile;

----- For logical standby databases

Alter database start logical standby apply immediate;

The rfs (remote file server) Process on the standby side receives the redo logs sent by the lgwr on the primary side and writes them to standby redo logfiles;

Log application services will apply redo data when the standby redolog is full.

"Panic" caused by Redo logs when RMAN_RAC is restored to a single machine"

Adjust the Redo log file size in Oracle RAC

Restore non-critical Oracle files, Redo, temporary files, index files, and password files

Summary of Oracle Redo Log Mechanism

Oracle Redo log size and number of groups (modify the number of log groups and the number of group members online)

Current online Redo logfile loss Handling Method