Database Administrator

At the end of this article, I found a fatal problem with ZRM for MySQL. As far as I understand and test it, it overwrites data recovery, for example, assume that a database server has two databases test1 and test2. You have backed up these two

Run Oracle database EM, isqlplus, and other commands in Linux. $ ORACLE_HOME/bin/emctl start dbconsole $ ORACLE_HOME/bin/isqlplusctl start Common emctl command syntax: Emctl start dbconsole to start the EM console service. You need to set the

Today on the server df next, a look, var directory has been 98%, clear some log files and backup files found that mysql below a lot of files similar to mysql-bin.000001, if Google says it's a log, it's useless. Database operation logs Mysql-bin.000

When installing Fedora, select all the components to be selected, including Appache, mysql, and php. But when we manage the database, it is easier to have a graphical interface, so we have installed phpMyAdmin on our own and it is easy to

MySQL creates a user and sets the access control permission Syntax: Grant all privileges on *. * TO 'username' @ '%' identified by 'Password' with grant option; Note: 1. "*. *" sets the user's control over databases and tables. For example, if

After a long time in Ubuntu, I finally succeeded in operating MySQL in C. Here I will write down the method and save it for later use. Install MySQL firstCode:Sudo apt-get install mysql-server mysql-client Reinstall the Development KitCode:Sudo

In the development environment and UAT environment, you often encounter the need to clear archived logs. There are many ways to solve this problem. You can use rm to clear archived logs directly, or use the find command to find matching records to

# Restoring mysql backups in Windows. You do not need to modify my. ini to restore the view (verified)Mysqldump-uroot-p123 -- default-character-set = gbk -- opt -- extended-insert = false -- triggers-R -- hex-blob-x db_name> f: \ db.

(I) INSERT large data volume (1) Replace a single row with multi-row insert: insert into t values (),(),(),... (2) load data infile... into table t (3) Write a temporary table and INSERT... SELECT (4) cancel the index and constraints, and

I have recently studied how to solve the IO competition problem if the storage level cannot be optimized. Finally, I thought of asynchronous IO. My redo disk write speed has reached the maximum value, no matter how I adjust the redo size and number

Today I saw a little questions about ocp, I did a small experiment, encountered two errors of ORA-02097 and ORA-00837; Question: Q484. You set the following parameters in the parameter fileand restarted the database: MEMORY_MAX_TARGET =

First, find the Net Configuration Assistant menu of the client, as shown in:     2. Click to enter the welcome page and select the local net service name configuration, as shown in:     3. Add by default, as shown in:     Configure

Installing Oralce on Linux is cumbersome. The preparations before installation are as follows: Read more: Install Oracle 10g R2 in CentOS 6.3 (x32) 1. Check whether the rpm software package has been installed. Binutils-2.17.50.0.6-6.el5Compat-db-4.2.

Compared with physical Standby, logical Standby management is a little more complicated. This is the difference between one half database management and two databases (assuming that the Data Guard environment is one master and one slave). After all,

Split Block: During Hot Backup (that is, when the OS command copies the cp, the OS cp unit is not the data block but the OS block), the data Block is being modified by the user, that is, an Oracle Block contains multiple OS blocks. An OS-Level copy

A developer said that there was a problem when using postgres's extended row-to-column application. The example is as follows: For more information about the extension package, see: I. EnvironmentOS: CentOS 6.3DB: PostgreSQL 9.3.0 Ii.

I have heard about Oracle control files and snapshot control files? Yes, although snapshot control files are rarely mentioned, they do exist, but the snapshot control file is used when RMAN is used. Looking back at the Oracle control file, we know

Configure the database environment, goldengate users, and install goldengate. For details, refer to the configuration required to complete two-way Oracle-Oracle replication without using the Data Pump: -- Here I only configure to synchronize the

These three table join methods are the most basic connection methods for Oracle:Principle of nested loop joinPrinciple of sortmerge join Hashjoin) Number of visits: both the driver table and the driver table can only be accessed 0 times or

In the case of network transformation, You need to modify the name or IP address of the database server. This will affect the normal operation of the Oracle database, because the listener and many database tools need the correct machine name or IP