Cisco Cisco Prime Network 3.8 Troubleshooting Guide

This document describes a step by step procedure to resolve database replication or
synchronization issue in Prime Network when standby database from Primary database is
rebuilded.

Cisco recommends that you have knowledge of these topics:

Use this procedure to rebuild secondary database only if SWITCHOVER_STATUS of primary
database is into UNRESOLVABLE GAP.

●

Ensure that the primary database is in READ WRITE and secondary database is in READ
ONLY or READ ONLY WITH APPLY modes.

●

The information in this document is based on these software and hardware versions:

Prime Network release 3.9 and above

●

Oracle Database 11G release

●

The information in this document was created from the devices in a specific lab environment. All of
the devices used in this document started with a cleared (default) configuration. If your network is
live, make sure that you understand the potential impact of any command.

1. Use this command to know switchover_status of Primary database:

Note: Prime Central Geo HA switchover fails abruptly leaving the Prime Central GEO HA
system and/or database role status corrupt (both primay or both standby) and then you need
to rebuild either primary or secondary depending upon last active/standby status.

Note: For all other cases, open SR with Cisco TAC to resolve database replication issue.

2. Use this command to know the current mode of primary and secondary database: