High Availability Data Guard, Sharding and Global Data Services (MOSC)

MOSC Banner

Physical standby is not in sync

Hi,

We are using Oracle 10g database 10.2.0.4.0. We have physical standby setup; we have rebuilt the stand by by taking rman incremental backup as it was not in sync, but there was no log shipping happening between the standby and primary. Please suggest us how to move forward to address this.

On Primary:

SQL> archive log list
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            <xxxxxxxx> 
Oldest online log sequence     1922000
Next log sequence to archive   1922009
Current log sequence           1922009

SQL> select max(sequence#) from v$archived_log;

MAX(SEQUENCE#)
--------------
       1922008

SQL> select max(sequence#) from v$archived_log where applied='YES';

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center