RE: dataguard issue on Primary database.

From: Goulet, Richard <Richard.Goulet_at_parexel.com>
Date: Thu, 5 Feb 2009 15:54:06 -0500
Message-ID: <23C4836D8E9C5F4280A66C0C247BC16F236FE81D_at_US-BOS-MX011.na.pxl.int>

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



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

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