standby database from a RAC cluster with ASM to a single-instance server using filesystem storage not ASM.
- From: "John Hallas" <John.Hallas@xxxxxxxx>
- To: "oracle-l" <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 23 Jul 2008 14:36:54 +0100
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.h
tml
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
Other related posts:
