data guard oracle 11g step by step

The following is a detailed analysis of the use of Switchover and Failover in Oracle. For more information, see Role Switching between Data Guard master and slave databases is divided into the following two types:1) SwitchoverSwithchover is generally designed to switch roles, such as upgrading. It is usually lossless, that is, there will be no

[Oracle] Data Guard-Redo applications physical Standby and logical Standby Log application services are divided into two types, one is physical Standby Redo applications, similar to media recovery, its advantage is that the speed is fast, but in 10g cases, Standby must be in the mount State and cannot share part of the read load for Primary (physical Standby can

We all know that the main function of Oracle data guard is disaster tolerance. We all know that data guard has the following features: high availability, performance improvement, DATA protection, and fault recovery.

is, let the user $ result (dirty block) modified in step 2. Change the user name) user $ written to the data file System altered. SQL> alter system flush shared_pool; ---- when you create user tickets in the Next Step (4. create the same user name), the oracle system automatically modifies the system table

The operating system version and database version are as follows: Sql>!cat/etc/redhat-release Red Hat Enterprise Linux Server release 6.5 (Santiago) Sql> select * from V$version; BANNER -------------------------------------------------------------------------------- Oracle Database 11g Enterprise Edition release 11.2.0.4.0-64bit Production Pl/sql Release 11.2.0.4.0-production CORE 11.2.0.4.0 Production T

Does the Data Guard broker change attributes to be executed separately on both sides?Data Guard Broker has some properties that can be seen through show configuration.I sometimes wonder if these attributes, respectively, belong to primary and standby, and ifIf you want to change, do you need to log in to primary and st

The following is the data Guard CPU/PSU patch installation method for a detailed analysis of the introduction, the need for friends can refer to the next Non-Data guard patch installation tutorials refer to the [Oracle] CPU/PSU patch installation detailed tutorial, where

The following is a detailed analysis of the use of Oracle switchover and failover, the need for friends under the reference The role switching between Data guard master and subordinate libraries is divided into the following two kinds:1) SwitchoverSwithchover are usually artificial and planned for role swaps, such as upgrades. It is usually lossless, that is, th

For non-Data Guard patch installation tutorials, refer to [Oracle] CPU/PSU patch installation detailed tutorial. Data Guard requires both Primary and Standby patches, so the steps are more complex, the main steps are as follows:1. Stop the log transmission service in Primary

----------- Step-by-step instructions for creating a logical standby database ----------- 1. Create a physical standby database (exsiting now) 2. Stop redo apply on the physical standby DatabaseExecuting the following statement in the sqlplus on the physical standby database:Alter database recover managed standby database cancel; 3. Prepare the primary database to support a logical standby Database3.1 prepa

RAC, Data Gurad, Stream are three tools in the Oracle High-availability system, each of which can be used independently or in conjunction with each other. Their respective emphasis is different, the application scenario is also different. RAC its strength lies in solving single point of failure and load balancing, so the RAC scheme is often used in the core system of 7*24, but the

Oracle Data Guard (RAC + DG) archive deletion policy 1. Data Guard master database archive deletion policy: When we set: RMAN> configure archivelog deletion policy to applied on standby; in Maximum Availability and Maximum Performance, when RMAN backs up the archive file and

[Oracle] Data Guard-Create physical Standby experiment environment Primary: Host: jabdw1241SID: O01DMS0DB_UNIQUE_NAME: O01DMS0Standby: Host: jabdw1242SID: O01DMS0DB_UNIQUE_NAME: O01DMS0DR 1. primary configuration and operations 1) confirm that primary is in archive mode PRIMARY> Archive log list; Database log mode archive ModeAutomatic archival EnabledArchive des

devices, Built-in excellent system compatibility, perfect compatibility with all Windows systems, support Samsung, HTC, Motorola, Sony, LG and other manufacturers of the vast majority of equipment, can restore mobile phone address Book, contact information, call records, SMS, QQ chat records, micro-mail chat records, photos, video, audio, Documents, and so on, the recovery range is very large. Here is a brief introduction to the top data recovery so

Role Switching between Data Guard master and slave databases is divided into the following two types:1) SwitchoverSwithchover is generally designed to switch roles, such as upgrading. It is usually lossless, that is, there will be no data loss.Its execution is divided into two phases:1. convert Primary to Standby2. Convert Standby (one) to Primary2) FailoverFailo

The role switching between Data guard master and subordinate libraries is divided into the following two kinds:1) SwitchoverSwithchover are usually artificial and planned for role swaps, such as upgrades. It is usually lossless, that is, there will be no loss of data. its implementation is mainly divided into two stages:1.Primary Switch to Standby2.Standby (one)

Lab environment: OEL + Oracle11.2.0.3 + physical standby As we all know, Data Guard is already the mainstream disaster tolerance solution of today's standards. Due to its strong adaptability to the network, it can adopt synchronous real-time transmission methods and asynchronous delay transmission methods, it can even become a remote disaster recovery solution. Regardless of the purpose, the DG will inevita

Lab environment: OEL + Oracle11.2.0.3 + physical standby As we all know, Data Guard is already the mainstream disaster tolerance solution of today's standards. Due to its strong adaptability to the network, it can adopt synchronous real-time transmission methods and asynchronous delay transmission methods, it can even become a remote disaster recovery solution. Regardless of the purpose, the DG will inevita

Non-Data guard patch installation tutorials refer to the [Oracle] cpu/psu patch installation tutorial, where Data Guard requires primary and standby to be patched at the same time, so the steps are more complex and the main steps are as follows: Stop log transport service a

[Oracle] role switching between Data Guard-Switchover and Failover Data Guard master/Slave databases can be divided into the following two types: 1) SwitchoverSwithchover is generally artificially scheduled for role switching, such as upgrading. It is usually lossless, that