RE: dataguard issue on Primary database.

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:\orac
le\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

Other related posts: