Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Oracle DataGuard sequence # is not same in both server

user13134974Jul 13 2015 — edited Jul 13 2015

Hi

Just I created Oracle Data guard 11g with 4 TB data in test environment. After completion I got some errors. But the main issue is , in both server sequence # in not same.

Primary node

--------------------

SQL> select SEQUENCE#,APPLIED from v$archived_log  where SEQUENCE#=(select max(SEQUENCE#) from v$archived_log);

SEQUENCE# APPLIED

---------- ---------

     97380 NO

Standby

-------------

SQL> select SEQUENCE#,APPLIED from v$archived_log  where SEQUENCE#=(select max(SEQUENCE#) from v$archived_log);

SEQUENCE# APPLIED

---------- ---------

       772 YES

Errors after completion Data guard

---------------------------------------------------

RMAN-05535: WARNING: All redo log files were not defined properly.

ORACLE error from auxiliary database: ORA-19527: physical standby redo log must be renamed

ORA-00312: online log 13 thread 0: '/oradata1/pblprod/redo13.log'

RMAN-05535: WARNING: All redo log files were not defined properly.

Finished Duplicate Db at 09-JUL-15

RMAN>

Regards

Rabi

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 10 2015
Added on Jul 13 2015
5 comments
848 views