Database Administrator

Database Backup is an important means to ensure database security. Most database administrators have discovered the importance of backing up databases, and even have great dependence on them. Therefore, the database administrator must ensure that

A Linux job needs to compile a MySQL by itself, but there is already a MySQL on my system. Compile another one. The most troublesome thing is not to compile, but to make the two coexist. There is no difference between the previous compilation

I 've been hearing that installing Oracle on Ubuntu is quite troublesome. I 've experienced it today and may be lucky. There's no problem. Just record it and declare that I installed Oracle XE, that is, the quick version mentioned on the official

How to solve the problem of max_allowed_packet is read-only when BugZilla is installed on Fedora 11Problem description: When I have installed all the perl modules and MySQL databases, the following error occurs when I run./checksetup. pl:DBD: mysql:

The SELECT statement of MySQL has the following parameter: SQL _CALC_FOUND_ROWS. This parameter can be used with the function FOUND_ROWS () provided by MySQL. When we use LIMIT ?,? During paging query, only the records you want are returned. For

I. OverviewMongoDB is an open source database project based on distributed file storage. Written in C ++. It is designed to provide a high-performance data storage solution that can be expanded for WEB applications. MongoDB is a product between

Google developed a patch for mysql, a semi-synchronous patch, and an application and mysql5.0. Mysql is installed with this patch and used in mysql 5.5. What is the concept of semi-synchronous replication? Before the Database Change operation is

I. Question 1 The following error is found in the alert log for RAC standby: SUCCESS: diskgroup DATA was mounted ERROR: failed toestablish dependency between database dave_st and diskgroup resourceora. DATA. dg SUCCESS: diskgroup FRA was

OutlineI. Log ClassificationIi. Log details Note: MySQL version, Mysql-5.5.32 (different versions of mysql variables are different) I. Log ClassificationError LogQuery logsSlow query logBinary logRelay logTransaction LogRolling logs Ii. Log details1.

I have heard of the restoration (restore) database, tablespace and database files, and the use of archive log recovery (recover) database, tablespace, and database files. Restore. What about restoring archived logs? Yes, we may ignore the archive

I checked alert log and found the following error: View alert log: Fri Aug 2 07:13:33 2013 Errors in file/u01/Oracle/admin/eptdb/bdump/eptdb1_j002_961_4.trc:ORA-00600: internal error code, arguments: [ktspNextL1: 4], [], [], [], [], [], [], [],

Oracle Online Segment shrinkage (Online Segment Shrink) refers to the fragments in the Online Segment space. It has the following features: Online, that is, in the segment compression process, DML is almost unaffected (DML will be blocked only a

Oracle 10 DBMS_MONITOR tracks and analyzes other session SQL statements 1. session information View the current session information statement Select sid, serial #, username, machineFrom v $ sessionWhere type! = 'Background'And username = 'sys '; --

Note:This article installed and configured the Oracle 11g slave uard physical standby Database, and tested the new feature of the 11g slave uard physical standby Database Active Data Guard. It is a feature of Oracle Database Enterprise Edition and

Note: The database should be supported in the archive mode. 1. Back up the SYSTEMG tablespace.[Oracle @ bys001 ~] $ Rman target/Recovery Manager: Release 11.2.0.1.0-Production on Tue Sep 17 10:42:18 2013Copyright (c) 1982,200 9, Oracle and/or its

Environment: 11.2.0.3 + OEL5.7 192.168.1.55zlm sid: zlm11g 192.168.1.60zlm2 sid: zlm11g Gg package: ogg112101_fbo_ggs_Linux_x64_ora11g_64bit Oracle DML Process PL/SQL ORA-14551: cannot perform DML operations in queries solved Common MySQL DDL, DML,

Buffer Pool Flush Listadd page to flush list The page in the buffer pool has three states: Free: the current page is not used. Clean: the current page is used. It corresponds to a page in the data file, but the page is not modified. Dirty: the

Environment: I use the VBOX virtual machine, a host that has installed the Oracle database and GOLDENDGATE. The other one only installs the ORACLE database.Configure the database environment, goldengate users, and install GoldenGate. For more

1. Oracle 11g R2 installation manual (Graphic tutorial) For Windows Before installation, you must confirm the following points: There is no problem with your memory (this is very important, if your machine is often blue screen, then don't install it,

I. Introduction PostgreSQL is a very complex object-relational database management system (ORDBMS). It is also currently the most powerful, feature-rich and complex free software database system. Some features are not even available in commercial