RE: Dataguard setup
- From: "Laskey Steve" <Steve.Laskey@xxxxxxxxxxxxxx>
- To: <ora-apps-dba@xxxxxxxxxxxxx>
- Date: Fri, 13 Mar 2009 11:10:13 -0000
Kalyan,
You also mention that you have mounted the standby database, have you enabled
managed recovery....
Alter database mount standby database;
Alter database recover managed standby database disconnect from session;
/Steve
> -----Original Message-----
> From: ora-apps-dba-bounce@xxxxxxxxxxxxx
> [mailto:ora-apps-dba-bounce@xxxxxxxxxxxxx] On Behalf Of Laskey Steve
> Sent: 13 March 2009 11:02
> To: ora-apps-dba@xxxxxxxxxxxxx
> Subject: RE: Dataguard setup
>
> Kalyan,
>
> Basic question....
>
> You have configured standby archive destination (and enabled)
> on primary? Also, have you set FAL parameters (inc.
> tnsnames.ora entries)?
> Also, have you enabled archive log mode?
>
> ON PRIMARY
> ==========
>
> Init.ora
> Log_archive_dest_2='SERVICE=DRDB ARCH REOPEN=10' (if you
> want to arch process and not realtime apply!)
> Log_archive_dest_state_2='ENABLE'
>
> Tnsnames.ora
> DRDB=(DESCRIPTION=(SDU=32768)(ADDRESS=(PROTOCOL=tcp)(HOST=dr-h
> ost)(PORT=????))(CONNECT_DATA=(SID=dbsid)))
>
> ON STANDBY
> ==========
>
> Init.ora
> Standby_archive_dest='LOCATION=/whereever'
> Standby_file_management=auto
> FAL_SERVER=DBPRIMARY
> FAL_CLIENT=DRDB
>
> Tnsnames.ora
> DBPRIMARY=(DESCRIPTION=(SDU=32768)(ADDRESS=(PROTOCOL=tcp)(HOST
> =primary-host)(PORT=????))(CONNECT_DATA=(SID=dbsid)))
>
>
> /Steve
>
>
> > -----Original Message-----
> > From: ora-apps-dba-bounce@xxxxxxxxxxxxx
> > [mailto:ora-apps-dba-bounce@xxxxxxxxxxxxx] On Behalf Of
> Kalyan Sundar
> > Sent: 13 March 2009 07:13
> > To: ora-apps-dba@xxxxxxxxxxxxx
> > Subject: Re: Dataguard setup
> >
> > Steve - Thanks once again. this note really helped.
> > I configured standby database successfully..
> >
> > Started Primary database and kept Standy database on mount. I am
> > trying to test the basic functionality of data gaurd. I
> could not see
> > any change made to the primary being reflected on Standby. Will it
> > take some time for thsi change to get updated? Is there any
> other way
> > to test it?
> >
> > On standby:
> > SQL> select sequence#, applied from v$archived_log order by
> sequence#;
> >
> > no rows selected
> >
> > On Primary:
> > ALTER SYSTEM SWITCH LOGFILE;
> >
> > On standby:
> > SQL> select sequence#, applied from v$archived_log order by
> sequence#;
> >
> > Thanks,
> > Kalyan
> >
> > On Thu, Mar 12, 2009 at 5:24 PM, Laskey Steve
> > <Steve.Laskey@xxxxxxxxxxxxxx> wrote:
> > > Kalyan,
> > >
> > > Are permissions on directory and db files correct?
> > >
> > > For DB_FILE_NAME_CONVERT see metalink note# 47325.1
> (usually used on
> > > standby if file structure/mount points are different from primary)
> > >
> > > /Steve
> > >
> > >> -----Original Message-----
> > >> From: ora-apps-dba-bounce@xxxxxxxxxxxxx
> > >> [mailto:ora-apps-dba-bounce@xxxxxxxxxxxxx] On Behalf Of
> > Kalyan Sundar
> > >> Sent: 12 March 2009 11:49
> > >> To: ora-apps-dba@xxxxxxxxxxxxx
> > >> Subject: 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:
