Re: Equivalent Logical standby Command for alter database recover managed standby database delay 15 disconnect from session;
From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Fri, 19 Aug 2011 17:39:19 +0100
Message-ID: <CABe10sZs6VkggjJbwnBwX2QAoJbKO_Bft65qPEnHmeyr-Nd0+w_at_mail.gmail.com>
Normally you set the apply delay as a parameter to the log_archive_dear_n parameter doesn't delay shipping, delays application. Or you could wait for the logical standby to fall woefully behind :(
Date: Fri, 19 Aug 2011 17:39:19 +0100
Message-ID: <CABe10sZs6VkggjJbwnBwX2QAoJbKO_Bft65qPEnHmeyr-Nd0+w_at_mail.gmail.com>
Normally you set the apply delay as a parameter to the log_archive_dear_n parameter doesn't delay shipping, delays application. Or you could wait for the logical standby to fall woefully behind :(
On 19 Aug 2011 14:43, "sundar mahadevan" <sundarmahadevan82_at_gmail.com> wrote:
Hi All,
I am looking for an equivalent command to execute on the logical standby to
delay applying of archived logs. I know the physical standby command for
this is requirement is "alter database recover managed standby database
delay 15 disconnect from session;" but cant find the equivalent logical
standby command. I am on 11.2.0.2. So EXECUTE
DBMS_LOGSTDBY.APPLY_SET('APPLY_DELAY',15); does not work. I do not want to
add delay on the primary to transfer the files. Appreciate your help.
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Aug 19 2011 - 11:39:19 CDT