NAV: SLTechnology News&Howtos > Database >

• 

  Single node recovery of different machines under Aishu (Version: 6.0.17.0.1704) oracle rac

  1. Restore parameter file-any read / write path / u01/oracle/recoverydata (database needs to be in nomount or mount state) 2. Modify parameter file-pfile_dmsdb.ora#plusdb.db_

  2022-06-01 18:44:21 Views: 311
• 

  The simplest database backup script

  Source ~ / .bash_profilebackup_path=/data/backup/mysql-backupfile_dirname=$ {backup_path} / $(date + "% Ymuri%)

  2022-06-01 18:44:20 Views: 285
• 

  ORACLE uses the method of cold backup database migration

  Experimental subjects: two linux stand-alone oracle 12C databases (large version and small version are the same), data migration adopts cold backup. The path of the target machine is not the same as that of the source database, and the controlfile needs to be rebuilt. The migration step first turns off listening, and kil

  2022-06-01 18:44:17 Views: 241
• 

  The solution to the failure of MySQL to start

  What if MySQL fails to start? This problem may be often seen in our daily work. Through this question, I hope you can gain more. Let's take a look at the solution with the editor today. The method 1:data folder is created by yourself. Delete the data folder and enter it in the DOS interface

  2022-06-01 18:44:17 Views: 253
• 

  Oracle manual library building tutorial

  System environment: operating system: RedHat EL6Oracle: Oracle 10g and Oracle 11g manual library is relatively easy to achieve, this case is from 10g and 11g, by way of manual library to make a simple comparison, but

  2022-06-01 18:44:17 Views: 226
• 

  Oracle 10g rac add control file

  1. View the current control file select * from vault control immediate3 2, close the database $srvctl stop database-d control-o immediate3, and start to nomount

  2022-06-01 18:44:13 Views: 208
• 

  Oracle update optimization

  First, the syntax and principle of update sentence 1. Syntax sheet: UPDATE table name SET column name = new value WHERE column name = a value such as: update t_join_situation set join_st

  2022-06-01 18:44:13 Views: 300
• 

  Mysql-proxy implements read-write separation script

  Save the following script as / etc/init.d/mysql-proxy and grant permission to chmod 755 / ETC _ init.d _ mysql-proxy This

  2022-06-01 18:44:13 Views: 293
• 

  How does Redis use the LRU algorithm?

  1. Set Redis to use LRU algorithm LRU (Least Recently Used) recently least used algorithm is one of many replacement algorithms. There is a concept of maxmemory in Redis, mainly to limit the memory used to a fixed

  2022-06-01 18:44:13 Views: 216
• 

  A point record of an index in MongoDB

  A federated index is used in MongoDB, and some problems are found. Record it for later reference! First, let's take a look at the description of the table: note the highlighted index: prop.lis_sta_1_prop.is_recom_-1_prop.re_t_-

  2022-06-01 18:44:06 Views: 246
• 

  Common sentences in SQL Server

  1.sp_helptext is the text that displays rules, default values, unencrypted stored procedures, user-defined functions, triggers, or views. 2.SQL queries the table in which a field data resides, select a.name as table name from sysobject

  2022-06-01 18:44:06 Views: 226
• 

  The method of converting MySQL string to base64 Encoding

  This article mainly introduces the method of converting MySQL string to base64 coding. The content of the article is carefully selected and edited by the author. It has a certain pertinence and is of great significance to everyone's reference. Let's learn about the conversion of MySQL string to base64 coding with the author.

  2022-06-01 18:44:06 Views: 222
• 

  How to deal with database configuration parameter exception in Mysql5.6

  This article mainly tells you how to deal with database configuration parameter anomalies in Mysql5.6. You can check the relevant professional terms on the Internet or find some related books to supplement them. We will not dabble here. Let's go straight to the topic. We hope that database configuration parameters will appear in Mysql5.6.

  2022-06-01 18:44:06 Views: 238
• 

  What is the specific difference between oracle and mysql

  The following mainly brings you the specific differences between oracle and mysql. I hope these contents can bring you practical use, which is also the main purpose of this article that I edit the specific differences between oracle and mysql. All right, don't talk too much nonsense, let's just read the following. Work with

  2022-06-01 18:44:06 Views: 215
• 

  Explanation of SQL Server basic sentences

  1. Description: copy table (copy structure only, source table name: a new table name: B) (available for Access) method 1: select into b from a where 1 < > 1 (for SQlServer only) method 2: select top

  2022-06-01 18:44:05 Views: 242
• 

  Design a script method for automatic monitoring synchronization from MySQL

  The following is about the scripting method of designing automatic monitoring to synchronize from MySQL. The secret of the text is to be close to the topic. So, no more gossip, let's go straight to the following, and I'm sure you'll benefit from this article on designing scripting methods for automatic monitoring from MySQL synchronization. Script design thinking

  2022-06-01 18:43:53 Views: 219
• 

  Get the execution plan method-- ORACLE AUTOTRACE

  ORACLE sql traceAUTOTRACE command 1 SET AUTOTRACE OFF this is the default value, that is, turn off Autotrace2 SET AUTOTRACE ON to generate the result set and explain the plan and list statistics

  2022-06-01 18:43:53 Views: 293
• 

  A Fast method for importing mysql data into redis Cache

  This article mainly gives you a brief introduction to the method of quickly importing mysql data into redis cache. You can check the relevant professional terms on the Internet or find some related books to supplement them. We will not dabble here. Let's go straight to the topic. We hope that mysql data can be quickly imported into redis cache method.

  2022-06-01 18:43:53 Views: 299
• 

  A tutorial on proofreading set problems in MySQL

  The following is to understand the MySQL proofreading set problem tutorial, I believe you will benefit a lot after reading, the text is not much in the essence, hope that the MySQL proofreading set problem tutorial this short content is what you want. Proofreading set problem proofreading set is actually the way of data comparison. Proofreading set, there are three kinds

  2022-06-01 18:43:53 Views: 222
• 

  What are the general MySQL backup tools?

  This article mainly introduces what MySQL backup tools generally have, the contents of the articles are carefully selected and edited by the author, with a certain pertinence, the reference significance for everyone is still relatively great, the following with the author to understand what MySQL backup tools generally have. MySQL backup tool

  2022-06-01 18:43:52 Views: 277