Read about oracle data guard synchronous replication, The latest news, videos, and discussion topics about oracle data guard synchronous replication from alibabacloud.com
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
Data Guard provides the following three Data protection modes:
Data Guard provides the following three Data protection modes:
1) Maximum Protection)The "maximum protection" here refers to protecting
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
Data Guard provides the following three kinds of protection mode, the following is a detailed analysis of the three protection modes, the need for friends can refer to the next
The data guard provides the following three kinds of protection modes:
1 Maximum protection mode (Maximum Protection)"Maximum protection" her
After the DG is set up, it is found that the repository does not accept logs from the main library.Executing in the main librarySelect dest_id,status,error from V$archive_dest where dest_id=3;Report: Ora-16057:dgid from server not in Data Guard configurationThe meaning of the error is obvious, Log_archive_config is not configuredBut I've configured it in the main library.alter system set Log_archive_config
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
Data Guard provides the following three Data protection modes:
1) Maximum Protection)The "maximum protection" here refers to protecting data from loss to the maximum extent, that is, at least one standby and primary are synchronized in real time, but this is costly, that is, when a transaction is committed, it should n
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)
Before you can create a logical repository, you must first create a physical repository, and for how to create a physical library, refer to the Data Guard series (4)-Creating a physical repository without stopping the main library.
1. Stop the Log Application service on the physical repository
sys@jkka> ALTER database RECOVER MANAGED STANDBY database CANCEL;
Database altered.
2. Reset the main
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 th
a dictionary in the redo dataTo build dictionary in the redo data, you must enable the logminer at first.Issuing the following statement when the primary database is in the open state:04:59:50 SQL> alter database add Supplemental log data;If you do not run the command above to enable the logminer, the alter database recover to logical standby cuuo will never end up even if you run;Execute dbms_logstdby.bui
/standby/system01.dbf
/data/oradata/standby/undotbs01.dbf
/data/oradata/standby/sysaux01.dbf
/data/oradata/standby/users01.dbf
/data/oradata/standby/test01.dbf
Sql> Show Parameter Standby_file
NAME TYPE VALUE
------------------------------- ----------- ------------------------------
Standby_file_management stri
set to MANUAL or AUTO:
Drop the tablespace from the primary database:1. delete a tablespace from the master databaseSQL> drop tablespace tbs_4; SQL> ALTER SYSTEM SWITCH LOGFILE;
Make sure that Redo Apply is running (so that the change is applied to the standby database). If the following query returns the MRP or MRP0 process, Redo Apply is running.Make sure that the redo application is running, so that the slave database will apply these changes. If the MRP or MRP0 process returned by the f
When the application redo log is started, the redo log is canceled when the application is disabled:8.1 Starting Up and Shutting Down a Physical Standby Database
This section describes the SQL * Plus statements used to start up and shut down a physical standby database.8.1.1Starting Up a Physical Standby Database8.1.1 start the Physical Standby Database
To start a physical standby database, use SQL * Plus to connect to the database with administrator privileges, and then use either the SQL * Plu
database to another or multiple physical sites to maintain consistency between the source database and the specified data in the target database.
Based on the Real-time Data replication, data replication can be divided into synchronous
Oracle cross-database query replication table data distributed query, oracle
Method 1:
Currently, most databases require distributed queries. The following describes how to configure cross-database access in oracle.
For example, there are two database servers and two databas
Oracle cross-database query replication table data distributed query introduction, oracle
Method 1:
Currently, most databases require distributed queries. The following describes how to configure cross-database access in oracle.For example, there are two database servers and two databases are installed. Database server
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.