The first time Oracle 11g R2 Active Data guard is configured today, after physical standby database is created with rman,The following error occurs when you try to open standby in read only mode:
SQL> alter database open read only;Alter database open read only*Error at line 1:ORA-10458: standby database requires recoveryORA-01152: File 1 was not restored from a s
[Oracle] Data Guard series (1)-three Protection modes Data Guard provides the following three Data Protection modes: 1) Maximum Protection) the "maximum protection" here refers to protecting d
Data Guard provides two services:1) Redo transmission service: Transfers Redo logs of Primay to one or more Standby destinations.2) Redo Application Service: The Redo log transmitted from Primay on the Standby side.This article describes the Redo transmission service.
1. Use ARCn to transmit Redo logsBy default, ARCn is used to transmit redo logs. However, ARCn can be used only in the highest-performance mo
The FAL gap problem of Oracle Data Guard logs is found in the OracleData Guard environment. A standby database has a problem and needs to be redone. Because the previously configured environment is good, you only need to back up the full database of the master database to the slave database. However, after the
Data Guard offers two main services:1 Redo Transport Service: The Primay end of the redo log transmission to one or more standby destinations.2 Redo Application Service: The redo log which is transmitted from the Primay end is applied to the standby end.This article first discusses the redo transport services.
1, the use of ARCN transmission redo logBy default, the ARCN transport redo log, but only in the
In the previous section, "Data Guard series (2)-Log Transfer", we introduced the DG Log Transport service, the log Application service is introduced in this section after the log is transferred from the main library to the standby repository, and the repository needs to apply logs to maintain synchronization with the main library.
Redo application or SQL application?
We know that there are two types of re
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
The data guard provides the following three kinds of protection modes:
1 Maximum protection mode (Maximum Protection)
"Maximum protection" here refers to the maximum protection of the data is not lost, that is, at least one standby and primary maintain real-time synchronization, but this is costly, that is, when a transaction is committed, not only to write to
Oracle Data Guard (iii) Switchover 1. check the status of the Primary database SQL> select switchover_status from v $ database; Role Switching can be performed only when the status is "TO STANDBY" or "SESSIONS ACTIVE. 2. switch the role SQL of the Primary database> alter database commit to switchover to physical standby with session shutdown; SQL> shutdown immedi
[Oracle] Data Guard series (6)-role conversionThe core function of DG is to provide high-availability Disaster Tolerance. Therefore, the role conversion content described in this section is the most important part of DG. Role Switching between master and slave databases of DG is divided into the following two types: 1) SwitchoverSwithchover refers to role switchi
Oracle 11g Data Guard Broker operation notes
I. Settings
1. Set broker
2. operate on the master database
DGMGRL> help
DGMGRL> help create
DGMGRL> create configuration c1 as primary database is PROD1 connect identifier is PROD1;
DGMGRL> help add
DGMGRL> add database dg as connect identifier is dg;
DGMGRL> help enable
DGMGRL> enable configuration;
DGMGRL> help show
[Oracle] Data Guard series (3)-log application Redo application or SQL application? We know that there are two types of standby databases: Physical standby database and logical standby database. The log application of the physical standby database is called the Redo application, the log application of the logical standby database is called the SQL application. Th
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
The data guard provides the following three kinds of protection modes:
1 Maximum protection mode (Maximum Protection)
"Maximum protection" here means that the maximum protection data is not lost, that is, at least one standby and primary maintain real-time synchronization, but this is costly, because as long as a transaction is committed, not only to write to t
Oracle Data Guard (iv) Failover 1. check for missing logs in the Standby database. Run the following command to check for missing logs: SQL> select thread #, log_sequence #, high_sequence # from v $ archive_gap; copy the missing log file from the primary database to the log directory specified by the standby database, and run the following command to register it
To delete an archive file of the master database in the Maximum Availability and Maximum Performance modes of Oracle Data Guard, the archive file must be deleted after the backup database is applied.
For Maximum Protection mode, logs in this mode are written to the master database and the slave database at the same time. Therefore, in this mode, there is no l
` string, `last_modified` timestamp, `created` timestamp, `header_start` bigint, `header_end` bigint, `modified` timestamp);3. Create a MapThe Oracle and hive models have been created before and are directly used to create the mappings. As shown in the following:Integration Type Setting Properties:Connection Settings Properties:Filter Settings Properties:Lkm Setting Properties:IKM Setting Properties:If you set the value of truncate to true,
$rootORCL 1 Cdb$rootSys$background 1 Cdb$rootSys$users 1 Cdb$root(Note: read-only pdb$seed not listed here)(2) in the PDB sessionSql> alter session set CONTAINER=PDBORCL;Session altered.Sql> select name,con_id,pdb from V$services;NAME con_id PDB----------------------------------- ---------- ------------------------------PDBORCL 3 PDBORCL5. How to connect directly to a PDB instead of ' alter session set container '?[Email protected] ~]$ sqlplus Pdb1_u1/[email protected]Sql*plus:release 12.1.0.1.0
Oracle 12c has been released for a long time, has been trying to find a way to learn a bit, after all, the subsequent 12c will gradually replace the existing database version, become the mainstream database version. Now 12c some of the most commonly usedCharacteristics for everyone to study together.1. Online renaming
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.