Database Administrator

ORA-00031-mark the session to terminate and kill the process at the OS level Reporting when killing a processORA-00031-mark the session to terminateHowever, viewing the v $ session view still exists, but the status is changed to killed and is not

Common RMAN parameter settings View All RMAN configurationsRMAN> show all; RMAN configuration parameters for database with db_unique_name Oracle007 are:Configure retention policy to recovery window of 7 DAYS; ------ backup files are saved for 7 DAYS

Functions of standby redo log We all know that dataguard has three data protection modes: maximum protection mode, maximum available mode, and maximum performance mode.In the maximum protection mode, standby redo log must be used in the highest

Use Oracle PROFILE to control session idle time The following is an example of how the customer wants to control the idle time of a session.Microsoft Windows [version 6.1.7601]Copyright (c) 2009 Microsoft Corporation. All rights reserved. C: \ Users

Redis master-slave configuration and Sentinel Construction As one of the mainstream nosql database products, redis is widely used. This article describes the master-slave configuration method of redis and how to ensure high availability and

Two MHA switching exceptions (masterha_master_switch line 53) In the process of testing manual failover and online failover, MHA encountered two strange problems, and the test was not successful when calling the IP address, detected dead master xxx

MySQL MHA configuration FAQ MHA is widely used in MySQL databases. It is compact, easy to use, and powerful. It enables manual master-slave failover Based on the MySQL replication architecture, redirects from the database to the master database, and

MongoDB BASICS (iv) Red Hat Enterprise 6.4x64 install MongDB 3.0 and configure mongodbmongdb Mongodb-org this package is a metadata package. The following four package packages are automatically installed during installation. Mongodb-org-server

MySQL Study Notes _ Connect C ++/C to MySQL database in 12_Linux (2), _ 12_linuxmysql C ++/C in Linux connects to the MySQL database (2) -- return data SQL reference: The SQL statement that returns data is used to retrieve data records that meet

Database and database LearningLogical Structure Design Task of Logical Structure DesignThe basic E-R diagram designed at the conceptual structure design stage is converted into a logical structure that complies with the data model supported by the

Database and database LearningConceptual Structure Design What is conceptual structure design?Abstract The user requirements obtained from the requirement analysis into an information structure, that is, the conceptual structure design process.The

Database and database LearningPhysical Optimization Algebraic optimization changes the order and combination of operations in a query statement, and does not involve the underlying access path.There are many access solutions for a query statement,

Redis learning, redisFeatures of Redis master-slave copy After the slave is connected to the master, slave sends a SYNC command to the master. After the master receives the command, whether it is the first connection established during

Database and database LearningData Dependency System Logic Implication definition 6.11 For the relational mode R that satisfies a set of function dependencies F, any of its relational r is true if function dependencies X → Y, (that is, any

Use the Oracle 11g adrci ips to package an incident, adrciips [Oracle @ rhel63single ~] $ Which adrci/u02/app/oracle/product/11.2.0.4/db_1/bin/adrci [oracle @ rhel63single ~] $ AdrciADRCI: Release 11.2.0.4.0-Production on Sat May 2 22:32:28 2015 ----

Solve and analyze the slow MySQL remote access speed and mysql remote access speedEnvironment Introduction:OS: RHEL5.4MySQL: 5.5.10Exception scenarios:The database has been accessed and used in the Intranet of the data center. A foreign node needs

Materialized View, index view, and function index. DESC is used when an index is created, and desc is materialized. I searched the information for a task assigned by the boss and thought it would be better to summarize it. What if I use it later?

HRegionServer Flush source code analysis, hregionserverflush The Flush operation is the process of saving HBase data to the hard disk. The specific flush flowchart is as follows. This article briefly analyzes the source code of the flush

Mysql imports data to excel, mysqlexcel Create a test data table first Create table users ( Username varchar (40) not null, Password varchar (40) not null) charset = utf8; Insert data Insertinto users values ("admin", "admin "); Insertinto users

PostgreSQL tutorial (17): client commands (1), postgresql tutorial 0. Password File: Before providing other PostgreSQL client commands, we need to first introduce the password file in PostgreSQL. The reason why this file is described in advance is