Re: dataguard issue on Primary database.
- From: nilesh kumar <nileshkum@xxxxxxxxx>
- To: "Goulet, Richard" <Richard.Goulet@xxxxxxxxxxx>
- Date: Fri, 6 Feb 2009 03:47:19 +0530
Hello All,
I created the dataguard successfullyy!!
recovered the media and opened the database with reset logs.
Thank you for all your help and support.
Thank you *Dick Goulet* ...for your help.
Thanks
Nilesh
On Fri, Feb 6, 2009 at 2:55 AM, nilesh kumar <nileshkum@xxxxxxxxx> wrote:
> 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@xxxxxxxxxxx> 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@xxxxxxxxx]
>> *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@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
>>
>>
>
>
> --
> 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
Other related posts:
