Re: datguard issue
Date: Thu, 14 Jan 2010 06:16:08 -0800
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
> 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 International
> *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
> Oracle 9i database running on hp-ux .. I am trying to create a standby
> database .
> 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