Database Administrator

In-depth analysis of RMAN-Incarnation application (Incomplete recovery) CASE Environment: Operating System: RedHat EL5 Oracle: Oracle 11gR2 When you use resetlogs to open the database during incomplete restoration of Media Recover, Incarnation

Summary of Oracle SQL Execution Plan and Analysis Oracle has multiple ways to obtain a query plan for an SQL statement, such as using the explain plan command and pressing the F5 shortcut in PLSQL Developer. However, it is easier to use it for SQL

DB2 database backup script in Linux DB2 database backup script in Linux The script runs under the root user: The content of backupDB2Task. sh is as follows: Datedir = 'date + % Y-% m-% d'Delete_date = 'date + % Y-% m-% d -- date = '7 days

Besides, table_id in MySQL Background]Recently, a master-slave data inconsistency occurred in an online instance, that is, data loss from the slave database. Root Cause: "Because table_list-> table_id is uint and m_table_id is ulong, the table map

An example of troubleshooting ORA-04030 errors The customer said that an error was found in the database background as follows: Errors in file/Oracle/bkjia/saptrace/diag/rdbms/bkjia/incident/incdir_183218/bkjia_j003_8103_i183218.trc:ORA-04030: out

In oracle, the month or part of data is obtained from the specified date. The oracle date Obtain part of the data from the specified date: Such as month: Select to_CHAR (sysdate, 'mm') from dual; Or: Select extract (month from sysdate) from

[Translated from mos] In 11gR2 rac environment, the file system usage is tight, and lsof shows many oraagent_oracle.l10 (deleted) and 11gr2rac In 11gR2 rac environment, the file system usage is tight, and lsof shows many oraagent_oracle.l10 (deleted)

ORACLE zookeeper query, ORACLE zookeeper ORACLE supports regular query operations by using the CTE internal audit method, and also has its own unique query method. In ORACLE, this method is called continuous data query. This example illustrates the

How to bypass the password settings of the oracle listener and use oraclelistenerZookeeper How to bypass the password settings for oracle listening: 1. Find the pid of the listening process and kill it.Ps-ef | grep tns [Oracle @ lixora admin] $

[Translated from mos] enabling dblink's oracle net trace/tracing and mosdblink Enable dblink's oracle net trace/tracing -- Method for tracking dblink. Reference Original:DBLINK: How to Enable Oracle Net Tracing for Database links (Doc ID

Bison executable not found in PATH by mysql install, bisonexecutable [Root @ luozhonghua mysql-5.5.21] # cmake.-DCMAKE_INSTALL_PREFIX =/usr/local/mysql-DMYSQL_DATADIR =/data/mysql-DSYSCONFDIR =/etc -- Check size of pthread_t-- Check size of

[Translated from mos] ABMR: A method to test the Recover feature of the Automatic Block in the asm environment, mosabmrABMR: how to test the Recover feature of the Automatic Block in the asm EnvironmentReference Original:ABMR: How to test Automatic

When mybatis inserts a comma-containing value into mysql, the following error occurs: mybatismysqlAn error is returned when mybatis inserts data such as "11, 22, 33" into mysql. The cause of the error is that I joined the SQL statement with the

Develop independently and intelligently Recently, I checked the statements that run on the database for a long time and found that the developers on our side are really amazing, and the skills they do not understand are really high. The

Solr In Action Chinese Version chapter 1 (ii), solraction What is Solr? In this section, we design a search application from scratch to introduce the key components of Solr. This process will help you understand Solr functions and the original

Super powerful: Use case... when... then... else... end condition query (different from where) in SQL commands and type conversion Case... when... then... else... end is before from. You can change the value of a field in the record and cannot

After upgrading the database cluster to 10.2.0.5, the dual-node server continuously restarts and queries the oracle oprocd process logs. The information is as follows: Jul 03 08:16:34.702 | INF | monitoring started with timeout(1000), margin(500),

1 syntax GREATEST (expr_1, expr_2,... expr_n)2 Description The GREATEST (expr_1, expr_2,... expr_n) function returns the maximum number from the expressions (columns, constants, and calculation values) expr_1, expr_2,... expr_n, and so on. During

50. SLS is a private synonym for the SH. SALES table.The user SH issues the following command:Drop synonym sls;Which statement is true regarding the above SQL statement?A. Only the synonym wocould be dropped.B. The synonym wocould be dropped and the

1.1.1. HA: inconsistent GTID_MODE configurations [Environment description] Msyql5.6.14 [Error message] In the initial state, both the Master and Slave enforce-gtid-consistency and gtid-mode are enabled, and both of them are changed to off. In