This content has been marked as final. Show 6 replies
im waiting for reply.
RMAN doesn't particularly care where the DB is - it works by incarnations of DBID.
So (I don't think) it records that info in it's tables.
I could be wrong though.......
Any suggesions from Oracle ??
Edited by: vreddy on Oct 19, 2012 11:58 AM
What is wrong?
The only information that will be available will be from one of the RC_* views. For a list of the views see the index in the Database Backup and Recovery Reference
The database name is available as the NAME column of the RC_DATABASE view. You will need to join this view to others at least on DB_KEY.
I'm not aware of any view that would have the server name. You will need to map the database name or id to your own table of server locations.