RE: datguard issue
Date: Thu, 14 Jan 2010 09:26:27 -0500
Message-ID: <6B0D50B70F12BD41B5A67F14F5AA887F037D1803_at_us-bos-mx022.na.pxl.int>
Kar,
In my experience if MRP cannot connect to a process on the primary database, namely the log_archive_dest_n parameter is set for lgwr or arch on the primary then managed standby will never work. You will have to set your cron script to copy the archive log files to the standby and then manually recover the database.
Dick Goulet
Senior Oracle DBA/NA Team Lead
PAREXEL International
From: K R [mailto:kp0773_at_gmail.com]
Sent: Thursday, January 14, 2010 9:16 AM
To: Goulet, Richard
Cc: Oracle-L_at_freelists.org
Subject: Re: datguard issue
Thanks Dick.
on primary log_archive_dest is not blank. log_archive_dest_n is all blanks on primary . we are not configuring any parameter change for the logshipping to standby on primary . we are using a cron script to transfer the archivelogs from primary to standby into archive_archive_dest with standby_file_management set to AUTO. if i do recover standby database then it is seeing all the archivelog . but my observation so far is that it is not seeing the MRP process.
I see few message on v$dataguard_message showing
Log Apply Services Warning 0 7 0 NO 13-JAN-10
Media Recovery Waiting for thread 1 seq# 4239
and on v$archive_dest_status
LOG_ARCHIVE_DEST_11
VALID PHYSICAL MOUNTED-STANDBY MANAGED MAXIMUM PERFORMANCE
/arch/DEVD4/
0 0 0 0 0 0 NO
and v$managed_standby
1* SELECT * from v$managed_standby
SQL> /
ARCH 6107 CONNECTED ARCH
7005
N/A
N/A 0 0 0 0 0 0 0 ARCH 6101 CONNECTED ARCH
7007
N/A
N/A 0 0 0 0 0 0 0 MRP0 6124 WAIT_FOR_LOG N/A N/A N/A N/A 1 4239 0 0 0 0 0
Thanks
On Thu, Jan 14, 2010 at 5:59 AM, Goulet, Richard <Richard.Goulet_at_parexel.com> wrote:
Kar,
On the primary did you set the log_archive_dest_n parameters and leave log_archive_dest blank? Also can the primary tnsping to the standby?
Dick Goulet Senior Oracle DBA/NA Team Lead PAREXEL Internationalstandby database .
________________________________
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of K R Sent: Wednesday, January 13, 2010 11:42 PM To: Oracle-L_at_freelists.org Subject: datguard issue Hi, Oracle 9i database running on hp-ux .. I am trying to create a
did all the standby setup . but I have not done any standby changes for primary database.
However when i mount the standby database and do a recover standby database then it is finding the archive log files on the standby server .
However when i try to do the managed standby database it do not find the archivelog file .
What am I missing ? appreciate any pointers
thanks in advance Kar
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Jan 14 2010 - 08:26:27 CST