PRM-DUL success story: restoring a GB corrupted Oracle Database

PRM-DUL success story: restoring a GB corrupted Oracle database. A central enterprise found that its database with a size of GB exists with dozens of thousands of Bad blocks after its storage is powered off and restarted. The database cannot be

PRM-DUL success case: successfully recovered from the damaged ASMDiskgroup for a brokerage

Another successful case of PRM-DUL was the success of recovering hundreds of GB of data files and archiving logs from the compromised ASMDiskgroup for a brokerage firm: Relatedposts: PRM-DUL success stories: successful for a customer in the Central

MySQL does not have the GROUPBY direct HAVING problem.

The content of this article complies with the CC copyright agreement and can be reproduced at will. However, the original source and author information of the article and the copyright statement URL must be indicated in hyperlink form: www.penglixun.

Nagiosqlcentos6.4x64nagiosmysql monitoring settings

Nagios3.5 monitoring mysql requires the check_mysql and check_mysql_query plug-ins. After nagios is installed, the plugin check_mysql is not found in the directory: usrlocalnagioslibexec. Solution: yum? Install? Mysql-devel and then go to the nagios-

PhpAes Encryption Class

Today I wrote a php AES Encryption Class. Applies to Yii extensions. If you do not need to use the Yii framework, replace Yii: app ()-params [encryptKey] in the Code with your default key. For the code, see github.

Optimize the use of temporary tables and improve the performance of SQL statements by 100 times

[Symptom] a slow query occurred in the online mysql database. DBA observed that the IO usage of the server soared during the query, reached 100%, and the execution time was about 7 s. The SQL statement is as follows: SELECTDISTINCTg. *, cp. nameAScp_

GettingStartedwithMongoDBandJava: PartII

ByTrishaGee, JavaEngineerandAdvocateatMongoDBInthelastarticle, rule. Inthispost, IllgiveanintroductiontoCRUD (Create, Read, Update, Delete) o By Trisha Gee, Java Engineer and Advocate at MongoDB In the last article, we covered the basics of

Install Redis and MongoDB in CentOS7

The previous article involved node. js, and this time it involved Redis and Mongodb, so that the entire development environment of node. js was basically installed. It is also relatively simple to install Redis in CentOS. The steps are step by step,

Install Oracle11g in centos6

Configure VNCServer # yuminstalltigervnc-server # yumgroupinstallgeneralpurpose?top=topplatform # yuminstallxorg-x11-server-utils to configure VNCserver # vimetcsysconfigvncservers? VNCSERVERS2: rootVNCSERVERARGS [2]-geometry14 Configure VNC Server #

MySQL string case sensitivity

I just learned that MySQL's varchar type is case-insensitive by default, and the last space is ignored. C.5.5.1.CaseSensitivityinStringSearchesmysqlSELECTaA; I just learned that MySQL's varchar type is case-insensitive by default, and the last

Can 'tconnecttolocalmysqlserverthroughsocket

Problem description: php cannot connect to the local database when connecting to the local database through localhost. Analysis: php connects to the local database through localhost through socket connection. Therefore, you must find the socket file

MMS features (1)

The MongoDB Management Service (MMS) is an infrastructure service used to monitor and back up MongoDB. The monitoring service is free of charge, and the backup service is charged. MMS monitoring MMS provides real-time reports, visualization, alarms,

Use goproxy to implement local HTTP Proxy Based on VPN

Recently, when I used VPN, I felt that some areas were not very useful. For example, when I used HTTP proxy, I Could Use Chrome's proxy-switchysharp plug-in to perform automatic switch, so that I could access domestic resources and foreign resources

Coreseeksphinx create tables and Indexes

As mentioned above, the installation of coreseeksphinxmmsegmysql and so on will explain how to use it. One, coreseeksphinx start, there will be an extra port, and can log on like mysql, but not login mysql [root @ localhosttank] # mysql-h127.0.0.1-P9

OraclePolicy-ManagedCluster-GrowforDBaaS

Policy-ManagedCluster is introduced in Oracle11gR2. When dbca is used in Oracle12c to create a RAC database, the Policy-Managed option has become the default value. So what is the Policy-Managed cluster and database? What is the difference from the

Refresh the database recovery history to Oracle7.3.2 again-redo exception recovery

Some netizens asked me about Oracle7.3's database on QQ, and asked me if I could restore the database to get the following information: SVRMGRselect * fromv $ version; BANNER has Oracle7WorkgroupServerRelease7.3.2.2.1 Some netizens asked me about

What if the hard disk is full due to the server database?

Because the database on the server is backed up in two directions, the Data expands. The root directory of the server has been 100% and the database cannot be started. I discovered this problem. So you have to add a new hard disk. How to mount and

Paradigm and anti-paradigm in MongoDB

This article is excerpted from Chapter 8 of the MongoDB authoritative guide. You can answer the following two questions: segmentfault. comq100000000364944segmentfault. comq100000000364944 has many data representation methods. One of the most

In-depth analysis of redis Data Structure redisObject

Redis is a key-value storage system, where the key type is generally a string, while the value type is a redis object (redisobject ). Redis objects can be bound to various types of data, such as string, list, and set. TypedefstructredisObject {type

What is the difference between MySQL utf8_general_ci and utf8_unicode_ci?

The general explanation is that utf8_general_ci is faster, and utf8_unicode_ci is more accurate... But where is it? First of all, its accuracy, there are no number of words in the world, in addition to the general English use of our more familiar

Total Pages: 12780 1 .... 6027 6028 6029 6030 6031 .... 12780 Go to: GO

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.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.