PHP

Self-reflection series carelessness led to GG synchronization failure bear recently joined a new company, with a buddy with the same level of OCM partner DBA, because of GoldenGate operation is not very familiar, so in yesterday's operation

Mysql high-performance backup solution supports uninterrupted Data Access (LVM Snapshot Backup) www. rsyslog. orgmysqlLVM Snapshot Backup features: 1. In most cases, this method is almost considered hot backup. It does not need to close the

Today, I logged on to the ORACLE test server of the company's AIX platform without configuring a listener. Because I started the listener after manually configuring the listener, I found it was slow to start. The log is as follows: [$ (hostname ):

What do we need to know about Oracleundo? Introduction: undo is an important component of Oracle Database. Just getting started, I suggest you understand the principle and mechanism of undo, especially the difference and connection with the redo

Not all tablespaces in the company's database are unlimted, so we still need to send an email to monitor the tablespace usage from time to time. The following are some documents I have used in my work after modification. My data Not all tablespaces

OracleDBA daily work and Responsibilities 1. database environment LEO1 @ LEO1select * fromv $ version; BANNER --------------------------------------------------------------------------- OracleDBA daily work and Responsibilities 1. database

In general, DBA should focus on the SYSTEM, SYSAUX, UNDO, TEMP, and SYSTEM tablespaces in addition to the tablespace where business data is stored, the size of the UNDO and TEMP tablespace is determined by the business conditions of the database.

The premise hadoop cluster is successfully built, here is the use of Hadoop1.0.3 + HBase0.94.1 configure HBase1. modify the confhbase-env.sh, add jdk support exportJAVA_HOMEhomehadoopjdk1.6.0_392. Modify The premise hadoop cluster is successfully

Centos5.8 _ x86_64 + ASM + ORACLE11G OS Centos5.8 _ 64-bit desktop installation, disable SELINUX and firewall, 1. Memory and swap partition size, Server 2 GB or above memory can be installed, try to give Centos5.8 _ x86_64 + ASM + ORACLE11G OS

Cause 1 that triggers a ORA-01190 error first throws a ora-01190 error that uses the bbed tool to construct SQLstartupORACLEinstancestarted. TotalSystemGlobalArea322961408bytesFixedSize & nb Cause 1 that triggers a ORA-01190 error first throws a ora-

I. Configure mongodb Master/Slave using the command line [root @ server11 ~] # Usrlocalmongodbbinmongod -- bind_ip192.168.1.112-port3306 -- dbpathdatamongodb1 -.. I. Configure mongodb Master/Slave using the command line [root @ server11 ~]

SCANIP is a new feature of the ORACLE11G database. It can simplify the vip configuration of the client. during the establishment of the ORACLE11RAC Environment last year, the company did not test SCANIP due to the hasty setup. This year, due to

1. Preparations before installation 2. Installation of grid infrastructure 3. Installation of database software 4. Creation of listening 5. Creation of database instances 1. preparation before installation 1.1 determine the operating system

I) The Environment topology is currently discussed in the mysql cluster. The resources are as follows: 2) the installation and configuration of Mysql are not described here. You can select Source code compilation and installation, you can also refer

MySQL triggers are simple. Most of them are used to update third-party tables. Today I will demonstrate the functions of MySQL triggers in Data creation. The following is the base table result: CREATETABLE 'tb1 '(& n .. MySQL triggers are simple.

The company's oracle11gRAC (2-node) database uses the storage of ASM, the operating system is RHEL only has one control file, yesterday I am going to add a control file, altersystemsetcontrol_files + in sqlplus The company's oracle11gRAC (2-node)

MySQL databases have been applied to many Internet companies. mysql permission management is very important. Properly planning mysql database permissions is very beneficial to the security and use of databases. A good standard and habit to do

Today, when I reviewed the developed SQL statements, I found that a stored procedure was pieced together with a dynamic SQL (CONCAT () function), so the performance was not good for static SQL, so I asked them to change it, they reported an error

Reference: www.360doc.comcontent120403019623234_200390473.shtml using the RMANDUPLICATE command can depend on the target database (TargetDataba For more information, see Reference: You can use the RMANDUPLICATE command to create a

Recently, the test platform that took over a new project adopts the spring transaction mechanism. During User Authentication logon, the system always prompts authentication timeout. When the user checks the logs of the corresponding application