dataguard issue on Primary database.

From: nilesh kumar <nileshkum_at_gmail.com>
Date: Fri, 6 Feb 2009 02:00:33 +0530
Message-ID: <7877ab4b0902051230h1408d710gf9f4c2b87ed81def_at_mail.gmail.com>

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

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

Received on Thu Feb 05 2009 - 14:30:33 CST