Database Administrator

Percona Xtrabackup for database backup and disaster recovery Directory1. Tool Introduction2. Tool Installation3. Backup policies and prepare test data4. Full backup of data5. Incremental Backup Data6. Disaster Recovery7. Summary 1. Tool

Getting started with Linux: Create a MySQL database using the command line Q: On a MySQL server running somewhere, how can I create and install a MySQL database through the command line? To create a MySQL database through the command line, you can

Enable Oracle NUMA support in Oracle 11gR2 Enable Oracle NUMA support in Oracle db 11gR2 Reference Original:Enable Oracle NUMA support with Oracle Server Version 11gR2 (Document ID 864633.1)Applicable:Oracle Database-Enterprise Edition-Version 11.2.0

The ORA-00600 kcratr_nab_less_than_odr Solution Today, due to abnormal power outages at the customer site, Oracle database cannot be started again. Let's go up remotely. 1. The database can only be mounted and cannot be started. SQL> select status

Tablespaces have two management modes: data dictionary and local hosting. If the data dictionary is used for maintenance, operations that occur on the database segment and are related to disk partition allocation (such as extending a table) will

Data room charging system login BUG, charging system bugDisclaimer: the following content only applies to those who cannot log on multiple times with a single user name at the time of Logon!It is a BUG. In fact, this is not a BUG. Just come up with

Like fuzzy query for oracle, mysql, db2, and SQL server in Mybatis, mybatisdb2 select * from t_user where user_name like CONCAT ('%', # {search_name}, '%') select * from t_user where user_name like '%' | # {search_name} | '%' select * from t_

Oracle's restored tablespace UNDO is full of disk space. The specific steps to solve this problem are oracleundo.Zookeeper There are two main causes:1. There is a large volume of transactions that allow Oracle Undo to automatically expand, resulting

How to permanently delete an Oracle database to create a database with the same instance name and an oracle instance I chose the OMF method when creating the database today. The result file name is automatically named in Oracle. I cannot understand

Full explanation of Oracle 10g RAC Installation Directory1. ORACLE Database RAC description... 1-21.1RAC system description... 1-21.2 preparations before installation... 1-21.2.1 hardware preparations... 1-21.2.2 quasi-work on software... 1-22.

By using database backup, DBA can create a copy database on the same server or other servers. This replica database can have the same name (copy) or different (clone) from the primary database ). The only difference between Oracle Database copy and

Classification of Data Center reconstruction systems and data center reconstruction Systems During this time, I was truly on the machine room. After constantly overcoming the feeling that I was not satisfied with the VB. NET language, I finally had

After introducing the transaction concept in SQL Server, we can continue to introduce this article. We can include the entire package in SSIS in a transaction. But what if a table needs to be locked during package execution? The built-in transaction

ORA-12520 error solved one, ORA-12520 error solved Problem description: An error was reported when I suddenly found a connection to the database today. When I use pl/SQL dev to connect to data, sometimes I can connect to the database. Sometimes I

[MongoDB] mongodb sharded cluster (iii) on windows platform, mongodb Cluster In the previous two blogs, we elaborated on the working principle and building process of the sharded cluster. In this blog, we will analyze the testing results of the

How to configure SQL Server for remote backup? The following describes the configuration method: (ASE version 12.0 or later) On the local machine: 1. modify the interfaces file and add the Backup Server entry (Backup Server name, address, and port

ORA-12545 Errors often occur when a remote client connects to the RAC database over a uniform service name. SQL> CONN NDMAIN @ nuagerac enter the password ***** connected.SQL> CONN NDMAIN @ nuagerac :******ERROR: ORA-12545: connection

BKJIA featured translations] in the previous articles, BKJIA briefly described several new features of Oracle 11g R2, referring to the Oracle 11g topic ). Finally, let's make a summary to introduce some of the new features in Oracle 11g R2, which

We need to pay attention to the execution of search and so on during MySQL SQL statement execution. BKJIA recommends the MySQL database getting started and proficient tutorial. Case sensitivity when executing the SEARCH Command By default, MySQL

BKJIA Summary: in the previous article, we have read several major factors in DB2 performance optimization. This time, let's take a look at DB2 performance issues and see how these problems are classified, what is an analysis idea. DML performance