Database Administrator

The installation of the MySQL-Proxy binary version is relatively simple, and does not need to be repeated. The following describes how to install the source code for Linux: Install pkg-config: Tar zxvf pkg-config-0.23.tar.gz Cd

The database file storage location in the default configuration of MySQL installed in Ubuntu is/var/lib/mysql. If you have not mounted/var to a large enough partition, then/var will share the available space with the root directory/in the same

Write the corresponding backup script rmanbklevel_0.sh rmanbklevel_1.sh rmanbklevel_2.sh[Oracle @ oracle11gR2 scripts] $ pwd/U01/scripts[Oracle @ oracle11gR2 scripts] $ llTotal 44-Rw-r --. 1 oracle oinstall 102 Jul 20 audit. SQL-Rwxr-xr-x. 1 oracle

Oracle 11G R2 RAC modify archive Mode The non-archive mode is used by default after the database is created. You need to modify it. Recommended reading: Oracle 11g rac ocr and db_unique_name Configuration Reconfigure and uninstall Oracle 11GR2 Grid

1. Data Guard master database archive deletion policy: When we set: RMAN> configure archivelog deletion policy to applied on standby; In Maximum Availability and Maximum Performance, when RMAN backs up the archive file and adds delete input, the

MySQL is the first choice for MySQL redundancy solutions for lightweight databases. The following is the configuration process of MySQL's asynchronous master-slave replication. First configure the system yum. Here we will introduce the installation

In Oracle 11 g2, duplicating a database has two methods: 1. Active database duplication2. Backup-based duplication The advantages of using duplicate for a database are:Test backup and recovery proceduresTest an upgrade to a new release of Oracle

Server: CentOS 6.0Required packages: Installation in order64-bit http://www.nomachine.com/download-package.php? Prod_Id = 1, 3596① Nxclient-3.5.0-7.x86_64.rpm② Nxnode-3.5.0-7.x86_64.rpm③ Nxserver-3.5.0-9.x86_64.rpmClient: Windows 7Package: nxclient-3

Oracle queries the usage of temporary tablespace: Select d. TABLESPACE_NAME, SPACE "SUM_SPACE (M)", BLOCKS SUM_BLOCKS, USED_SPACE "USED_SPACE (M)", ROUND (NVL (USED_SPACE, 0)/SPACE * 100,2) "USED_RATE (% )", NVL (FREE_SPACE, 0) "FREE_SPACE (M

Today, a test database is down. After the Oracle database is restarted, the listener cannot be started. The lsnrctl start or lsnrctl status Command is stuck in this step: Lsnrctl status LSNRCTL for Linux: Version 10.2.0.5.0-Production on 09-APR-2013

During the test today, I want to query the tablespace information corresponding to the data file. In the desc dba_Data_files view, I found that this object does not exist. At that time, I thought it was normal that my DB could not be queried under

This article was further revised based on section 11.4.2 "Building the most available Oracle Database System: Oracle 11gR2 RAC management, maintenance and performance optimization", and thanked Lao tan for his reminder and help. Supplemental Log is

When Data guard is used as the HA solution, one problem to be solved is that the master-slave switchover occurs in the background database. How can the client connection be automatically switched to the new primary database? For general solutions,

I. Tutorial purpose: Mysql also supports semi-synchronous replication in master-slave replication. mysql replication is asynchronous because of poor synchronization performance. After the master database distributes events, you must wait until the

1. Oracle cluster architecture1. Oracle RAC is the Real Application Cluster of Oracle. It is a parallel Cluster system provided by Oracle. The entire Cluster system is composed of Oracle Cluster (Cluster ready software) and Real Application Clusters

Before Oracle 11g, adding a column to a large table and setting the default value would be a tragedy. sometimes you have to select the online redefinition function to achieve this requirement. adding new columns and setting the default values in 11

This is a small example of sqlldr in the exercise thinking book. It is to save the excel file as csv and load it into the Oracle database through sqlldr. The purpose was to demonstrate the processing method of sqlldr In the csv file and strings in

UDEV ASMDisk ConfigurationBecause Oracle does not support the RHEL6 series ASMLib, we can change it to Udev to configure ASMDisk as follows: Use udev to configure the block device information stored in ASM. 1. confirm that the udev package is

1. Control Structure of PL/SQL, including selection structure, loop structure and jump Structure Rlwrap SQLPLUS spool to dynamic Log File Name Oracle SQLPLUS prompt settings Accelerate SQL return by setting SQLPLUS ARRAYSIZE (row prefetch) 1. Select

In the actual O & M environment, operating system OS maintenance is required. The application system is a whole, not only the application itself and the database server running on the application server, but also the operating system, network,