Database Administrator

The customer said earlier that it deleted the newly added data file USERS02.DBF and USERS03.DBF in table space USERS by mistake. No valid backup is found for both files during restoration. Ask if the data can be recovered. 1. Simulation

Load Balance is one of the most important features of Oracle RAC. It distributes the Load evenly to each node in the cluster to improve the overall throughput of the system. Generally, there are two methods to achieve load balancing. One is Load

Today, I had to write this article for a long time because of a very strange problem. Select * from wlbtest3 Where (sname, sage) not in (select user_name, user_age from wlbtest4) Select * from wlbtest3 Where (sname | sage) not in (select

There are many methods to migrate the database, and RMAN is commonly used for migration. Using RMAN to migrate a database belongs to the physical backup and recovery scope of the database. The database information is a complete image throughout the

Block change tracking is a function provided from Oracle 10 Gb. It is disabled by default in the system.When this feature is enabled, the relevant information is recorded in the file whenever the data block changes.In this way, when RMAN performs

MySQL triggers are simple. Most of them are used to update third-party tables. Today I will demonstrate the functions of MySQL triggers in Data creation. The result of the base table is as follows: CREATETABLE 'tb1 '( 'Id'varchar (255) NOTNULL, '

When installing 10g rac on linux 5, you will often encounter the error "libpthread. so.0: cannot open shared object file", which is caused by the failure of vipca. There are two solutions to this error:Method 1Ignore this problem. Select continue,

I'm afraid InnoDB is the most familiar with the MySQL storage engine. The performance of InnoDB is not bad, especially for Internet applications. However, InnoDB cannot be called Perfect, especially the performance of a single-instance MySQL is not

1. Download MySQL:Version I downloaded: mysql-5.5.22.tar.gz 2. uninstall MySQL that comes with CentOS before installation[Root @ localhost ~] # Yum remove mysql 3. Compile and install CmakeDownload cmake source package: http://www.cmake.org/files/v2.

If you use nagios to monitor mysql master and slave databases, you need to install the nrpe software package and the nagios software package on the monitoring host. The installation steps are not described. On the monitoring host: First, define the

Oracle table management-naming rules for table names and columns Must start with a letterLength cannot exceed 30 charactersOracle reserved words cannot be usedOnly the following characters can be used for A-Z, a-z, 0-9, # $, etc.=====================

Oracle user management========================================================== ============================Create a user whose username is bkjia and password is 88181Creat user bkjia identified by 88181 Change User Password:SQL> password

DDL commands require the internal structure of the exclusive lock. If these locks are not available, a "ORA-00054: resource busy" will be returned, which can be particularly frustrating when attempting to modify frequently accessed objects, to solve

1) In the/etc/oratab file, the file is generated by the root. sh Command executed last when the database is installed. Pwdb:/Oracle/procduct/10.2/db_1/: Y $ ORACLE_SID: $ ORACLE_HOME:   2) Add/etc/rc. local Su-oracle-c 'dbstart' Su-oracle-c

1. View service1.1 first look at the example of the next Listener: [Oracle @ db2 ~] $ Lsnrctl service   LSNRCTL for Linux: Version 10.2.0.1.0-Production on 19-JUL-2011 01:24:43   Copyright (c) 1991,200 5, Oracle. All rights reserved.   Connecting to

RedHat 5.5 Oracle 10g File System Single Instance migration to ASM practice 1. Install the ASMlib RPM package: Rpm ivhoracleasm-support-2.1.7-1.el5.i386.rpm Rpm-ivh oracleasm-2.6.18-194.el5-2.0.5-1.el5.i686.rpm Rpm

The binlog function is enabled for mysql in the home decoration. The advantage of enabling this function is that it facilitates data recovery in the future, but the disadvantage is that log files are growing rapidly and will soon occupy the disk

Database Version: Oracle 11.2.0.2 Operating system version: AIX 6.1   Two operations are performed this time. One is to add the new PV to ASM, the other is to delete the VG that is no longer in use, and add the released disk to ASM.   1. Add unused

References. Alter system set log_archive_dest = "location =/u01/app/Oracle/baklog" scope = spfile; A problem occurs after execution. After the database is closed, it cannot start, Bytes ----------------------------------------------------------------

Original article: What to tune in MySQL 5.6 after installationOriginal Article Date: January 1, September 17, 2013Translated on: February 1, June 01, 2014Translated by: Tie WithImprovement on a large number of default optionsMySQL 5.6 has fewer