Configuring HP Serviceguard Toolkit for Oracle Data Guard

21
For example, enter:
SQL> SELECT dest_id “ID”
2> status “DB_status”
3> destination “Archive_dest”
4> error “Error”
5> FROM v$archive_dest;
ID DB_status Archive_dest Error
-- --------- ------------------------------
--------------------------------------
1 VALID /vobs/oracle/work/arc_dest/arc
2 ERROR standby1 ORA-16012: Archivelog standby database
identifier mismatch
3 INACTIVE
4 INACTIVE
5 INACTIVE
5 rows selected
If the output of the query does not help, check the following list of possible issues.
- 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 (for example, you used a backup
from the wrong database, or did not create the standby control file using the correct method).
Also, check the Oracle Alert log for errors.
2. Verify the Toolkit setup:
Check whether the package configuration attributes specified in the package configuration file are
valid or not.
Known problems and workarounds
1. If the replication does not happen from the primary database to the standby database then check
if the online redo log files are configured or not on the primary as well as the standby.