When talking about the Gap Processing Mechanism of dataguard, the measure most people can say is to set fal_server and fal_client. From 9i, Oracle provides two types of loggap detection and processing
When talking about the Gap Processing Mechanism of dataguard, the measure most people can say is to set fal_server and fal_client. From 9i,
/oradata/orcl/users03.dbf/u01/app/oracle/ oradata/orcl/users04.dbf/u01/app/oracle/oradata/orcl/test02.dbf10 rows selected.-- Modify the protection mode and protection level of the main library:--View the main library protection mode and protection level:sql> Select Protection_mode,protection_level from V$database;protection_ MODE Protection_level--------------------NB Sp -------------
Tag: TNS try post message limit error triggers journey threadAfter the Dataguard has upgraded the CPU. found that the main repository can not be synchronized, the log error. Therefore, after the upgrade of the main library runs, the post-script "@catbundle. SQL CPU Apply" cannot be synchronized to the standby libraryPhenomenon:Broker Status:[Email protected] ~]$ DGMGRL sys/oracleDGMGRL for Linux:version 11.2.0.3.0-64bit ProductionCopyright (c),
1, after the establishment of dataguard, archive log transmission but to view the master database on the log tail-fdataoraclediagrdbmstest_m1powerdestracealert_powerdes.log, the display information is as follows: SunMay0800: 34: 172016error10341_edloggingontothestandbyping [ARC
1. After the slave uard is set up, the archive log cannot be transferred to view the log tail-f/data/oracle/diag/rdbms/test_m1/powe
/o1_mf_1_9_c7wqvrp9_.arc List ofFiles which Where notCataloged =======================================FileName:/oracle/app/oracle/flash_recovery_area/standby/onlinelog/o1_mf_9_c7c1v5qw_.log RMAN-07529: Reason:catalog is notSupported forThisfile type
FileName:/oracle/app/oracle/flash_recovery_area/standby/onlinelog/o1_
partitioning, OLAP, Data Mining and Real application testing options Sql>
If you look at the background alert log in the Master Library Master Library, you will find that you have a record of starting the Transfer archive log:......******************************************************************Lgwr:setting ' active ' archival fordestination log_archive_dest_2******************************************************************Lgwr:standby Redo LogFile Selected toarchive thread
DataGuard is increasingly becoming an important tool for disaster recovery and pressure-sharing in databases. As the legendary DBA, you have to go to the kitchen and get to the hall. Take a look at this.
DataGuard is increasingly becoming an important tool for disaster recovery and pressure-sharing in databases. As the legendary DBA, you have to go to the kitchen and get to the hall. Take a look at this.
Premise:-Standby database must is in Flashback database mode. -time at which Drop/truncate/delete Table happened should is within the db_flashback_retention_target and all the Flashba CK and archive logs should be availableRetrieve the wrong drop/truncate/delete from the main library on the Dataguard Repository table reference article: How to Recover from A drop/truncate/delete table do on Primary Using Flashback on A Standby database (document ID 9
DataGuard how to transmit Redo to Standby
DataGuard transfers redo to standby and then applies the redo on standby to ensure data consistency between the two.The lgwr process is used to transmit redo logs.
In the lgwr transfer mode, the lgwr process itself does not actually send redo to standby, but derives an lns (local network server) from lgwr)Process to transmit redo information. The main advantage of t
Analyze and solve the problem that MRP cannot be started in DataGuard
I have a dedicated uard environment on hand, because it has been useless for some days. As a result, I was suddenly prepared to start learning, and suddenly found that after I typed the command recover managed standby database disconnect from session, the command runs normally, but the ora error is reported in the background.
Sat Jun 27 23:16:39 2015Recovery Slave PR00 previusly exi
Detailed steps for building dataguard at ORACLE11G (all physical standby operations)Preface:DATAGUARD establishes a reference relationship by establishing a PRIMARY and STANDBY group. Once STANDBY is created, DATAGUARD passes the REDO of the PRIMARY database (PRIMARY) to the STANDBY database, then, apply REDO in STANDBY to synchronize databases.1. installation environmentProject ListPrimary LibraryStandby L
Description
There are many ways to create dataguard, this article is divided into one of the ways, 10g/11g are applicable.
This paper creates an Oracle 11g Dataguard physical repository through the Rman target Master library and the local auxiliary library through a local backup recovery data file.
First, the environment introduction
1. Primary database envir
When talking about the Gap Processing Mechanism of dataguard, the measure most people can say is to set fal_server and fal_client. From 9i, Oracle provides two types of log gap detection and processing mechanisms. For gap processing, the fal _ * parameter is not required in some cases.
1. Automatic Gap Resolution2. FAL Gap Resolution
1. Automatic Gap Resolution
Starting from 9i,
Reference Document 278641.10. BackupSPFile of the Master and Standby libraryBacking up data from the main library1. Pause the log transfer to the standby library on the main libraryAlter system set Log_archive_dest_state_x=defer scope=both sid= ' * '2. Turn off the standby and the standby to monitor the PSU; do not need to execute catpatch/catbundle/catcpu these scripts; after patching, boot the repository to mount State and start the standby monitor(1) Shut down the database and monitorShutdown
implementation level, sparse files mean fewer redo logs are generated. So what is the difference between the features of Temp files and common files in the DG Environment? Next we will prove it through a series of experiments.
-------------------------------------- Split line --------------------------------------
References:
Important configuration parameters of Oracle Data Guard
Configure Oracle 11g Data
target (standby apply node ), this directly determines the Data Protection Level of the dataguard.
The format is as follows:
Primary Site: *.LOG_ARCHIVE_DEST_2='SERVICE=DR1 lgwr async VALID_FOR=(ONLINE_LOGFILES, Primary_role) 'standby site: (effective after switch over) *. log_archive_dest_2 = 'service = db1 lgwr async valid_for = (online_logfiles,PRIMARY_ROLE) '
Note:1> the service value defined in The log_archive_dest_2 parameter,
Problem phenomenonAfter using shutdown abort to stop Dataguard Standby library, the library can not open, reported ORA-01196 error.Specific as follows:Found a standby library can not apply the log, view the repository log did not find an error, suspect that the standby Library application log service stopped, so try to restart the repository;May be because the standby library is busy reading business, shutdown immediate shut down the standby time is t
Today there is an Oracle physical Dataguard apply is slow, according to the official DG optimization document to modify the relevant parameters,The following method has a little effect, but not much.1, modify the degree of parallelismALTER database RECOVER MANAGED STANDBY database PARALLEL 8 using current logfile disconnect from session;2. Modify message sizealter system Set Parallel_execution_message_size
When the Dataguard upgrade CPU, found that the main standby library can not be synchronized, the log error, so in the main library after the upgrade of the execution of the script "@catbundle. SQL CPU Apply" cannot be synchronized to the standby libraryPhenomenon:Broker Status:[Email protected] ~]$ DGMGRL sys/oracleDGMGRL for Linux:version 11.2.0.3.0-64bit ProductionCopyright (c), Oracle. Allrights reserved
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.