Database Administrator

Zookeeper See: http://note.youdao.com/share? Id = 97a96387e903c407efa7323a39b81 & type = note We want to back up the AIS20130321193629 database and restore it on the test machine. 1. Right-click the database and choose task> Backup. 2.

1. It is not accidental that a flute player plays well only when he goes to the playhouse of a flute player a few days ago. It is because he has really worked hard. He has downloaded many videos and tutorials on his computer! This really shocked me!

Many people have asked similar questions on the Internet: "What does it mean when someone writes an SQL statement like where 1 = 1 ?". In fact, developers generally use dynamic array SQL statements. Let's imagine the following scenario: users

Conclusion 1: Official definition of memcache Free & open source, high-performance, distributed memory object caching system, generic in nature, but intended for use in speeding up dynamic web applications by alleviating database load. Official

For mysql using rpm in Linux, we can remove these rpm packages and delete the project directories to uninstall them. This article demonstrates how to download MySQL 5.5.37 in SUSE Linux 10. See the following for details.   1. Environment# OS

The Hadoop and HBase clusters have one NameNode and seven DataNode. 1./etc/hostname File NameNode: Node1 DataNode 1: Node2 DataNode 2:Node3 ....... DataNode 7: Node8 2./etc/hosts file NameNode: 127.0.0.1localhost#127.0.1.1node1#-------edit by HY(20

Join is to splice two tables into a large table according to a public field. The left join is used to traverse the right table based on the table on the left. 1. Introduction Left join, self join SELECT * FROM test_visit t1 left join

I. Additional topic Today, we were so sad that when we made datapatch for user data, we imported one more copy of the data each month, and we were shocked by the cold sweat... this is a product environment. If the boss knows it, it will be dead.

Note: Do not use the "create pfile from spfile;" command to create a PFILE when maintaining the RAC environment. The reason is that in the RAC environment, SPFILE is stored in shared storage by default (on bare devices or ASM disk groups ), each

The sequence starts from 0 every morning during Oracle storage. Create or replace procedure seq_resetN NUMBER (10 );Tsql VARCHAR2 (100 );BEGINExecute immediate 'select SQD_LSH.nextval from dual'INTO n;N: =-(n );Tsql: = 'alter sequence SQD_LSH

Renamedg, a tool used to rename an Oracle asm disk group TherenamedgTool enables you to change the name of a cloned disk group. The disk group must be dismounted on all nodes in the cluster before runningrenamedgOn the disk group. renamedgRenames a

Environment] AIX (5300-08), Oracle10g (10.2.0.1.0-64bit) [Goal] Due to the large data volume in the production environment, we want to speed up rman backup. [Method] Start block tracking Operation] SQL> alter database enable block changetracking

Oracle databases have many objects, such as tables, views, indexes, functions, triggers, and stored procedures. Table, the most important object in the database If the data size of a table is large, you can consider the Oracle partition table to

Problem description: This prompt appears after Mysql is installed in Ubuntu. Setting mysql-server-5.5 (5.5.27-0ubuntu2)... start: Job failed to startinvoke-rc.d: initscript mysql, Action "start" failed. dpkg: error processing mysql-server-5.5 (--

Error description: When Oracle 10 Gb is installed on CentOS 6.3, the following error occurs: "/lib/i386/libawt. so: libXp. so.6: cannot open shared object file: No such file or directory" Solution Process: Refer to: Installing libXp. so.6: cannot

1. You cannot perform Incomplete recovery operations on only a part of the database, because this gives a part of the database a different system change number (SCN) or time point from the rest of the database.2. Use the set command in the run code

Oracle's nologging attribute is very vulnerable to misuse. In our previous article, we discussed the impact of append + nologging on Redo logs. From the conclusion of this article: If we use append and nologging, we can indeed reduce the generation

Oracle redo log is used to record operation entries for database data recovery. To improve efficiency, we recommend that you set up three redo logs for oracle. This article will parse the status of the redo log group and switch between multiple

After the introduction of asmm from 10 Gb, compared with the previous manual adjustment of various memory components, this makes a huge step forward in automatic management. DBA only needs to define sga_target and sga_max_target. Other things are

Linux: CentOS 1. log on to the system as the root user, download postgresql9.3, decompress the package, and enter the decompressed postgresql directory. 2. Compile and install# Pwd#./Configure -- profix =/usr/local/pgsql(An error may occur. Install