Database Administrator

Implement ACFS replication on Oracle 12C Environment: qc550705 & qc550707, AIX6.1 + 12c RAC Primary FS: qc550705:/acfs3 Standby FS: qc550707:/acfsstd1 Prerequisites: the available space of primary FS must be equal to the space in use. Follow these

Oracle 10g quick manual database creation procedure Step record of Oracle 10g quick manual database creation: 0. Modify Environment Variables [Oracle @ ocm1 ~] $ Vi. bash_profile Add the following content:Export ORACLE_SID = PRODExport ORACLE_BASE =/

MariaDB single-host dual-instance master-slave Replication MariaDB single-host dual-instance master-slave Replication MariaDB is actually the same as MySQL, but its name is different. Start ~ In the previous experiment, we installed MariaDB on a

Install MariaDB and MySQL MariaDB can be used to replace enhanced MySQL versions, but MariaDB can also be installed when MySQL is installed. (This makes sense. For example, you want to migrate data from one database/application to another

Steps for Oracle to execute SQL query statementsThe SQL query statement executed by Oracle is different from that of other statements. If the query statement is successfully executed, the query result is returned. Other types of SQL statements only

Oracle Rman backup script and automatic deletion of duplicate backup files, mongolerman #!/bin/shsource /home/oracle/.bash_profileif [ -z $1 ]then echo "Please Input a number,Usage: 0|1|2" exitelse RMAN_LEVEL=$1fiexport ORACLE_SID=xxxxexport

MySQL statistics for the past 12 months (including this month), mysql this month1. Problems We need to collect statistics for the past 12 months. For example, we need to collect statistics from. In the past 12 months, if there is no data for this

MySQL backup -- mysqldump, mysql -- mysqldump Back up MySQL directly by using the mysqldump command to back up it to the SQL format. The simplest command is: mysqldump databasename > bak.sql The generated bak. SQL content format is as follows: --

(15) mysql triggers and 15mysql triggers Overview A trigger, as its name implies, executes a program when something (event) occurs. Triggers have four main elements:Monitored location (table_name),Monitoring event (insert/update/delete),Trigger time

SQL is required. Note that chapter 19th uses stored procedures. SQL is required.19.1 stored procedures Stored Procedure:A set of one or more SQL statements saved for future use. It can be considered as a batch file, although they are not limited to

Mysql generates a time dimension table. mysql generates a dimension table. Generate a time dimension table in mysql Using mysql common date functions to generate a time dimension table is the most efficient and simple, without the support of other

Basic Database SQL syntax and basic SQL syntax Reprint please indicate from Zhu jiayuan http://blog.csdn.net/zhgl7688 Basic Database SQL syntax 1. Create a SQL database, Open SQL Server Management Studio, click "new query", and enter the following

7. Basic Redis commands-task queue and redis queue1. Advantages: loose coupling is easy to expand, and consumers can expand multiple servers.2. LPUSH RPOP3. The BRPOP command is similar to RPOP. The only difference is that when there are no elements

NoSQL data model (4) Summary of nosql aggregation, NoSQLBackground in the first three articles, we have introduced three databases that belong to the aggregation model in NoSQL: Key-value type, document type, and column family type. The following

Understanding SQL Server statistics and SQL statistics Preface SQL Server queries are based on overhead queries. When an execution plan is generated for the first time, a better execution plan is determined based on multi-stage analysis

Solve the Problem of connecting 64-bit Oracle with PLSQL, and connecting 64-bit oracle with plsql Since most of the current laptops are 64-bit Windows 7 systems, PLSQL_Developer does not have 64-bit, which causes us to connect. Here we will teach

Unable to start MySQL service. Another MySQL daemon is already running with the same UNIX socket, unablemysqlUnable to start MySQL service. Another MySQL daemon is already running with the same UNIX socket  Features If you encounter any of the

Install MySQL in windows and MySQL in windows 1) double-click the MySQL Installation File mysql-essential-5.0.82-win32.msi to enter the welcome page. Click Next To Go To The installation type page. 2) on the installation type page, the first is the

Db_recovery_file_dest_size is full, leading to database startup failure.When starting the database: SYS@orcl11g>startupORACLE instance started.Total System Global Area 417546240 bytesFixed Size 2213936 bytesVariable Size

[MongoDB] mongodb sharded cluster (5) on windows platform, mongodb Cluster In this article, the above four articles continue to describe how to build a mongodb sharding cluster on the window platform. You can also create indexes in a sharded cluster.