Re: Equivalent Logical standby Command for alter database recover managed standby database delay 15 disconnect from session;

  • From: Niall Litchfield <niall.litchfield@xxxxxxxxx>
  • To: sundarmahadevan82@xxxxxxxxx
  • Date: Fri, 19 Aug 2011 17:39:19 +0100

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@xxxxxxxxx>
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.

Other related posts: