RE: dataguard issue on Primary database.
Date: Thu, 5 Feb 2009 16:02:26 -0500
Message-ID: <23C4836D8E9C5F4280A66C0C247BC16F236FE89C_at_US-BOS-MX011.na.pxl.int>
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:\orac le\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 bylocation 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 yourhelp 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 standbydatabase 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 thefile 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-lReceived on Thu Feb 05 2009 - 15:02:26 CST