This content has been marked as final. Show 2 replies
Dictionary views have limited information at best. The tsnames, some of the Primary parameters with provide some the of information. log_archive_dest_n for example.
LOG_FILE_NAME_CONVERT and DB_FILE_NAME_CONVERT may provide a small amount of information.
"show parameter" still works on databases doing apply.
V$DATAGUARD_STATUS may show a location like where the log is being written.
V$DATABASE has a tiny amount of information, maximum performance, mode of the database.
Oracle does not store the remote host in the database.
It will depend on exactly what you need, but most you need to put something together. I started with a Spreadsheet that has Database name, Oracle version, Server DNS Name, Has Standby and Size.
My friend CKPT has these two scripts which may also help :
Edited by: mseberg on Apr 15, 2013 3:51 PM
show aparameter log_archive_dest and dg_config
parameters would show you standby database name