how to know the exact redundancy path in ospf

[Kn1ghtR1d3rOfD00m]

Hi All, 

Lets say that I have a set up like the following and the source is site A and the Destination is site D in between with the provider, we have MPLS, we so we see each neighbor running OSPF as point to point connections Layer 3.

If  I run a show ip route to a particular destination, it shows the primary path (in this case amusing site A- SIte D is primary) which the destination is Destination 1.

However, if I want to know the secondary path for a particular destination, which command should I run in the OSPF?

The reason is that only when a failover occurs, I can determine the secondary path, because the show ip route output only display the best installed route in the routing table, 

But imagine that some routes go to Site B and then Ste C to reach the destination and then the Site D to reach the final destination if a failover occurs, how can I tell if this is true, how can I tell from the command output which is the secondary path for a particular destination without failing over ?

Correct me if Im wrong, if the metrics on the top routes redistribute to the downstream routers, only that particular route will appear in the routing table, but to know the secondary path without going to the upstream routers to check the metric, which command should I run to see which routers sees in a secondary path scenario?

[Julio E. Moisa]

Hi Alex,

The following command should provide the information that you want, also it will indicate the router-id of the router who is advertising the networks.

show ip ospf database. 

If the networks are being redistributed by other protocol into OSPF you will see them on the database as LSA 5.

Hope it is useful

:-)

[Kn1ghtR1d3rOfD00m]

Thank you Moisa, 

However, could you elaborate a bit more? The thing is that as far as I remember, ospf does not save a back up like EIGRP does, but it saves the entire view of everything in the topology, so Im not sure if thats possible to see it since only active routes are installed in the routing table, 

So having said that, you cannot determine for which path a source and destination will go thru since you only see all paths but you cannot see, which one will be installed later, unless you make the failover, but thats something I do not want to do, and I do not want to go to the upstream routers to check the metric and so on, 

Is there any way, to achieve this? or Am I missing something?

thanks for your help and assistance,