RE: datguard issue
Date: Thu, 14 Jan 2010 09:26:27 -0500
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.
Senior Oracle DBA/NA Team Lead
From: K R [mailto:kp0773_at_gmail.com]
Sent: Thursday, January 14, 2010 9:16 AM To: Goulet, Richard
Subject: Re: datguard issue
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
VALID PHYSICAL MOUNTED-STANDBY MANAGED MAXIMUM PERFORMANCE /arch/DEVD4/
0 0 0 0 0 0 NO
1* SELECT * from v$managed_standby
SQL> / ARCH 6107 CONNECTED ARCH
N/A 0 0 0 0 0 0 0 ARCH 6101 CONNECTED ARCH
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
On Thu, Jan 14, 2010 at 5:59 AM, Goulet, Richard <Richard.Goulet_at_parexel.com> wrote:
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 KarReceived on Thu Jan 14 2010 - 08:26:27 CST