Re: Dataguard setup

Steve,
Thanks a lot for spending your time in resolving this issue.

yes, I have enabled managed recovery already....

Please find the init.ora parameters for primary and standby database.
Kindly review and let me know if i need to change any value.

PRIMARY DB:
*****************

db_name                         = DGTEST
control_files                   =
/u02/oravis/dgtestdata/cntrl01.dbf,/u02/oravis/dgtestdata/cntrl02.dbf,/u02/oravis/dgtestdata/cntrl03.dbf
db_block_size                   = 8192
compatible                      = 10.2.0
db_unique_name=DGTEST
LOG_ARCHIVE_CONFIG='DG_CONFIG=(DGTEST,DGSTDBY)'
LOG_ARCHIVE_DEST_1='LOCATION=/u02/oravis/dgtestdata/archive
VALID_FOR=(ALL_LOGFILES,ALL_ROLES)
DB_UNIQUE_NAME=DGTEST'
LOG_ARCHIVE_DEST_2='SERVICE=DGSTDBY LGWR ASYNC
VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)
DB_UNIQUE_NAME=DGSTDBY'
LOG_ARCHIVE_DEST_STATE_1=ENABLE
LOG_ARCHIVE_DEST_STATE_2=ENABLE
LOG_ARCHIVE_FORMAT=%t_%s_%r.arc
LOG_ARCHIVE_MAX_PROCESSES=30
remote_login_passwordfile='EXCLUSIVE'
FAL_SERVER=DGSTDBY
FAL_CLIENT=DGTEST
STANDBY_FILE_MANAGEMENT=AUTO
DB_FILE_NAME_CONVERT='/u02/oravis/dgstdbydata','/u02/oravis/dgtestdata'
LOG_FILE_NAME_CONVERT='/u02/oravis/dgstdbydata','/u02/oravis/dgtestdata'
remote_os_authent=true


STANDBY DB
*****************

db_name                         = DGTEST
control_files                   =
/u02/oravis/dgstdbydata/cntrl01.dbf,/u02/oravis/dgstdbydata/cntrl02.dbf,/u02/oravis/dgstdbydata/cntrl03.dbf
db_block_size                   = 8192
compatible                      = 10.2.0
LOG_ARCHIVE_DEST_1='LOCATION=/u02/oravis/dgtestdata/archive
VALID_FOR=(ALL_LOGFILES,ALL_ROLES)
DB_UNIQUE_NAME=DGTEST'
LOG_ARCHIVE_DEST_2='SERVICE=DGSTDBY LGWR ASYNC
VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)
DB_UNIQUE_NAME=DGSTDBY'
LOG_ARCHIVE_DEST_STATE_1=ENABLE
LOG_ARCHIVE_DEST_STATE_2=ENABLE
db_unique_name=DGSTDBY
LOG_ARCHIVE_CONFIG='DG_CONFIG=(DGTEST,DGSTDBY)'
LOG_ARCHIVE_FORMAT=%t_%s_%r.arc
LOG_ARCHIVE_MAX_PROCESSES=30
remote_login_passwordfile='EXCLUSIVE'
FAL_SERVER=DGTEST
FAL_CLIENT=DGSTDBY
STANDBY_FILE_MANAGEMENT=AUTO
DB_FILE_NAME_CONVERT='/u02/oravis/dgtestdata','/u02/oravis/dgstdbydata'
LOG_FILE_NAME_CONVERT='/u02/oravis/dgtestdata','/u02/oravis/dgstdbydata'
remote_os_authent=true

Thanks,
Kalyan


On Fri, Mar 13, 2009 at 4:40 PM, Laskey Steve
<Steve.Laskey@xxxxxxxxxxxxxx> wrote:
> 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: