Database Administrator

Oracle ADG Heartbeat failed to connect to standby fault case The customer's primary Database is a standalone Database of Oracle Database 11gR2 for AIX. The ibm hacmp software is deployed at the system level, the database is made into a master-slave

Resolving index failure when Oracle Partition Table deletes partition data I. Description Today, we have a small task to delete some data. Haha, please be happy first. Because the data table to be deleted is the partition table that I previously

Routine maintenance and troubleshooting of Oracle 11G R2 slave uard 1. About the Forced Logging ModeSome DDL statements can avoid writing redo logs by specifying the NOLOGGING clause (the purpose is to increase the speed, which is indeed valid in

Database migration can be seen as a special software development project. Different from other development projects, the requirements of this project are fixed, and the technical barriers are low. The main task is coding and testing. For database

To connect to a remote Oracle database using Toad on the local machine, follow these steps. Step 1: Install the Oracle database Pay attention to the following points when installing the Oracle database: 1) Click setup.exe, the outmost icon of the

Use tdm to compile the 64-bit qt mysql driver, tdmqt The official website only provides the 32-bit qt version compiled by mingw. After testing, the mysql driver can be directly installed and transactions can be executed.However, if I use the 64-bit

What is the difference between the unique key constraint of SQLServer and the unique index ?, Sqlserver Index I used to want to know what the difference was, but I forgot it because we seldom use the unique key constraint. A few days ago, my

Football and oracle series (3): oracle process rankings, the World Cup round is about to fight! 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

Java cannot directly insert Clob Data Types in Oracle, but it can write or read clob data in the form of a stream. The online code is not too much, I have summarized and summarized the online materials. For details, refer to the Code: Write clob

DB2 logs are divided into two modes: log loop and archive log, which are non-archive and archive modes. The following describes the two methods and their relationship with backup archiving settings. 1. Log Loop This is the default mode, that is, non-

MySQL loads the JDBC driver and mysql loads the jdbc driver. First, install the MySQL database. MySQL5.5 is installed. The installation steps are not described here. Please note that if the installation process stops at the start service and cannot

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

Capture a child to earn a strong capture a child to earn a strong grasp a child to earn a strong, earning a

Oracle purchase price research (2): oracle purchase price researchRead Oracle purchase price researchFocus of this Article The previous article wrote online materials and theoretical research. This article mainly describes the actual enterprise

1. Environment Requirement Description: The user has an oracle 10g Database on the Intranet and an oracle 9i database on the Internet. The user publishes information about talent recruitment through the Intranet. All information is stored in one

Spring database access (oracle) configuration, spring Data Access Chen kezhao: http://blog.csdn.net/u013474104/article/details/44279309 ====================== 1. spring's support for database access When developing the persistence layer, we are

Before OMF (managed files) is available, the database administrator needs to care about two issues when creating data files. The first is what kind of name should be taken for this data file, and the second is to consider whether the newly created

[Oracle] Chapter 1 create authorization, Chapter 1 Authorization of oracle Chapter 1 create authorization in ORACLE Run the following command to view control files, data files, and log files: Control File: Desc v $ controlfile; Data File: desc v $

Mysql5.5 master-slave synchronous replication configuration, mysql5.5 master-slave Synchronization In the previous article "mud: learning the principles of mysql database master-slave synchronous replication", we introduced the basic principles of

BKJIA exclusive Translation] This article provides a general introduction to the automatic database maintenance task management in Oracle 11g. The article is concise for two reasons: 1. Most people have not touched these settings. Even so, if you