Physical standby is not in sync
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';