Diagnosis and repair of a rac vip drift

Diagnosis and repair of a rac vip drift Background The customer's 10 Gb database VIP is down, causing VIP load to another node Event support details 04:29:56. went OFFLINE unexpectedly occurs in the VIP of machine 1 of 378. Check the cause of VIP

MySQL explain analysis Query

MySQL explain analysis Query Brief description: You can use the EXPLAIN or DESC keyword to simulate the optimizer to execute SQL query statements to know how MySQL processes your SQL statements. This helps you analyze the performance bottleneck of

Mydumper-MySQL Database Backup Tool

Mydumper-MySQL Database Backup Tool Mydumper is a MySQL database server backup tool, which is much faster than mysqldump. It also provides the ability to obtain remote server binary log files while dumping. Advantages of Mydumper Parallel

The COMPRESSION parameter COMPRESSION ratio of Oracle 11g EXPDP is comparable to that of "gzip-9"

The COMPRESSION parameter COMPRESSION ratio of Oracle 11g EXPDP is comparable to that of "gzip-9" This compression ratio can be comparable to the operating system "gzip-9". In some cases, it may be more efficient than gzip. For your reference. 1.

MySQL slow Query

MySQL slow Query Brief description: To analyze the query performance of MySQL statements, in addition to using the EXPLAIN command to output the execution plan, MySQL can also record the statements whose query exceeds the specified time, the SQL

Redis master-slave configuration and Sentinel Construction

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

ORA-28001: the password has expired. (password expired)

ORA-28001: the password has expired. (password expired) ORA-28001: the password has expired. (password expired), a new feature of Oracle 11g, default user password only valid for 180 days. 1. plsql logs in as an administrator, and system/admin

Error ORA-02287 Using Sequence

Error ORA-02287 Using Sequence Today, a developer asked me a question, saying that the ORA error was reported when an SQL statement was executed. After my mind deleted the permissions, the error he gave me was unexpected.ERROR at line 1:ORA-02287:

Table creation statement under the name of Oracle Scott

Table creation statement under the name of Oracle Scott We often use data for testing when learning Oracle, so it is necessary to create tables and data. Create table EMP(Empno number (4) primary key,ENAME VARCHAR2 (10 ),JOB VARCHAR2 (9 ),Mgr number

Use Shell scripts to view database tablespace usage

Use Shell scripts to view database tablespace usage Check the table space in the database. You may have a lot of scripts in use. You can also read it and share an example of using shell scripts to check the table space usage.The script is as follows:

Use flashback database to implement flexible data rollback

Use flashback database to implement flexible data rollback I wrote an article about using the flashback database feature to avoid repeated import of large amounts of data in the test environment, resulting in a waste of time and storage space.The

Python accesses the MySQL database and supports addition, deletion, modification, and query.

Python accesses the MySQL database and supports addition, deletion, modification, and query. Overview:I want to know more about accessing the MySQL database. However, since I recently learned Python, I will use Python to implement it below. These

Updated materialized views of PostgreSQL 9.4

Updated materialized views of PostgreSQL 9.4 PostgreSQL version 9.4 has been released for a while and has updated a lot of content. One of them is the update of materialized views that are of interest. Compared with the original materialized view

Two MHA switching exceptions (masterha_master_switch line 53)

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 Character Set GBK to UTF8

MySQL Character Set GBK to UTF8 In the production environment, the character set of the MySQL database needs to be upgraded for various reasons. For example, to support Chinese characters, the character set of latin1 must be upgraded to GBK, you

ORA-00494 enqueue [CF] held for too long troubleshooting

ORA-00494 enqueue [CF] held for too long troubleshooting Today, the application staff responded by phone that an exception occurred after a backup database was added to the tablespace. This problem occurs when the database can be queried, but the

Oracle RMAN database backup and recovery in non-archive Mode

Oracle RMAN database backup and recovery in non-archive Mode 1. Database Backup in non-archive Mode SQL> archive log list;Database Log mode non-archive ModeDisable automatic archivingArchiving end point USE_DB_RECOVERY_FILE_DESTOldest online log

MySQL error: Unknown character set: 'utf8mb4'

MySQL error: Unknown character set: 'utf8mb4' Com. mysql. jdbc. exceptions. jdbc4.MySQLSyntaxErrorException: Unknown character set: 'utf8mb4'At sun. reflect. NativeConstructorAccessorImpl. newInstance0 (Native Method)At sun. reflect. nativeconstruct%

Record Oracle bad block Repair Process

Record Oracle bad block Repair Process The following error was reported during RMAN cold backup yesterday when I received a backup call from my colleague. A tablespace backup failed.RMAN-00571: ========================================================

Configure MySQL master-slave replication in Linux

Configure MySQL master-slave replication in Linux MySQL master-slave replication is a practical experience that you have always wanted to learn, because the master-slave replication in Oracle also requires a lot of configuration options. In contrast,

Total Pages: 1013 1 .... 189 190 191 192 193 .... 1013 Go to: GO

Alibaba Cloud 10 Year Anniversary

With You, We are Shaping a Digital World, 2009-2019

Learn more >

Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

Learn more >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.