RE: Data Guard Rman Vlidation Question

Tom,

In an HA environment I advocate to have as few complexity as possible. That includes as much symmetry between primary and standby(s) as possible.
Some reason for symmetry: less parameters, less server-specific actions. If you're working at the standby (after a failover) it is helpful if that standby (now the primary) is not different from the environment you are used to. It simply helps avoiding to make mistakes. There is enough stress around a failover, you can do without additional 'complications'.

If you can create symbolic links to reflect the original directory structure, why not have the mountpoints named identically at both sides? at least that is an 'approved' solution ;-)

Best regards, Carel-Jan

Best regards,

Carel-Jan Engel

===
If you think education is expensive, try ignorance. (Derek Bok) ===

On Mon, 2008-03-31 at 10:37 -0400, Mercadante, Thomas F (LABOR) wrote:
> Joe,
>
> That would work I think. But I'm looking for the "approved" solution.
> And yes, AIX.
> I could also probably open the secondary database and issue "alter
> database rename" commands to formally rename the files.
> Or look into Rman for commands to rename the files to be validated.
>
> Just not sure which solution is the correct one.
>
> Thanks
>
> Tom
>
>
>
>
> ______________________________________________________________________
> From: TESTAJ3_at_nationwide.com [mailto:TESTAJ3_at_nationwide.com]
> Sent: Monday, March 31, 2008 10:15 AM
> To: Mercadante, Thomas F (LABOR)
> Cc: Oracle-L; oracle-l-bounce_at_freelists.org
> Subject: Re: Data Guard Rman Vlidation Question
>
>
>
>
> Unix, I assume since there are the "real" slashes in the path :)
>
> can you just cheat and make symbolic links to the filesystems on the
> secondary server for the original mount points?
>
>
> Joe
>
> ---------------------------------------
> You can have it: Fast, Right or Cheap, pick 2 of the 3.
> Fast + Right is Expensive
> Fast + Cheap will be incorrect.
> Right + Cheap will take a while.
>
>
> "Mercadante, Thomas F (LABOR)"
> <Thomas.Mercadante_at_labor.state.ny.us>
>
> Sent by:
> oracle-l-bounce_at_freelists.org
>
>
>
>
> 03/31/2008 10:10 AM
> Please respond to
> Thomas.Mercadante_at_labor.state.ny.us
> From
> "Mercadante,
> Thomas F (LABOR)"
> <Thomas.Mercadante_at_labor.state.ny.us>
> To
> "Oracle-L"
> <oracle-l_at_freelists.org>
> cc
>
> Subject
> Data Guard Rman
> Vlidation
> Question
>
>
>
>
>
>
>
>
> All,
>
> I created our first Data Guard database (10.2, physical copy). The
> mount points on the Primary and Secondary servers are different. So
> the init.ora file of the Secondary server has the
> "db_file_name_convert='/dba/vg_uism_01/u0002/DGTD/system','/dba/vg_uiss_01/DGTD1/data'" entries mapping the directory names to the new locations. All of this was done through 10G Grid by the way.
>
> Rman backups of the secondary server work fine.
> Validations are a challenge. Rman Validation is looking for the
> database files in the Primary directory location - it is not using the
> db_file_name_convert init.ora parameter to find the file. So
> validations are failing.
>
>
> RMAN-03002: failure of restore command at 03/31/2008 09:07:44
> ORA-19625: error identifying
> file /dba/vg_uism_01/u0002/DGTD/system/system_01.dbf
> ORA-27037: unable to obtain file status
>
>
> How do I resolve this? What have you done?
>
> Thanks
>
> Tom
>
>
> How do I resolve this?
>
>
>
> --
> This message has been scanned for viruses and
> dangerous content by MailScanner, and is
> believed to be clean.

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