How do I set a latency log application for a physical volume uard?

Source: Internet
Author: User
How do I set a latency log application for a physical volume uard? Note that if real-time Apply is enabled, the DELAY parameter is ignored. To set the Apply DELAY, you must use "DELAY =" on the log_archive_dest_n parameter ", for example, DELAY = 360 (in minutes) indicates a DELAY of 360 minutes (6 hours ). For example:
SQL> alter system set log_archive_dest_2 = 'service = standby LGWR SYNC affrem DELAY = 360VALID_FOR = (ONLINE_LOGFILES, PRIMARY_ROLE) COMPRESSION = ENABLE DB_UNIQUE_NAME = standby ';


If only the DELAY parameter is specified but no specific value is specified, the default value is 30 minutes.


Note that if real-time apply is enabled, the DELAY parameter is ignored, so the delayed log application is not enabled, in the alert log of the standby database, you can see information similar to the following:
WARNING: Managed Standby Recovery started with USING CURRENT LOGFILE
DELAY 360 minutes specified at primary ignored <


In this case, you need to stop the real-time log application and start MRP in non-real-time mode. For example:
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;


See the following example:
1. view the parameter settings of the master database:
SQL> show parameter log_archive_dest_2


NAME TYPE VALUE
-----------------------------------------------------------------------------
Log_archive_dest_2 string SERVICE = STANDBY LGWR SYNC AFFI
RM VALID_FOR = (ONLINE_LOGFILES,
PRIMARY_ROLE) DB_UNIQUE_NAME = S
TANDBY


2. Set a latency of 5 minutes in the master database:
SQL> alter system set log_archive_dest_2 = 'service = STANDBY LGWR SYNC affrem delay = 5VALID_FOR = (ONLINE_LOGFILES, PRIMARY_ROLE) DB_UNIQUE_NAME = standby ';


3. Verify the latency:


Master database execution:
SQL> alter system switch logfile;
System altered.


SQL> select max (sequence #) from v $ archived_log;


MAX (SEQUENCE #)
--------------
28


Slave database:
Wed Jun 13 19:48:53 2012
Archived Log entry 14 added for thread 1 sequence 28 ID 0x4c9d8928 dest 1:
ARCb: Archive log thread 1 sequence 28 available in 5 minute (s)
Wed Jun 13 19:48:54 2012
Media Recovery Delayed for 5 minute (s) (thread 1 sequence 28) < <延时生效
Wed Jun 13 19:53:54 2012
Media Recovery Log/home/oracle/arch1/standby/logs 28_757620395.arc <5 minutes later
Media Recovery Waiting for thread 1 sequence 29 (in transit)

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.