Database Administrator

PRM an Oracle database disaster recovery ambulance Tool In the real world, I believe many of my friends have encountered database or file system damages, and suddenly precious data cannot be accessed, which is too fatal for companies that use data

Install MySQL in CentOS and use Navicat for MySQL in WindowsInstall Check whether the installation has been performed:Yum list installed mysql *Rpm-qa | grep mysql * Check whether the installation package is available:Yum list mysql * Install the

1: Enter slqplus sytem/password as sysdba In the Ubuntu terminal to report the following error: ORA-01031: insufficient privileges, found on google ORA-01031: insufficient privilegesAfter the Oracle installation is complete, the system has an

Oracle is a profound technology. Oracle, which has been playing for two years, still has many unknown knowledge points. Yesterday, my friends in the group mentioned the DEDICATED and SHARE modes. I don't know. I am quietly doing my homework. I

REGEXP_LIKE (matching)REGEXP_INSTR (included)REGEXP_REPLACE (replace)REGEXP_SUBSTR (extract) For example, the expression of the mobile phone number: ^ [1] {1} [35] {1} [[: digit:] {9} $You can query customer information tables (tKHXX) that contain

Oracle Data Guard synchronizes Data through archive files. The archive files of the master database can be deleted during RMAN backup, but the archive files of the slave database cannot be deleted automatically. You need to write scripts to delete

Oracle join usage Join) T1 {[INNER] | {LEFT | RIGHT | FULL} [OUTER]} JOIN T2 ON boolean_experssion {[INNER] | {LEFT | RIGHT | FULL} [OUTER]} JOIN T3 ON boolean_experssion ..... T1 {[INNER] | {LEFT | RIGHT | FULL} [OUTER]} JOIN T2 USING (join colunn

There are three methods to obtain the current Session ID (Session ID) of Oracle: 1.Below, this should be common. SQL>Select sid from v $ mystat where rownum = 1; SID ---------- 140 2.The following is simpler:,HoweverOracle 10gAnd later

I. Check the memory and swap spaceOracle claims that the installation of Oracle10g 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

1. Check the database mode:Sqlplus/nologConn/as sysdbaArchive log list (check whether the database is in archive Mode) If not, the database archive mode is modified.Startup mountAlter database archivelogAlter database open 2. connect to the target

02-mysql-installation, mac installation 02 mysql02-mysql-Installation ---- MySQL installation version And technical documents Mysql current common version mysql-5.6.15.tar.gz ---- MySQL compilation and Installation 1.Installation environment

[Translated from mos] The asmcmd cp command cannot copy files larger than 2 GB ., MosasmcmdThe asmcmd cp command cannot copy files larger than 2 GB.Reference Original:Asmcmd CP Command Can Not Copy Files Larger Than 2 GB (Doc ID

Solve the problem that MySQL cannot be fully detached when the mysql service cannot be started in windows. MySQL Solution The following articles mainly describe the actual solution that cannot be fully detached when the MySQL service cannot be

1.1.1. If a crash happens thisconfiguration does not guarantee that the relay log info will be consistent [Environment description] Msyql5.6.14 [Error message] When mysql slave is started, the following Warning occurs in error. log: [Warning] Slave

Oracle RAC cache fusion is the core working mechanism of RAC. It virtualizes the SGA of all instances into a large SGA zone. Each time different instances request the same data block, this data block needs to be transmitted between instances. So

The environment used in this article is: win7_64 + Eclipse + mavenI. Preparations Download the java driver package Driver Pack: http://mvnrepository.com/artifact/org.mongodb/mongo-java-driver MongoDB http://www.mongodb.org/ Api:

PrefaceBodyPL/SQL(Procedure Language, Procedural Language) SQL 1999 a structured Language commonly used by major database vendors PL/SQL only supports Oracle databasesBasic syntaxMulti-line comment/**/single-line comment --PLSQL

GB8567--88 Database Design Specification 1 Introduction High-quality databases play an important role in big data processing programs or systems. Therefore, there are many requirements and regulations for database design. First, the database must

-- Buffer hit rate: the ratio of the buffer hit rate between the obtained data and all accessed data. The normal metric is 90% ~ 100%. However, it may be lower-- 90%. The buffer hit rate is affected by the data block buffers parameter settings in

One-hot standby In the last two articles (MySQL backup and recovery for cold backup, MySQL backup and recovery for the real environment for cold backup), we mentioned the use of cold backup in the cold backup and real environment. From this article,