Yes...I have set this parameter in the parameter file of the standby database. *.db_file_name_convert='D:\oracle\product\10.2.0\oradata\stdby','D:\oracle\product\10.2.0\oradata\orcl1' Thanks Nilesh On Fri, Feb 6, 2009 at 2:24 AM, Goulet, Richard <Richard.Goulet@xxxxxxxxxxx>wrote: > db_file_name_convert > > > *Dick Goulet*** > > > ------------------------------ > *From:* oracle-l-bounce@xxxxxxxxxxxxx [mailto: > oracle-l-bounce@xxxxxxxxxxxxx] *On Behalf Of *nilesh kumar > *Sent:* Thursday, February 05, 2009 3:49 PM > *To:* Bill Zakrzewski > *Cc:* ORACLE-L > *Subject:* Re: dataguard issue on Primary database. > > Yes both the Primary and the Standby are on the same server. > Yes...I see..it is using the same datafile that of the primary > I need to create a control and redirect it to the stand by location correct > ?? > > Thanks > Nilesh > > On Fri, Feb 6, 2009 at 2:08 AM, Bill Zakrzewski <bill@xxxxxxxxxxxx> wrote: > >> Is your standby database on the same server? Could it be possible the >> standby database is using the datafile from your primary? >> >> >> >> On Feb 5, 2009, at 3:30 PM, nilesh kumar wrote: >> >> Hello Everyone >>> >>> Good Afternoon!! >>> >>> Hope Everyone is doing good!!. >>> I am back with one more issue today. Nees your help please. >>> >>> I am getting an error message while creation of dataguard for oracle 10g >>> on windows. The primary and standby database is on the same machine. >>> >>> >>> This is the content of the standby screen >>> SQL> startup mount >>> ORACLE instance started. >>> >>> Total System Global Area 289406976 bytes >>> Fixed Size 1248576 bytes >>> Variable Size 92275392 bytes >>> Database Buffers 188743680 bytes >>> Redo Buffers 7139328 bytes >>> Database mounted. >>> SQL> alter database recover managed standby database disconnect from >>> session; >>> >>> Database altered. >>> >>> SQL> >>> >>> >>> ------------------------------------------------------------------------------------------------ >>> >>> This is the content of the Primary database:- >>> >>> SQL> startup mount; >>> ORACLE instance started. >>> >>> Total System Global Area 289406976 bytes >>> Fixed Size 1248576 bytes >>> Variable Size 96469696 bytes >>> Database Buffers 184549376 bytes >>> Redo Buffers 7139328 bytes >>> Database mounted. >>> SQL> alter database open; >>> alter database open >>> * >>> ERROR at line 1: >>> ORA-01157: cannot identify/lock data file 1 - see DBWR trace file >>> ORA-01110: data file 1: >>> 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL1\SYSTEM01.DBF' >>> ============= >>> >>> The trace file shows me this info: >>> >>> skgfglk: D:_ORACLE_PRODUCT_10.2.0_ORADATA_ORCL1_SYSTEM01.DBF possible >>> holder 2964:2308, flags 1 >>> ORA-01157: cannot identify/lock data file 1 - see DBWR trace file >>> ORA-01110: data file 1: >>> 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL1\SYSTEM01.DBF' >>> ORA-27086: unable to lock file - already in use >>> OSD-00002: additional error information >>> O/S-Error: (OS 32) The process cannot access the file because it is being >>> used by another process. >>> >>> >>> I am doing this for the first time, could you please guide me how should >>> I solve this problem. >>> >>> -- >>> Thanks >>> Nilesh Soni >>> Oracle DBA--OCA 10g >>> Oracle is not a magic..it takes years of experiance :-) >>> 9860584034 >>> >>> >> > > > -- > Thanks > Nilesh Soni > Oracle DBA--OCA 10g > Oracle is not a magic..it takes years of experiance :-) > 9860584034 > > -- Thanks Nilesh Soni Oracle DBA--OCA 10g Oracle is not a magic..it takes years of experiance :-) 9860584034