Re: dataguard issue on Primary database.

From: nilesh kumar <nileshkum_at_gmail.com>
Date: Fri, 6 Feb 2009 02:55:15 +0530
Message-ID: <7877ab4b0902051325n1ba76bb2n600a9fbc8556d4b4_at_mail.gmail.com>

Yes...it solved that problem, but...I got involved in another one.

when I start the primary database

SQL> startup
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.
ORA-00314: log 1 of thread 1, expected sequence# doesn't match ORA-00312: online log 1 thread 1:
'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL1\REDO01.LOG' Shall I replace the redo ?

Thanks
Nilesh

On Fri, Feb 6, 2009 at 2:32 AM, Goulet, Richard <Richard.Goulet_at_parexel.com>wrote:

> You got the filenames backwards. Pattern of the primary database is
> first, pattern for the standby is second.
>
>
> *Dick Goulet***
>
>
> ------------------------------
> *From:* nilesh kumar [mailto:nileshkum_at_gmail.com]
> *Sent:* Thursday, February 05, 2009 3:58 PM
> *To:* Goulet, Richard
> *Cc:* Bill Zakrzewski; ORACLE-L
>
> *Subject:* Re: dataguard issue on Primary database.
>
> 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
>
>

-- 
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 - 15:25:15 CST