Oracle Database Discussions

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!

Dataguard 11g

Beauty_and_dBestJan 23 2020 — edited Jan 31 2020

11.2.0.4 Database

OL6

Hi ALL,

We have configured dataguard in our database.

It has been running for more than a year.

But lately, I got report that it is not syncing from primary to the standby.

The report I run is below , which is run at the primary database:

SQL> ALTER SESSION SET nls_date_format='DD-MON-YYYY HH24:MI:SS';

Session altered.

SQL> SELECT sequence#, first_time, next_time,archived,applied,deleted FROM v$archived_log where first_time > sysdate -1

ORDER BY sequence#;

SEQUENCE# FIRST_TIME NEXT_TIME ARC APPLIED DEL

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

13280 23-JAN-2020 11:48:00 23-JAN-2020 14:03:18 YES NO NO

13281 23-JAN-2020 14:03:18 23-JAN-2020 14:31:40 YES NO NO

13282 23-JAN-2020 14:31:40 23-JAN-2020 14:34:21 YES NO NO

13283 23-JAN-2020 14:34:21 23-JAN-2020 14:38:58 YES NO NO

13284 23-JAN-2020 14:38:58 23-JAN-2020 14:42:54 YES NO NO

13285 23-JAN-2020 14:42:54 23-JAN-2020 14:49:09 YES NO NO

13286 23-JAN-2020 14:49:09 23-JAN-2020 14:54:50 YES NO NO

13287 23-JAN-2020 14:54:50 23-JAN-2020 16:01:38 YES NO NO

13288 23-JAN-2020 16:01:38 23-JAN-2020 18:58:15 YES NO NO

13289 23-JAN-2020 18:58:15 23-JAN-2020 21:54:34 YES NO NO

13290 23-JAN-2020 21:54:34 23-JAN-2020 23:31:16 YES NO NO

13291 23-JAN-2020 23:31:16 24-JAN-2020 01:00:07 YES NO NO

13292 24-JAN-2020 01:00:07 24-JAN-2020 01:17:25 YES NO NO

13293 24-JAN-2020 01:17:25 24-JAN-2020 01:17:42 YES NO NO

13294 24-JAN-2020 01:17:42 24-JAN-2020 04:09:03 YES NO NO

13295 24-JAN-2020 04:09:03 24-JAN-2020 06:32:30 YES NO NO

13296 24-JAN-2020 06:32:30 24-JAN-2020 08:12:33 YES NO NO

13297 24-JAN-2020 08:12:33 24-JAN-2020 10:07:07 YES NO NO

24 rows selected.

But if I run below on both primary and standby , the archivelogs list is sync or updated.

$ sqlplus sys/manager@PROD as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Fri Jan 24 10:48:31 2020

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> archive log list;

Database log mode Archive Mode

Automatic archival Enabled

Archive destination /oracle/PROD/db/apps_st/data/archive

Oldest online log sequence 13297

Next log sequence to archive 13298

Current log sequence 13298

SQL>

$ sqlplus sys/manager@STBY as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Fri Jan 24 10:49:58 2020

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> archive log list;

Database log mode Archive Mode

Automatic archival Enabled

Archive destination /oracle/PROD/db/apps_st/data/archive

Oldest online log sequence 13296

Next log sequence to archive 0

Current log sequence 13297

SQL>

Please help why I got report error?

Kind regards,

This post has been answered by Sunny kichloo on Jan 24 2020

Jump to Answer

Added on Jan 23 2020

#general-database-discussions

5 comments

311 views