Data Guard

[Angus John-Phillips]

Hi,

I have an issue still thaat the Standby Database Does Not Receive Redo Data from the Primary Database.

I have issued the following :
STARTUP NOMOUNT;
ALTER DATABASE MOUNT STANDBY DATABASE;
RECOVER MANAGED STANDBY DATABASE;

But the archive sequence appears to be out. Once I look at the O/P from "select process, status from v$managed_standby;" from the standby.

The alert log just says that the archive number is still trying.

Any ideas how to get around this issue.

SQL> SELECT DEST_ID "ID",
2> STATUS "DB_status",
3> DESTINATION "Archive_dest",
4> ERROR "Error"
5> FROM V$ARCHIVE_DEST WHERE DEST_ID <=5;

ID DB_status Archive_dest Error
-- --------- ------------------------------ ------------------------------------
1 VALID /u01/app/oracle/UATS/arc_dest/arc
2 ERROR standby1 ORA-16012: Archivelog standby database identifier mismatch
3 INACTIVE
4 INACTIVE
5 INACTIVE
5 rows selected.

Regards,
Angus

[Sean Dale]

If any of the following conditions exist, the primary database will fail to archive to the standby site:

* The service name for the standby instance is not configured correctly in the tnsnames.ora file at the primary site.

* The service name listed in the LOG_ARCHIVE_DEST_n parameter of the primary initialization parameter file is incorrect.

* The LOG_ARCHIVE_DEST_STATE_n parameter specifying the state of the standby archiving destination has the value DEFER.

* The listener.ora file has not been configured correctly at the standby site.

* The listener is not started.

* The standby instance is not started.

* You have added a standby archiving destination to the primary initialization parameter file, but have not yet enabled the change.

* You used an invalid backup as the basis for the standby database

[Yogeeraj_1 · Accepted solution]

hi Angus,

Verify at the Primary database level if the archived log are being properly shipped.

You may check in the alert.log


hope this helps!

kind regards
yogeeraj

[Angus John-Phillips]

Thanks for the help the listener.ora file had been changed.

Thanks,
Angus