RE: standby database from a RAC cluster with ASM to a single-instance server using filesystem storage not ASM.

John,  

I would pick and choose from two different technet articles (from the Maximum Availability Architecture set).  

Data
<http://www.oracle.com/technology/deploy/availability/pdf/dataguard11g_rac_m
aa.pdf> Guard 11g Installation and Configuration Best Practices on Oracle RAC http://www.oracle.com/technology/deploy/availability/pdf/dataguard11g_rac_ma a.pdf  

         MAA 10
<http://www.oracle.com/technology/deploy/availability/pdf/MAA_WP_10g_RACPrim
arySingleInstancePhysicalStandby.pdf> g Setup Guide: Creating a Single Instance Physical Standby Database for a RAC Primary Database

http://www.oracle.com/technology/deploy/availability/pdf/MAA_WP_10g_RACPrima rySingleInstancePhysicalStandby.pdf                    

In 11g you can have RMAN create the standby control file, password file, spfile for you. The spfile isn't correct, so the suggestion is to start with a simple, dummy init.ora for the standby, have RMAN pass some init parameters over during the copy, then create a pfile from the standby spfile, shutdown, edit the pfile, restart the standby. I would think you should be able to take care of the cluster problems this way.  

Hope this helps. (I am just finishing a RAC to RAC (2 node to 1 node)) install. I haven't tried a non-clustered physical standby.  

Henry  

-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of John Hallas
Sent: Wednesday, July 23, 2008 9:37 AM
To: oracle-l
Subject: standby database from a RAC cluster with ASM to a single-instance server using filesystem storage not ASM.

Does anybody have any links on how to create a standby database from a RAC cluster with ASM to a single-instance server using filesystem storage not ASM.   11.1.0.6 OEL 5   There is a good blog at
http://www.colestock.com/blogs/2007/10/creating-physical-standby-using.html  

I have followed it but it gets the controlfile down and then creates an spfile from the controlfile but that contains all the RAC parameters.  

I am using the following RMAN command  

DUPLICATE TARGET DATABASE   FOR STANDBY   DORECOVER   DB_FILE_NAME_CONVERT=('+DATA/','/export2/oradata/DGPHYS/')

  SPFILE     PARAMETER_VALUE_CONVERT '+DATA','/stdby'

    SET SERVICE_NAMES 'DGPHYS.bjss.co.uk'

    SET "db_unique_name"="DGPHYS"

    SET log_file_name_convert '+DATA/','/export2/oradata/DGPHYS/';

    SET cluster_database=false -- to overwrite the RAC components

    Set cluster database_instances=0 - tried 1 as well    

This works OK and creates an spfile but will not start the databse up from the spfile because  

RMAN-01008: the bad identifier was: cluster_database_instances

RMAN-01007: at line 1 column 5 file: standard input  

If I take out the line cluster_database_instances it fails anyway as the spfile has been built for a RAC config  

Any pointers or help appreciated  

John      

+44 (0)113 223 2274 (direct)

+44 (0)113 297 9797  

BJSS - Platinum Sponsors of the 2008 Agile Business Conference www.agileconference.org

The information included in this email and any files transmitted with it may contain information that is confidential and it must not be used by, or its contents or attachments copied or disclosed, to persons other than the intended addressee. If you have received this email in error, please notify BJSS.
In the absence of written agreement to the contrary BJSS' relevant standard terms of contract for any work to be undertaken will apply. Please carry out virus or such other checks as you consider appropriate in respect of this email. BJSS do not accept responsibility for any adverse effect upon your system or data in relation to this email or any files transmitted with it.
BJSS Limited, a company registered in England and Wales (Company Number 2777575), VAT Registration Number 613295452, Registered Office Address, First Floor, Coronet House, Queen Street, Leeds, LS1 2TW

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