OracleDatabase12c deploys DataGuard (ADG, LDG) and implements the Switch

Source: Internet
Author: User
Directory 1. order 42. prepare the experiment environment 42.1 view OS and DB version information 42.2Primary and Standby in hosts add Master/Slave database information 42.3Primary and Standby environment variable 42.4 construct test data 53 in Primary. set up ActiveDataGuard73.1Primary to enable FORCELOGGING73.2 add standbylogfile73.3 to make Prima

Directory 1. order 4 2. prepare the experiment environment 4 2.1 view OS and DB version information 4 2.2Primary and Standby hosts add Master/Slave database information 4 2.3Primary and Standby environment variables 4 2.4 construct test data in Primary 5. set up Active Data Guard7 3.1Primary to enable FORCE LOGGING7 3.2 add standby logfile7 3.3 to Prima

Directory
1. Order 4
2. Prepare the experiment environment 4
2.1 view OS and DB version information 4
2.2 add Master/Slave database information in hosts of Primary and Standby 4
2.3 environment variables 4 for Primary and Standby
2.4 construct test data in Primary 5
3. Set up Active Data Guard 7
3.1 force logging 7 enabled for Primary
3.2 add standby logfile 7
3.3 run Primary in archive Mode 8
3.4 Primary network configuration 8
3.5 configure Standby 10
3.5.1 create the initialization parameters and password file 10
3.5.2 create necessary directories 10
3.5.3 configure Standby network 10
3.5.4 start listening 11
3.5.5 Standby instance starts to NOMOUNT status 11
3.5.6 test connection at Primary 12
3.6 write scripts and execute 12
3.6.1 compile the rman duplicate Command Script 12
3.6.2 unlock sysbackup user 12
3.6.3 copy the password file to Standby 14 again
3.6.4 run the script 14
3.7 Primary modify parameter 23
3.8 view status information of the Master/Slave database 23
4. Configure Broker 24
4.1 enable the Broker function and use 24
4.1.1 enable the Broker function 24
4.1.2 Standby database boot to Read Only 24
4.1.3 open the PDB database in the Master/Slave database 24
4.1.4 use Broker to create Master/Slave database 24
4.1.5 view Master/Slave database details 25
4.1.6 real-time ADG application testing 28
4.2 Data Guard protection mode 29
4.3 SWITCHOVER 30
4.3.1 perform switchover 30
4.3.2 confirm after Switchover 30
4.3.3 Test 31
4.4 Failover 32
4.4.1 configure and start FSFO (FastStartFailover) 32
4.4.2 enable the flashback db function 33
4.4.3 enable FSFO 33
4.4.4 performing failover 35
5. Logical standby database 37
5.1 build a logical standby database 37
5.1.1 confirmation does not support object 37
5.1.2 stop the log application of the standby database 37
5.1.3 construct a LogMiner dictionary 37
5.1.4 notify MRP application redo log 37
5.1.5 backup database restart, RESETLOGS open 38
5.1.6 start SQL Apply 38
5.1.7 data test 38
5.2 reconfigure Broker 39
5.2.1 switch to the highest-performance mode and delete slave database information 39
5.2.2 logically add a standby database again 39
5.2.3 activation configuration 40
5.3 test Switchover 40

Download: click here

Original article address: deploy Data Guard (ADG and LDG) in Oracle Database 12c and implement the Switch. Thank you for sharing with me.

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.