Re: 3 Standby database settings questions

76434.1353_at_compuserve.com wrote in message news:<401d81b4.53474322_at_news.hccnet.nl>...
> Question:
>
> I see this enable /defer statement in the documentation of the Oracle
> Standby server:
>
> 1. Why should I add this " enable " statement in the ini file when it
> is already a default value? Or is it not? Does this "enable" statement
> has additional value?

It's nice to be able to find it and change it to defer when you are going to be performing maintenance and restores and such.

>
> 2. Same question for " optional " archiving. Do I have to put in
> "optional " if I never want to make use of mandatory?

? yeah.... Read the Server manual again. It might help if you were to state your version, OS, options of Oracle, etc.

Definitely check metalink for such things as notes about when you would want to use reopen and such. It seems there are bugs.

>
> 3. TNSNAMES. When configuring the TNSNAMES file of the primairy
> database while implementing the standby database: some examples makes
> use of the "Service name = " parameter instead of " SID = "
> Which one should I use. What is the difference?
> Thanks,

Depends on your version and what you are doing. The general trend is towards Service name. Poke around in the upgrade manual for going to your version.

jg

--
@home.com is bogus.
Follow the patents! 
http://www.signonsandiego.com/news/uniontrib/tue/business/news_1b3patriot.html