Howard J. Rogers wrote:
> "Richard Foote" <richard.foote_at_bigpond.com> wrote in message
> news:F3Jvb.22263$aT.12989_at_news-> Hi Howard,
>
>>There's a bit of a difference between Data Guard and the GUI.
>>
>>We use Data Guard (9.2) but not the GUI.
>
>
>
> OK. I"ll stop being lax with words. And maybe we can then get this right.
>
> Here's the Oracle documentation on the matter:
>
> "You must use a server parameter file if you use the Data Guard broker."
>
> And since the doco. also describes the Data Guard broker as...
>
> "a distributed management framework that automates and centralizes the
> creation, maintenance, and monitoring of Data Guard configurations. The
> following list describes some of the operations that the broker automates or
> simplifies:
> a.. Creating and enabling one or more Data Guard configurations, including
> setting up log transport services and log apply services.
> b.. Creating a physical or logical standby database from a backup copy of
> the primary database.
> c.. Adding new or existing standby databases to an existing Data Guard
> configuration.
> d.. Managing an entire Data Guard configuration from any system in the
> configuration.
> e.. Monitoring log apply rates, capturing diagnostic information, and
> detecting problems quickly with centralized monitoring, testing, and
> performance tools "
> ...then a couple of things need to be said.
>
> First, this isn't a question of GUI or not. The Data Guard broker is
> controlled either via Data Guard Manager (GUI) or via the Data Guard Manager
> Command Line interface, DGMGRL. So even in non-GUI mode, the broker can be
> accessed, and hence the spfile would be compulsory.
>
> Second, you must be a very brave man. From memory, performing a graceful
> switchover by hand takes about 8 steps and at least as many SQL statements.
> With DGMGRL, it consists of issuing the single command "switchover to
> 'BLAH';". I know which I'd prefer. Can I therefore ask why you have decided
> not to avail yourself of the automation/management features of Data Guard?
> Is it a bug issue? Or something else??
>
> Third, my original statement was "The spfile has just one thing going for
> it: it is compulsory if you want to use Data Guard." I was indeed wrong. I
> should have written "The spfile has just one thing going for it: it is
> compulsory if you want to use Data Guard broker". GUI or CLI.
>
> Regards
> HJR
Come on Howard there are two other things the SPFILE is good for.
- On-line permanent parameter changes
- Keeping incompetent DBAs from making changes because they change the
init.ora and think they've changed the database.
You have no idea how many times I've been saved from these people by the
fact that they never learned about recompiling the sp file.
--
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)
Received on Sat Nov 22 2003 - 16:12:48 CST
