Including all the other checks you mentioned, you may want to start by
making sure that the version of oracle server/software running has the
dataguard utility included. If it does not you cannot even start the
daemon process. Needless to check the init or dba views to see the role of
a database. (primary or standby). For example on one of my servers that
does not have dataguard, I will get the following error when I try to
start the datagaurd manager process:

DGMGRL> connect username/pwd
Connected.
Error:
ORA-16525: the Data Guard broker is not yet available
ORA-06512: at "SYS.DBMS_DRS", line 48
ORA-06512: at line 2
Sabina.




"Newbie-dba " <oracledba-ezmlmshield-x36009281.[Email address protected]
11/29/2005 04:58 PM

To
"LazyDBA Discussion" <[Email address protected]
cc

Subject
Dataguard and standby databases ...






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 ...


--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these terms:
http://www.lazydba.com/legal.html




Oracle LazyDBA home page