Re: dataguard issue on Primary database.

From: nilesh kumar <nileshkum_at_gmail.com>
Date: Fri, 6 Feb 2009 02:28:06 +0530
Message-ID: <7877ab4b0902051258j12146766n414cff32d322da46_at_mail.gmail.com>

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_at_parexel.com>wrote:

> db_file_name_convert
>
>
> *Dick Goulet***
>
>
> ------------------------------
> *From:* oracle-l-bounce_at_freelists.org [mailto:
> oracle-l-bounce_at_freelists.org] *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_at_intactus.com> 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

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

Received on Thu Feb 05 2009 - 14:58:06 CST