Database Administrator

Redo master-slave replication at night, and adjust my. cnf of the slave database by the way. In the morning, I forgot to restart the slave database. After I run the command and enable slave, an error is returned. Last_ SQL _Errno: 1286Last_ SQL

Oracle10g client tool plsql link Server Configuration Oracle10g client tools, such as plsql, have many problems in connecting to the server on the network, and often encounter many inexplicable problems. In fact, it is not the configuration of

A recent project requires a high-availability master-slave synchronization of mysql + keepalived, which is of course easy to configure. However, it is easy to think about how to restore data as quickly as possible after the master database is

Introduction: In recent years, all-in-one cloud servers have been surging. Many IT industry-level companies have successively launched their own all-in-one servers. As the name suggests, an all-in-one machine is a cloud server with superior

Install oracle in linux: Oracle claims that the installation of the Oracle9i database in Linux requires at least MB of memory and at least 1 GB or two times of memory swap space. For servers with a system memory larger than 2 GB, the swap space can

As an Oracle database developer or DBA, you will often encounter this problem in practice: when trying to create a unique index for a column or several columns in the database table, the system prompts the ORA-01452: you cannot create a unique index

101. DB2Which file formats support IMPORT?Includes DEL, ASC, IXF, and WSF.102. What file formats does DB2 support exporting (EXPORT?Such as DEL, IXF, and WSF.ASC format is not supported.103. What file formats does DB2 support LOAD?Such as DEL, ASC,

When you work on a very large table, you may occasionally need to run many queries to obtain a small subset of a large amount of data, instead of running these queries on the entire table, instead, MySQL can find a few required records each time,

Oracle9i Data Guard prevents Data disasters by using a database called standby database. It uploads and applies the redo logs of the primary database to the standby database to synchronize the standby database and the primary database:You can

ORACLE 8.0.X SGA = (db_block_buffers * block size) + (shared_pool_size + large_pool_size + log_buffers) + 1 MB ORACLE 8.1.X SGA = (db_block_buffers * block size) + (shared_pool_size + large_pool_size + java_pool_size + log_buffers) + 1 MB In theory,

In oracle 9i, you can easily export data as files or import data from files. The oracle management server (oms) can be easily implemented. There are many instructions to explain throughout the operation, but there are not many complete guidance

Multiple ORACLE databases physically stored in the network can be logically considered as a single large number.Database. Users can access data in remote databases through the network at the same time, whileCollaborative processing is completely

  I believe that many system administrators are doing the same job every day-backing up data. Once the system fails and data recovery is required, the system is powerless. It would be nice to set a fixed time every day for the system to

Iii. segment fragmentation When a database object is generated, a table or an index is used. The tablespace is specified by the user's default value or specified value. A segment generated in a tablespace is used to store object-related data. Before

Sybase stored procedures are pre-defined and compiled transactions centrally stored in SQL Server. Stored procedures consist of SQL statements and flow control statements. Its functions include accepting parameters, calling another process, and

The ORACLE database consists of three types of files: data files, control files, and online log files. The database administrator may consider moving database files due to disk space changes or adjustments based on database disk I/O performance. The

Field Type of Informix Field Type Description Field Length and default value Char (size) It is used to save string data of a fixed length (size) byte. Fill in space for less than the fixed length of each line). The

When OnLine users complain that their processes are suspended or cannot interact with OnLine users, run onstat-a to obtain essential information about the problem. Onstat is a utility provided by OnLine and is used to monitor system commands. It

The first part is to build a multi-mysql service on a server. I. xuyanThere is a mysqld_multi command in Mysql that can be used to run multiple Mysql services on one physical server. I am so glad to refer to some documents and test it and pass it in

Oracle exp/imp are two tools frequently used by many users. they are often used for database logical backup, database restructuring, data transfer, and other work. first, exp unload the data to the file system to generate. dmp file, and then the