Re: Dataguard setup

Steve,
 /u02/oravis/dgtestdata/system.dbf  exists in the location. No, i
didnt use DB_FILE_NAME_CONVERT  parameter at all in the init file.
Could you please explain further on its usage?

Thanks for your help in advance.


Kalyan

On Thu, Mar 12, 2009 at 4:53 PM, Laskey Steve
<Steve.Laskey@xxxxxxxxxxxxxx> wrote:
> Kalyan,
>
> Have you inadvertantly put some DB_FILE_NAME_CONVERT setting in your primary 
> init.ora ???
>
> /Steve
>
>> -----Original Message-----
>> From: ora-apps-dba-bounce@xxxxxxxxxxxxx
>> [mailto:ora-apps-dba-bounce@xxxxxxxxxxxxx] On Behalf Of Laskey Steve
>> Sent: 12 March 2009 11:20
>> To: ora-apps-dba@xxxxxxxxxxxxx
>> Subject: RE: Dataguard setup
>>
>> Kalyan,
>>
>> Does the file /u02/oravis/dgtestdata/system.dbf physically
>> exist, how did you create your standby, did you mv or cp the
>> datafiles?
>>
>> [/steve]
>>
>> > -----Original Message-----
>> > From: ora-apps-dba-bounce@xxxxxxxxxxxxx
>> > [mailto:ora-apps-dba-bounce@xxxxxxxxxxxxx] On Behalf Of
>> Kalyan Sundar
>> > Sent: 12 March 2009 10:49
>> > To: ora-apps-dba@xxxxxxxxxxxxx
>> > Subject: Re: Dataguard setup
>> >
>> > Brian/Steve,
>> > Thanks a lot for your help. It really helped. I have started the
>> > standby database.
>> >
>> > Finally when I try to start my primary database i recieve below
>> > error:Please advice.
>> >
>> > SQL> startup
>> > ORACLE instance started.
>> >
>> > Total System Global Area 1073741824 bytes
>> > Fixed Size        1264892 bytes
>> > Variable Size     427819780 bytes
>> > Database Buffers      633339904 bytes
>> > Redo Buffers       11317248 bytes
>> > Database mounted.
>> > ORA-01157: cannot identify/lock data file 1 - see DBWR trace file
>> > ORA-01110: data file 1: '/u02/oravis/dgtestdata/system.dbf'
>> >
>> >
>> > Thanks,
>> > kalyan
>> >
>> > On Thu, Mar 12, 2009 at 4:08 PM, Dwyer, Brian
>> > <Brian.Dwyer@xxxxxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
>> > >
>> >
>> **********************************************************************
>> > > ***** Internet email is not to be treated as a secure means of
>> > > communication.
>> > > North Yorkshire Police monitors all internet email activity
>> > and content.
>> > > This communication is intended for the addressee(s) only.
>> > > Please notify the sender if received in error.
>> Unauthorised use or
>> > > disclosure of the content may be unlawful. Opinions
>> > expressed in this
>> > > document may not be official policy.  Thank you for your
>> > co-operation.
>> > >
>> >
>> **********************************************************************
>> > > *****
>> > >
>> > > Kalyan
>> > >
>> > > I think this is right.
>> > >
>> > > When starting the standby database so that you can recover
>> > the archive
>> > > logs you should do
>> > >
>> > > Startup nomount
>> > > Alter database mount standby database;
>> > >
>> > > You then need to put it into recovery.
>> > >
>> > > Alter database recover managed standby database disconnect;
>> > >
>> > > Brian
>> > >
>> > >
>> > > -----Original Message-----
>> > > From: ora-apps-dba-bounce@xxxxxxxxxxxxx
>> > > [mailto:ora-apps-dba-bounce@xxxxxxxxxxxxx] On Behalf Of
>> > Kalyan Sundar
>> > > Sent: 12 March 2009 10:12
>> > > To: ora-apps-dba@xxxxxxxxxxxxx
>> > > Subject: Dataguard setup
>> > >
>> > > Hi All,
>> > > I am in a process of implementing datagaurd on one of our
>> > test database.
>> > > Please advice.
>> > >
>> > > Where in I recieve following error when starting the
>> > stand-by database:
>> > > SQL> startup
>> > > ORACLE instance started.
>> > >
>> > > Total System Global Area 1073741824 bytes Fixed Size
>>   1264892
>> > > bytes Variable Size     427819780 bytes Database Buffers
>> > > 633339904 bytes Redo Buffers       11317248 bytes
>> > > ORA-01102: cannot mount database in EXCLUSIVE mode
>> > >
>> > >
>> > > Kalyan
>> > >
>> > >
>> > >
>> >
>> >
>>
>>
>
>

Other related posts: