In Windows, configure Oracle 11gR2 Data Guard. I used to configure Data Guard when I was never in contact with Oracle. Paid download a detailed configuration document for data
single-instance databases or multi-instance RAC databases.6. Each Master/Slave database must have its own control file.7. If you place the Master/Slave database in a system, you must adjust the initialization parameters.8. As long as Data Guard is used, the master database must be in force logging mode. If no logging is used on the master database, logs are not generated, and the
Configuring the Oracle 11g Data Guard (logical standby) Oracle Data Guard logical standby database based on the same host uses a backup of the master database to first create a physical standby database, then convert it to a logic
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 adds delete input, the archive will be deleted.
RMAN> configure archivelog deletion policy to none;
The archive deletion policy is canceled.
2. Data
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.
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
I configured data guard when I had never been familiar with Oracle before. Paid download a detailed configuration document for data guard 11g in Windows (requires a mailbox), but many of the parameters must be modified according to their own environment, this is quite diffic
ORACLE 11G Data Guard role conversion, 11 gguard1. ORACLE login uard Role SwitchingDataGuard is now the mainstream disaster tolerance solution. Due to its strong adaptability to the network, it can adopt synchronous real-time transmission mode and asynchronous delay transmission mode, it can even become a remote disast
switch to the primary role. Otherwise, confirm that the Redo app is started until the query results show to primary or sessions ACTIVE.
7. Switch the physical standby to the primary role
Execute the following SQL on the target physical standby:
Sql> ALTER DATABASE COMMIT to switchover to PRIMARY with SESSION SHUTDOWN;
Note: If the query results in step 1th are to PRIMARY, the WITH SESSION shutdown clause in the SQL statement can be omitted.
in a separately installed BIEE client(For the Admin Tool installed with the new standalone installer)1. Copy Tnsnames.ora from Oracle server to any directory, such as E:\network\admin2, add the following line in %obiee_client_home% \oraclebi\orahome\bifoundation\server\bin\bi_init.bat , specify the path of the Tnsnames.oraFor example:C:\Software\Oracle business Intelligence Enterprise Edition Plus Client t
The concept of change sets is introduced in conformance CDC. A change set can include several tables that have relationships with each other, such as a primary foreign key reference relationship. The CDC can guarantee data consistency when capturing and releasing changes in a change set. This exercise describes how to use a CDC that guarantees consistency.1 Environment PreparationSOURCE table: Odi_src. Dept,odi_src. Emp Target table: Odi_tag. DEPT, Od
Oracle Data Guard Create a physical standby database
Create a physical repository
Machine name A1 A2
ip:192.168.1.10 192.168.1.20
Net_name A1 A2
SID A1 A2
Db_unique_name A1 A2
Note: Create the database A1 on the master node, install only Oracle software on the standby node and do not create any databases;
1. Co
Label:Oracle Data Integrator 12c installation (ODI installation)Enterprise Edition installation steps (including standalone installation steps)Download Oracle Data Integrator 12CR2 (12.2.1.0.0) address on official website For example, when installing ODI, there are two options, the first is a standalone installation, j
:
Sql> SELECT switchover_status from V$database;
As long as the Switchover_status query result is to standby or sessions ACTIVE, the switchover between the primary and the logical repositories is indicated. Otherwise, see if the data Guard is configured correctly, such as if all the Log_archive_dest_n parameters are configured correctly.
2. Preparing to switch to the c
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
Non-Data guard patch installation tutorials refer to the [Oracle] CPU/PSU patch installation detailed 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:
1. Stop log transfer
Cross-platform database migration using Oracle Data Guard
The customer was originally a single-host Oracle 11.2.0.3.0 Database for Windows Database system. The customer's requirement is to migrate the single-host Oracle Database to the three-node
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
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
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.