dataguard oracle

library failed to receive a confirmation message from the standby , the LNS connection is disconnected , and the transaction continues to be committed on the main library. Maximum protection mode: Put data protection first and use SYNC to redo the transfer. If the main library does not receive a confirmation message for the available repositories, the main library stops. V. Role Management and role transformationThere are two roles in DG, the main library and the repository, and there are two

Dataguard Online redo log and Standby redo log Dataguard classification: Physical Standby (Redo Apply) Logical Standby (SQL Apply) Dataguard protection mode: maximize performance (maximum performance mode) maximize availability (maximum available mode) maximize protection (maximum protection mode) Online redo log stores Unarchived changes of Online transactions.

Gap is created by the fact that the archive log between the repository and the main repository may be inconsistent due to network and other reasons between the Dataguard master and standby.Steps to resolve gap:1. Get gap details in the standby library2. Copy the required archive logs from the main library to the standby library3. The Standby library registers the archive log and then applies it.--Standby Alert log hint gap detailsMedia Recovery waitin

11g Dataguard standby cut into the main library and restored to the original standby environment after the test is completed#######################Overview:11204 single machine to implement DG, because the local requirements (read-write mode) to open standby, and then the original production environment can not have any impact, still external services;The idea is that: Standby direct failover to primary db, then the original DG relationship is destroy

About Rman duplicate from active database. Detailed operation is actually backup as copy. Will copy very many empty blocks. For those database data files more than 100G is not very recommended, and to a large extent will be limited by network bandwidth, in the event of an exception, it is very painful to start again.In doing dataguard can not duplicate from active database, or do not use, the most reliable or with Rman first back up a bar; do it again

problem, then, the MRP problem in dataguard can be solved.The data file in the problem of ora-01157 does not exist in the master database, but in the backup database data dictionary, we can directly solve the problem in the backup database.Idle> alter database datafile '/u02/dg11g/oradata/DG11G/test_new01.dbf' offline drop;Database altered.Then there is a turning point in the mongouard log, and the file will be verified in the background, but a warni

ORA-01665 solution in Oracle11g dataguard CreationOracle 11g fails to restore the standby control file when creating data guard. When I mount standby database, tell me that the control file is not a standby control file and the information is ORA-01665: control file is not a standby control file ".The control file is generated using rman in the master database.Backup current controlfile for standby format 'xxxxxx/ctl. stdy ';Copy to the slave database

The company's 11g Dataguard master is not in sync, check the steps as follows:Primary: Querying the maximum log for the main librarySql> select Max (sequence#) from V$archived_log;Sql> select Max (sequence#) from V$archived_log where applied= ' YES ';Standby: Querying the maximum log for a standby librarySql> select Max (sequence#) from V$archived_log;Sql> select Max (sequence#) from V$archived_log where applied= ' YES ';Query whether the main library

Error | resolution In the Dataguard environment if we are doing failover, we may encounter ORA-00261 errors, the following is the cause of the error and the solution. If you need to switch because of a network problem, the RFS process on the standby side usually does not realize that primary is inaccessible, so the RFS process does not release the current standby redo log file. If the primary end of the database instance is interrupted by a failure, t

Label:About Rman duplicate from active database, the actual operation is backup as copy, copy many empty blocks, for those database data files more than 100G is not very recommended, to a large extent, is limited by network bandwidth, A little abnormal, it is necessary to start again, very painful;In doing dataguard can not duplicate from active database, or do not use, the most reliable or with Rman first back up a bar;Copyright NOTICE: This article

WrongMis-:file #483 addedtocontrolfileas ' UNNAMED00483 ' becausethe Parameterstandby_file_managementissettomanualthefileshouldbe manuallycreatedtocontinue. errorswithlog+fra/cweolb/archivelog/2015_08_02/thread_1_seq_225515.7695.886664431mrp0: Backgroundmediarecoveryterminatedwitherror1274errorsinfile /oracle/orabase/admin/CWEOLB/diag/rdbms/cweolb/CWEOLB/trace/CWEOLB_pr00_19398846.trc:ORA-01274: cannotadddatafile ' +data/cweol/datafile/tstlog.20150802

