Creating Physical Standby
| Follow up by mail | Click here |
| Subject: | Creating Physical Standby |
| Author: | Venkata Bapalu G, India |
| Date: | Aug 15, 2008, 749 days ago |
| Os info: | Sun Solaris |
| Oracle info: | Oracle 10.2.0.3 |
| Message: | Hi,
I have to configure the Data Guard and create a physical standby database(Non-RAC) from a primary database (RAC with ASM). I took the RMAN backup from the primary and need to restored the same on the standby. My question is do I need to configure the ASM on the standby also before I restore the RMAN dump?? Please advice. If any documents are available, kindly share the same. Regards Venkat |
| Goto: | Reply - Top of page |
| Subject: | Re: Creating Physical Standby |
| Author: | Yousef Rifai, United Kingdom |
| Date: | Aug 15, 2008, 749 days ago |
| Message: | Hi Venkat,
I am not sure if you have to create an ASM instance for the standby or not. MY guess is you do not need to. Having said that, I followed the instructions in the link bellow and my system has been running in production for months without problems, I hope you find it useful. http://www.oracle.com/technology/deploy/availability/pdf/MAA_WP_10g_RACPrimarySingleInstancePhysicalStandby.pdf Regards Yousef Rifai |
| Your rating?: | This reply is Good Excellent |
| Goto: | Reply - Top of page |
| Subject: | Re: Creating Physical Standby |
| Author: | Roshan Nair, United Arab Emirates |
| Date: | Aug 15, 2008, 749 days ago |
| Message: | If 10g, it is ASm as best option. But make sure you set the parameters right for both primary and standby.
-Roshan Nair |
| Your rating?: | This reply is Good Excellent |
| Goto: | Reply - Top of page |
| Subject: | Re: Creating Physical Standby |
| Author: | Venkata Bapalu G, India |
| Date: | Aug 18, 2008, 746 days ago |
| Message: | Hi Yousef Rifai,
Many thanks for the e-mail message and information provided. I tried implementing the data guard configuration on standby database (Non RAC with No ASM). Errors were observed in alert log file while placing the standby database in managed recover mode. Below is the error message, kindly suggest some solution and do needful. ORA-01157: cannot identify/lock data file 55 - see DBWR trace file ORA-01110: data file 55: '+EVD_DG01/evdprd/datafile/strm_data.281.661953375' ORA-17503: ksfdopn:2 Failed to open file +EVD_DG01/evdprd/datafile/strm_data.281.661953375 ORA-15001: diskgroup "EVD_DG01" does not exist or is not mounted ORA-15077: could not locate ASM instance serving a required diskgroup ORA-29701: unable to connect to Cluster Manager MRP0: Background Media Recovery terminated with error 1110 Thu Aug 14 16:50:35 2008 Errors in file /ora/dump/bdump/evdprd_mrp0_5060.trc: ORA-01110: data file 1: '+EVD_DG01/evdprd/datafile/system.310.661956083' ORA-01157: cannot identify/lock data file 1 - see DBWR trace file ORA-01110: data file 1: '+EVD_DG01/evdprd/datafile/system.310.661956083' Thu Aug 14 16:50:35 2008 Errors in file /ora/dump/bdump/evdprd_mrp0_5060.trc: ORA-01110: data file 1: '+EVD_DG01/evdprd/datafile/system.310.661956083' ORA-01157: cannot identify/lock data file 1 - see DBWR trace file ORA-01110: data file 1: '+EVD_DG01/evdprd/datafile/system.310.661956083' Thu Aug 14 16:50:35 2008 MRP0: Background Media Recovery process shutdown (evdprd) Thu Aug 14 16:50:36 2008 Completed: alter database recover managed standby database disconnect from session Regards Venkat |
| Your rating?: | This reply is Good Excellent |
| Goto: | Reply - Top of page |
| Subject: | Re: Creating Physical Standby |
| Author: | Guy Lambregts, Other |
| Date: | Aug 18, 2008, 746 days ago |
| Score: | |
| Message: | Hi
Which is your db_create_file_dest set to in your primary database instances : +EVD_DG01 ? To which is your db_create_file_dest set to in your standby database instance : /opt/oradata ? Then you have to set the db_file_name_convert to '+EVD_DG01','/opt/oradata' Regards Guy |
| Your rating?: | This reply is Good Excellent |
| Goto: | Reply - Top of page |
| Subject: | Re: Creating Physical Standby |
| Author: | Venkata Bapalu G, India |
| Date: | Aug 19, 2008, 745 days ago |
| Message: | Hi Guy,
Thanks for the reply. db_create_file_dest parameter on primary was set to "+EVD_DG01" and nothing was set on standby database. Should i set some path name to the standby database? and then the parameter "db_file_name_convert" on both the primary and stand by? Please give the steps involved. Thanks and Regards Venkat |
| Your rating?: | This reply is Good Excellent |
| Goto: | Reply - Top of page |
| Subject: | Re: Creating Physical Standby |
| Author: | Venkata Bapalu G, India |
| Date: | Aug 19, 2008, 745 days ago |
| Message: | Also the standby database is in mount state and not open.
Regards Venkat |
| Your rating?: | This reply is Good Excellent |
| Goto: | Reply - Top of page |
| Subject: | Re: Creating Physical Standby |
| Author: | Yousef Rifai, United Kingdom |
| Date: | Aug 19, 2008, 745 days ago |
| Message: | Hi Venkat,
Yes you should. You need it in the primary in case you switch over the datanbase role. Regards Yousef Rifai |
| Your rating?: | This reply is Good Excellent |
| Goto: | Reply - Top of page |
| Subject: | Re: Creating Physical Standby |
| Author: | Venkata Bapalu G, India |
| Date: | Aug 19, 2008, 745 days ago |
| Message: | Hi,
After modifying the parameters, I tried to bounce one of the RAC node, it is not getting up. It is throwing error like: cat /software/ora/admin/evdrep/bdump/evdprd2_arc0_5750.trc /software/ora/admin/evdrep/bdump/evdprd2_arc0_5750.trc Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production With the Partitioning, Real Application Clusters, OLAP and Data Mining options ORACLE_HOME = /software/ora/oracle/product/10.2.0/db System name: SunOS Node name: test2 Release: 5.10 Version: Generic_127127-11 Machine: sun4u Instance name: evdprd2 Redo thread mounted by this instance: 2 Oracle process number: 20 Unix process pid: 5750, image: oracle@test2 (ARC0) *** 2008-08-07 04:11:20.746 *** SERVICE NAME:(SYS$BACKGROUND) 2008-08-07 04:11:20.746 *** SESSION ID:(186.1) 2008-08-07 04:11:20.746 SKGXPIWAIT: keepalive_reset elapsed 682191 ts 120158921 last ping 119476730 chec k 600000 PING HISTORY for CONTEXT Time Stampe 0x7297ac9 MSGs Time Stamp --- ---------- 0 0x71f11fa 1 0x6e38d9c 1 0x6e821a4 1 0x6ecb5ac 1 0x6f149b4 1 0x6f5ddbc 1 0x6fa71c4 1 0x6ff05cc 1 0x70399d4 1 0x7082ddc 1 0x70cc1e4 1 0x71155ec 1 0x715e9ea 1 0x71a7df3 1 0x71f11fa 0 0x71f11fa SKGXP_KEEPALIVE_RESET: alarm unblocked already SKGXP_KEEPALIVE_RESET: restting shared signal for keep alive messages SKGXP_KEEPALIVE_RESET: re-initing shared signal for keep alive messages SKGXP_KEEPALIVE_RESET: setting alarm for keep alive messages *** 2008-08-11 15:29:28.196 Redo shipping client performing standby login OCIServerAttach failed -1 .. Detailed OCI error val is 12154 and errmsg is 'ORA-12154: TNS:could not resol ve the connect identifier specified ' *** 2008-08-11 15:29:28.267 61287 kcrr.c Error 12154 received logging on to the standby Error 12154 connecting to destination LOG_ARCHIVE_DEST_2 standby host 'DelEvd' Error 12154 attaching to destination LOG_ARCHIVE_DEST_2 standby host 'DelEvd' ORA-12154: TNS:could not resolve the connect identifier specified *** 2008-08-11 15:29:28.267 61287 kcrr.c PING[ARC0]: Heartbeat failed to connect to standby 'DelEvd'. Error is 12154. *** 2008-08-11 15:29:28.267 59530 kcrr.c kcrrfail: dest:2 err:12154 force:0 blast:1 *** 2008-08-11 15:34:28.384 Redo shipping client performing standby login OCIServerAttach failed -1 .. Detailed OCI error val is 12154 and errmsg is 'ORA-12154: TNS:could not resol ve the connect identifier specified ' *** 2008-08-11 15:34:28.421 61287 kcrr.c Error 12154 received logging on to the standby Error 12154 connecting to destination LOG_ARCHIVE_DEST_2 standby host 'DelEvd' Error 12154 attaching to destination LOG_ARCHIVE_DEST_2 standby host 'DelEvd' ORA-12154: TNS:could not resolve the connect identifier specified *** 2008-08-11 15:34:28.422 61287 kcrr.c PING[ARC0]: Heartbeat failed to connect to standby 'DelEvd'. Error is 12154. *** 2008-08-11 15:34:28.422 59530 kcrr.c kcrrfail: dest:2 err:12154 force:0 blast:1 Kindly suggest some solution, I am stuck up with this. Thanks in advance Regards Venkat |
| Your rating?: | This reply is Good Excellent |
| Goto: | Reply - Top of page |