cancel
Showing results for 
Search instead for 
Did you mean: 

Data Guard

SOLVED
Go to solution
Angus John-Phillips
Occasional Advisor

Data Guard

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
3 REPLIES
Sean Dale
Trusted Contributor

Re: Data Guard

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
Live life everyday
Yogeeraj_1
Honored Contributor
Solution

Re: Data Guard

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
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
Angus John-Phillips
Occasional Advisor

Re: Data Guard

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

Thanks,
Angus