DATAGUARD Management archive interrupt

If the backup system did not receive one or more of the primary database archived redo log files generated in the backup system will appear on archive interruption. Missing archived redo log file is interrupted. If there is disruption, then the Data Guard automatically detects and through copies of the missing sequence of log files to prepare the destination to resolve. For example, when the network becomes unavailable, from the primary database to a standby database, automatically archiving the temporary stop, there will be disruption archive. When the network is available again, from the primary database to the failure of the database redo data prepared by the automatic transmission to continue.
Data Guard does not require DBA manual intervention to detect and resolve such interrupts. The following section describes the interrupt detection and resolution.




Found that interrupt when the archive?

Whenever the primary database archives a log locally, but the prepared site does not receive the log archive interrupt occurs. Per minute, the primary database to investigate the Preparation of the database to see whether the archived redo log file sequence interruptions.



How to solve the break?

Interruption recovery solution through the polling mechanism. Prepared for the physical and logical databases, Oracle Change Data Capture, and Oracle Streams, Data Guard by automatically retrieving missing from the primary database archived redo log files to perform interrupt detection and resolution. No additional configuration settings to investigate the prepared database to detect any disruption or settlement disruption.
A very important consideration here is automatically interrupted recovery is in accordance with the primary database depend on the availability. If the primary database is not used, and you prepare to configure multiple physical databases, you can set up additional initialization parameters allow the database redo applications solve the archive from the others prepared interrupted.




Note:
In Oracle Database 10g version of the one before, FAL client and server from the primary database used to solve the break.




Use to take archive log (FAL) to address the archiving break


Take archive log (FAL) client and service to address the main database-generated databases and physical prepared to receive the archived redo log files to the range of detected interrupt.
  • del.icio.us
  • StumbleUpon
  • Digg
  • TwitThis
  • Mixx
  • Technorati
  • Facebook
  • NewsVine
  • Reddit
  • Google
  • LinkedIn
  • YahooMyWeb

Related Posts of DATAGUARD Management archive interrupt

  • ORACLE10G full version centos5 installed (the installation has passed)

    ORACLE10G full version centos5 installed (the installation has passed) 1. Centos 5.0 install rn GUI must be installed, it is best not to start selinux rn rn rn 2. . Ready to install the software: (this is very important, is the first installation fai ...

  • SGA extended the principle of 32bit oracle

    SGA extended the principle of 32bit oracle From: http://www.itpub.net/247048.html Because the median 32bitrnoracle restrictions can only visit the oracle process 4g (2 of 32 power) following virtual memory address, the time at a lot of people this is ...

  • Dbms_obfuscation_toolkit use of Oracle's encryption and decryption of data (to)

    In order to protect sensitive data, oracle start from 8i to provide a data encryption package: dbms_obfuscation_toolkit. Take advantage of this package, our data can be DES, Triple DES or MD5 encryption. This article on the use of this and the use of ...

  • Troubleshooting: the physical set up the backup database

    Articles connected to "Fault Diagnosis: A physical backup of database", in the articles on which there is mentioned that in good physical backup of the database set up after the main database found to be unable to synchronize the archive lo ...

  • Oracle in the relationship between User and Schema

    If we want to know the database and the User What is the relationship between Schema, we must first know about User and Schema database What is the concept in the end. In SQL Server2000 in architecture because of the reason, User and Schema there is ...

  • High Availability Oracle Flashback

    Brief introduction Flashback Database is a point in time (PIT) restore the database approach. This incomplete recovery strategy can be used to restore the logic because of human error cause damage to the database. At the introduction of 10g, it is de ...

  • An example of the use of TKPROF

    First, view and edit parameters SQL> show parameter max_dump_file_size NAME TYPE VALUE ------------------------------------ ----------- --- --------------------------- max_dump_file_size string UNLIMITED SQL> show parameter user_dump_dest NAME TYPE

  • Diagnosis and principles of order

    SQL> select disk.value "Disk", mem.value "Mem", 2 (disk.value / mem.value) * 100 "Ratio" 3 from v $ sysstat mem, v $ sysstat disk 4 where mem.name = 'sorts (memory)' 5 and disk.name = 'sorts (disk)'; D ...

  • ORACLE 10G dataguard configuration Step by Step

    oracle dataguard

Leave a Reply

Recent
Recent Entries
Tag Cloud
Random Entries
Latest Comments