Database Administrator

Install and deploy the Galera Cluster for MySQL Cluster under CentOS 6 Galera Cluster for MySQL is a multi-master MySQL Cluster solution based on synchronous replication. It is easy to use and has no single point of failure (spof) and has high

Configure DataGuard to report to ORA-12528 (In the creation of DataGuard, run rman recovery error ORA-12528 error; The script is as follows: RMAN> connect auxiliary sys/Oracle @ SCMPRD02 Solution: 1. Check whether the listener is started. Script:

Risks of incorrect selection of Oracle Database Design Field Types An Oracle data type is inaccurate. We will construct a table storage date field, a storage varchar2 field, and a storage date field for a test. I have also written the

ORA-16753 error troubleshooting 1. Use dgmgrl to set the database to read-only mode: DGMGRL> edit database dg_name set state = read-only; ORA-16753 Resource guard cocould not open standby database Cause: Resource guard cocould not open standby

Explore Character Set Issues in Oracle EXP/IMP processes, oracleimp 1. Problem description: Data migration between databases is a common job. EXP/IMP is a common data migration and conversion tool, because the exported files are platform-independent,

Why Does Oracle Rac opatch auto fail to hit Rac database home?First explain the environment: OS: AIX 7.1Oracle version: Oracle Rac 11.2.0.3 before the release of the 11.2.0.3.9 Patch Set, Rac is not officially used, so simply hit the latest 11.2.0.3.

MySql Backup Recovery and mysql Backup Recovery Mysql backup restoration method We generally perform the following operations to back up and restore mysql databases (generally from dozens to hundreds of GB) to windows machines, then, the files on

Oracle export and import under the DOS command, oracledos command Export The command running in DOS can also be run with parameters in the SQL/PLUS EnvironmentSimple ExampleSingle Table backup (the structure of the prerequisite database is the

The crontab command automatically backs up the mysql database of the remote server, crontabmysql Today, I used the information collected on the Internet and my own practices to organize and use the crontab command to back up a database on a remote

Solve the Problem of 32-bit plsql client connection to a database without 64-bit Oracle11g, plsqloracle11gSince I installed 64-bit Oracle, plsql cannot be connected because it is 32-bit. There is a way to connect to the Internet; Download

Basic MySQL Data Table operation 2: Table Structure View, modification and table operations, basic mysql operations 1. view the data table structure 1) view the basic table structure statement DESCRIBE Syntax:DESCRIBETable Name; Example: mysql>

IGNOREDELETES, IGNOREUPDATES, ignoredeletes Sometimes, when we do not want to update or delete the data of the target ogg application, we can use the IGNOREDELETES and IGNOREUPDATES parameters. GETDELETES | IGNOREDELETESValid for Extract and

IT Ninja Turtles oracle stored procedure simple data extraction from ODS _ Object-oriented Thinking, oracleods Step 1: Create a package interface similar to the interface definition in java Create or replace PACKAGE pack_ SC _hmd_khIS --

[Mongo] group by time (formatted by time), mongo GroupThe Group key can use the original field or a function to format the date. /* 0 */{ "_id" : ObjectId("541fcc51c6c36038bc6b81cd"), "url" : "http://wifi21.com/", "addtime" :

Basic operations on MySQL Data Tables and basic operations on mysql DATA The following outlines are provided in advance, and details and examples are provided tomorrow: 1. Create a data table 1) Create Table syntax 2) use primary key constraints 3)

[MySQL] MySQL database transactions in the production environment are always RUNNING, and mysqlrunning Preface: The operations staff reported that a ticket was submitted and the page was not returned. 1. At first, I suspected that the application

[Database] query optimization summary and database query SummaryI. Rational Use of Indexes Usage principles: 1. columns that are frequently used as conditions in queries should be indexed. 2. columns that are frequently sorted, grouped by, or order

How to Create a FUNCTION, log-binmysql Create a function in the master database of the MySQL master-slave replication machine and report the following error: Error Code: 1418. this function has none of DETERMINISTIC, no SQL, or reads SQL DATA in its

Oracle Database Backup Recovery, inspection object settings and related recovery overview, oracle Database Backup Database backup and recovery, inspection needs to pay attention to the object settings: 1. database Name and DBID; -- dbid is in v $

SQLPLUS feedback settings, sqlplusfeedback When SQL plus is used to execute an SQL statement, a prompt such as "XX rows have been returned" may be returned for the result returned by a SELECT statement, but this prompt is not found when a database