Re: Dataguard setup
- From: Kalyan Sundar <kalyan.sundu@xxxxxxxxx>
- To: ora-apps-dba@xxxxxxxxxxxxx
- Date: Tue, 24 Mar 2009 11:48:54 +0530
Hi All,
Thanks for your inputs.
This issue got resolved.
This is because of improper creation on password file.
Password file has been created with correct syntax and it fixed this issue.
Could any one help me out to implement 'real time apply' feature to
standby database?
I used below query which hangs indefenitely....
SQL> alter database recover managed standby database using current
logfile disconnect;
Thanks,
Kalyan
On Tue, Mar 17, 2009 at 3:40 PM, Kalyan Sundar <kalyan.sundu@xxxxxxxxx> wrote:
> Hi all,
>
> When I query from v$Archive_dest on primary, I recieve following error msg.
> Kindly advice.
>
> SQL> SELECT dest_name,Status, Error FROM v$Archive_dest;
>
> DEST_NAME STATUS ERROR
>
> LOG_ARCHIVE_DEST_1 VALID
> LOG_ARCHIVE_DEST_2 ERROR ORA-16191: Primary log shipping client not
> logged on standby
>
> Thanks,
> Kalyan
>
> On Mon, Mar 16, 2009 at 12:31 PM, Kalyan Sundar <kalyan.sundu@xxxxxxxxx>
> wrote:
>> 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:
