Hi all,
Let's say you are suddenly send to Timbuktu with only your Oracle skills on hand but you decided to bring along your OracleDocs CD as well, and you need to know whether your Timbuktu customers are using standby databases or not. Is there any quick check that you can do to confirm whether there is a standy database out there somewhere or not? At the moment, am checking the obvious ones as follows:
1. Check crontab if there is any log-shipping
2. Check TNSNAMES.ORA whether something of the obvious settings are present
3. Check INIT.ORA or SPFILE, i.e. SHOW PARAMETER STANDY, LOG_ARCHIVE_DEST etc.
Any more suggestions will be very much appreciated ... I wish I could ask the other DBA but he's worried stiff that I'll take over his job entirely ... BTW, Timbuktu is a real place, isn't it?

Thanks in advance ...

Oracle LazyDBA home page