Database Administrator

Below is a MySQL backup instance, which is tested and passed in Ubuntu. The task is a local backup. It can be used on the server side.#! /Bin/bash Echo "backupmysql V1.0" ### Date stamp ###Datestamp = $ (date + % Y-% m-% d) ### Path ###Startdir

Statement: This is not a technical document. Since I have learned a few tricks about oracle, I cannot afford to sell it to anyone. Just after a meal, I joined several friends in the library. It is just a bit humorous and it can also be used to make

The latest PSU of Oracle is 11.2.0.3.6 on July 6, May 29, 2013. This upgrade is performed for RAC and DB respectively to prepare for the future RAC + DG Environment. System: linux 5.7 x86_64 Database Version: 11.2.0.3.0 Upgrade ORACLE from a single

This article will share with you the Problems and Solutions encountered when installing Oracle 11g on Windows 7. First, on the Windows 7 flagship edition, the Oracle 11g prompts the following error when "product-specific precognition condition check:

In the Oracle 10 Gb database, a materialized view is modified with a simple condition clause, deleted and rebuilt, but the creation fails, reporting that the ORA-00942 table or view does not exist. This is a strange question. Do I think this is a

All content involving internal structures is abstract, but the structure of things often determines the nature of things. If you want to know mongodb in a more fundamental way, take it easy! Let's talk nonsense and step into the topic: MongoDB is a

What are the differences between primary keys, foreign keys, and indexes?   Primary Key Foreign key Index Definition: Uniquely identifies a record. The record must be unique and cannot be blank. The foreign key of

SQL SERVER ranking function RANK, DENSE_RANK, NTILE, ROW_NUMBERPrefaceThis document describes how to use instance data to help you understand SQL SERVER ranking functions RANK, DENSE_RANK, NTILE, and ROW_NUMBER.PreparationsCreate a test

Install Connector/Python: # Wget http://cdn.mysql.com/Downloads/Connector-Python/mysql-connector-python-1.0.11.zip# Unzip mysql-connector-python-1.0.11.zip# Cd mysql-connector-python-1.0.11# Python setup. py install Test whether Connector/Python is

After the Oracle database has been upgraded to 11 GB recently, some problems have occurred. I began to find some things that need to be summarized. Every time I thought: next time, when I build my own data warehouse, be sure to pay attention to

Oracle Data Guard provides the most effective and comprehensive Data availability, Data protection, and disaster recovery solutions for enterprise databases. It integrates management, monitoring, and automated software infrastructure to create and

Java Redis Jedis -- learning note code snippets -- serialization Wikipedia: Redis is an open-source, network-supported, memory-based,Key-Value Pair storage database, Which is written in ansi c. Its development is hosted by VMware. Redis is the most

The oracle optimizer uses statistics to select the optimal or sub-optimal execution plan. During the execution plan determination process, oracle can analyze the data distribution characteristics of each table column very well, however, oracle is

However, before SQL server 2005, SQL SERVER 2000 did not provide this direct function for us to use. The same is true for ACCESS. The following describes the implementation process of data ranking in two cases. The test data is as follows: The

Today is. after a busy day, I finally have time to write something. Some time ago I wrote about how to recover from the existence of a backup in RAc ocr. Today I wrote about how to reconstruct ocr and olr without a backup? The biggest tragedy is

MySQL stored procedures can easily return multiple result sets at a time, but POSTGRESQL currently does not provide such a function. A literal translation method is to use a cursor, but you can also put the result set in an array or a large

Dataguard is an important solution officially recommended by Oracle for the MongoDB architecture. Currently, RAC + Local federation uard + Remote Federation uard has become a common HA architecture in the industry. Switchover and failover are the

Partition partitioning is a performance and Management Optimization Technology launched by Oracle. In the Oracle database technology system, Partition is a big Data processing policy officially recognized by Oracle in the DW (Data Warehouse) system. 

-- ============================================ -- LOGGING and NOLOGGING on table and index segments -- ============================================ In some cases, you can use the log recording mode for the table segment and index segment, or you

1. Connect to Mysql Command: mysql-u -p 1. Connect to MYSQL on the local machine. First, open the DOS window, enter the mysql \ bin directory, and then enter the mysql-u User Name)-p password). Press enter and you will be prompted to enter the