The company set up a slave uard. At the beginning, it did not pay attention to the management of archiving logs in the slave database. After the system was running for a while, it was found that the space of the slave database was cracked up by archiving logs. Solution The company set up a slave uard. At the beginning, it did not pay attention to the management of archiving logs in the slave database. After the system was running for a while, it was found that the space of the slave database was

In the physical standby database before Oracle11g, the Standby database can be opened in read-only mode, but the MediaRecovery (redoApply) process stops. If the standby database is recovered In the physical standby database before the Oracle 11g, the Standby database can be opened in read-only mode, but the Media Recovery (redo Apply) process stops. If the standby database is recovered I. New Features of the physical standby Database 1. The physi

: media recovery requiredOr: -- RECOVERY NEEDEDSQL> select switchover_status from v $ database;SWITCHOVER_STATUS--------------------RECOVERY NEEDED###############SQL> alter database recover managed standby database disconnect from session;Database altered.SQL> select switchover_status from v $ database;SWITCHOVER_STATUS--------------------TO PRIMARYSQL> alter database commit to switchover to primary;Database altered.3. After the master database is switched to the slave database, the slave databa

First, Sys landing Instance: $ sqlplus/as SYSDBA Sql*plus:release 10.2.0.4.0-production on Wed Nov 3 07:35:34 2010 Copyright (c) 1982, 2007, Oracle. All Rights Reserved. Connected to a idle instance. ----------------------------------------------------- Second, prepare the library to boot to the management recovery mode Sql>startup Nomount; Sql>alter database mount standby database; Sql>alter database recover managed standby database disconn

'*. Open_cursors = 300*. Open_links = 4*. Parallel_max_servers = 20*. Pga_aggregate_target = 170917888*. Processses = 150*. Recyclebin = 'off'*. Remote_login_passwordfile = 'clusive'*. Sga_max_size = 1073741824*. Sga_target = 1073741824*. Standby_file_management = 'auto'*. Star_transformation_enabled = 'true'*. Streams_pool_size = 26214400*. Trace_enabled = FALSE*. Undo_management = 'auto'*. Undo_retention = 3600*. Undo_tablespace = 'undotbs1'*. User_dump_dest = '/opt/dgdb/admin/dgdb/udump'*. Ut

About rman duplicate from active database to build dataguard, rmandataguard For rman duplicate from active database, the actual operation is backup as copy. Many empty blocks will be copied. It is not recommended for those with database data files exceeding GB; to a large extent, it is subject to network bandwidth restrictions. Once an exception occurs, it is very painful to start from the beginning;You can skip duplicate from active database when p

DataGuard uses altersystemarchivelogcurrent to maintain ArchiveLog Data Guard uses alter system archive log current to maintain the Archive Log We can use Archive Log management during routine Data Guard maintenance: ① Alter system switch logfile ② Alter system archive log current What are the differences between the two? Alter system switch logfile -- Only switches the current online log to another group and triggers a checkpoint. Then, t

/';4. Take a look at the location of the Controlfile because the backup control file will be used next.Idle> Show Parameter controlLook at the location of the Standby_log file again, as it may need to be rebuilt next.idle> Select *from v$logfile;5. Use the following command to recover from RmanRman>run{Restore standby controlfile to '/tmp/stb_controlfile01.ctl ';Recover database Noredo;}If the following error is reported, it is possible that the recover managed standby command is executing:Ora-1

Dataguard-solution for gap generation on the standby machine Sometimes, due to network or backup failure, the archived logs generated by the host cannot be uploaded to the backup machine. In this case, the backup machine generates a gap. How can this problem be solved? Note that once the gap is generated, even if the archive log after the gap can be uploaded to the standby database normally, the Standby database will not apply the subsequent log