1. Copy principle official reference document: http://dev.mysql.com/doc/refman/5.6/en/replication.html blog address 1:http://prog3.com/sbdm/blog/mchdba/article/details/11354771 blog address 2:http://prog3.com/sbdm/blog/mchdba/article/details/8717513 as below 1.png are shown:...
1, create a MySQL backup user MySQL -uroot --password= "- e" "create user'backup'@'192.168.%'IDENTIFIED by' 123456 '"; MySQL -uroot --password= "and" - e "grant reload, lock tables and replication client and create tablespace, supe...
1, xtrabackup on the database backup and backup tool reference: http://blog.itpub.net/26230597/viewspace-1460065/, here to introduce xtrabackup has been how to use xtrabackup full backup of the database has been restored. 2, xtrabackup download address: http://www.percona.com/downloads/XtraBackup/Chorm browser...
1, database backup types according to the size of the database backup, four types, respectively applied in different occasions, the following brief: 1.1 full backup which is most commonly used way, it can back up the entire database, containing the user tables, system tables, indexes, views, stored procedures, and so on all database objects. But it takes more time and space, so it is generally recommended to do a full backup once a week. 1.2 transaction log backup of the transaction log is a separate file, it records database, backup only need to copy has changed since last backup of database, we only need to...
Sqlserver2000 connected Oracle11g database data real-time synchronization 1, premise condition already have SQL Server 2000 environment, already exists Oracle11g environment, the preparation of the two databases, to establish their own access account. Between the two need to Ping Tong, telnet port also can pass, the purpose is the SQL server data automatically synchronized to the Oracle Database to. Sqlserver inside the link server (server linked) can be achieved. 2, in sq...
1, the MySQL architecture is composed of the database and the database instance, which is single approach and multi thread architecture. Collection of database: the physical operating system files or other documents, in mysql, database files can be of frm, MyD, MYI, IBD and at the end of the file, when using the NDB storage engine, not the OS file is stored in the file memory. Database instance: by the database background process / thread and a shared memory area, shared memory can be run by the background process / thread sharing. 2, MySQL file type Mysql main file types are as follows...
Preface: Chinese entry failed. Error: are the string will be'\xCC\xEC\xB2\xC5'as follows: mysql> set names utf8; query OK. 0 rows affected (0.00 sec) mysql> insert into t select 2 as a and B' genius' as; error 1366 (hy000the): are strin...
Finished Oracle 11g DataGuard structures, also made the role switching experiments, switchover failover, feel benefit a lot, and then continue to the DataGuard senior management functions, called the tip of the iceberg, Oracle really profound, summary records are as follows: 1. Senior management in Oracle 11g DataGuard 1.1, read ONLY/WRITE mode open physical standby standby is set to mount.
Failover problem scenario: because a failover test, a standby has been I become the primary database, how will the new primary database (the original standby) back again become a standby two is primary, P1, P2, and how to set a primary library 1 P1, and also a primary library P2 set P1 standby database? 1, the problem describes the original primary Library: select open_m SQL>...
1, Oracle Dataguard role switching of DataGuard is today's standard mainstream disaster recovery plan, because the log transfer for network adaptation degree of strong, and can use synchronous real-time transmission delay mode and asynchronous transmission mode, and can even become remote remote disaster recovery plan. No matter for what purpose, DG will inevitably to carry out the role of conversion is standby switch the database for the primary database, role conversion is divided into: switchover and failover two 2, the similarities and differences between the two ways 1), switcho...
Preface: DataGuard is through the establishment of a primary and standby group to establish the reference relation; standby once created, DataGuard will be the primary database (primary) of the redo pass to the standby database and in the standby application of redo database to achieve the same step. Two types of standby: physical standby and logical standby physical standby to provide exactly the same with the database master copy of a block.
Ready to install Oracle database, reference: http://prog3.com/sbdm/blog/mchdba/article/details/430860371, solution (1) and ignore system prereqs[root@powerlong5 database]# export DISPLAY=192.168.121.218:1.0[root@powerlong5 database]# xhsot +-bash: xhsot:...
Scene: a dev told me production environment under a user table can not see the, need to recover, but this time production database storage automatic backup parameter file control file disk file directory for bad blocks, thus resulting in the RMAN backup only data files and archived redo log file, in this case, how the test server using RMAN recovery data? Google a lot of information, consulting a friend, the recovery process is as follows: pre preparation work: in advance of the query to check the original data file path select name from v$datafile SQL>;...
Scene: has a production base of users all of the following table are gone, doubt were artificially removed, now need to use the backup to restore, to find out the original table, the line is Oracle DataGuard environment, a full database backup file, ready to test library restore a. 1, from the production and copy the backup file to restore the database to prepare the file: RMAN complete backup (including data files, log files, and control files parameter file), dbid record source database installation test database of Oracle database software and create with the source database...
Preface: see the alert log and found a lot of error message: [oracle@localhost trace]$more alert Alert_powerdes.log*********************************************************************************************************************************...
Standby down, so a restart misstatement, ORA-16032: parameter log archive dest 3 destination string cannot be translated:. 1. Restart error message SQL > startup...
1, State Description: SQL > select the message from V$DATAGUARD_STATUS status; me...
Need to install DataGuard Oracle, so the first to install a single Oracle11g, the following is a single Oracle11g detailed installation process. 1, the installation of hardware environment: 2 sets of Linux virtual machine, Centos6.4, 4G, 4 nuclear, disk 50GOracle software version: Linux.x64_11gR2_database_1of2.ziplinux.x64_11gR2_database_2of2.zip 11gr2 database Linux.x64_11gR2_database_1of2.ziplinux.x64_11gR2_database_2of2.zip 11gr2 database Linux.x64_11gR2_database_1of2.ziplinux.x64_11gR2_database_2of2.zip download address: http://pan....
Usually the server machine comes with limited disk space, need additional disk loaded, can be used to mount the remote shared memory disk loading in, iSCSI, NTFS, NFS, three types a currently used, Mount mount iSCSI type 1 and find next to mount the magnetic disk or memory [root@localhost /]# iscsiadm low-m discovery - ST - 1x.xx.0.22:32601x.xx.0.22:3260,1 iqn.20...
Objective: under the Linux Oracle installation, need to start Java Swing interface, so it is necessary to window X-window, then you need to go directly to the server room to field operations very troublesome, unable to windows remote xshell, this case can be connected Linux windows to remotely install Oracle using VNC remote mode. 1, first check whether the server has been installed VNC service, no installation, check whether the server is installed VNC the following commands are as follows: rpms] [root@powerlong5...