Re: Data Guard question.

Point taken. In practice I do in fact keep the standby directory structure as identical as possible to the primary, using symbolic links as you mention.

Here is an example of how I might normally use these parameters. As you can see I am only changing a single component of the path name, which is nowhere near the head of the path (using OFA):

db_file_name_convert = 'oradata/qa1', 'oradata/stby1' log_file_name_convert = 'admin/qa1', 'admin/stby1'

The best antidote for a stressful failover situation, of course, is practice in advance... ;-)

Keeping backup systems (or test systems, for that matter) _too_ identical to the primary can cause problems in other direction -- for example, if rebuilding a standby, when I type that "rm -f" command to remove the old set of files, I like to see explicitly from the pathname that I really am removing my standby, and not (accidentally) my primary.

Carel-Jan Engel wrote:

> Mark, Ron,
>
> I strongly disrecommend using the ..._FILE_NAME_CONVERT parameters. Not
> for technical reasons, but from the point of view of robustness of
> managing your systems.
>
> Immediately after a failover you're in a stressfull situation. Keeping
> in mind that the structure you're working on is different makes the
> situation even more error-prone.
>
> So, try to keep the structures as symmetric as possible. Even when you
> have only one big disk available, create a directory tree that resembles
> the tree on the primary, albeit with symbolic links.
>

[...]

-- 
Mark Bole
http://www.bincomputing.com



--
http://www.freelists.org/webpage/oracle-l