NAV: SLTechnology News&Howtos > Database >

• 

  Duplicate Construction of Oracle 11G DG

  DG builds RMAN Duplicate environment for 1.DG: IP DB_NAME DB_UNIQUE_NAME ORACLE_SID DB PORT main library: 192.168.1.69 hsidb hsidbp

  2022-06-01 07:07:25 Views: 273
• 

  Ora-00030:User session ID does not exists

  RAC two nodes, one of which suddenly appears log file sync waiting, and is a fixed number of replies. The reply does not end, so delete it manually: select 'alter system kill session''|

  2022-06-01 07:07:25 Views: 205
• 

  MYSQL query data sort data and grouped data

  In the process of mysql query, data can be filtered, sorted and grouped. Examples of sorted data and grouped data are described below. 1. Use ORDER BY select * from to sort the data.

  2022-06-01 07:07:24 Views: 300
• 

  Access denied; you need (at least one of) the PROCESS privilege (s)

  Encountered an error while exporting a friend's database, as follows: click (here) to collapse or open [root@iZ252affh68Z ~] # innobackupex-- defaults-file=/etc/my.cnf--

  2022-06-01 07:07:24 Views: 255
• 

  Oracle 12C RMAN Duplicating Tablespaces Within a PDB

  The tablespace operation on PDB in CDB using RMAN replication is as follows. Check the parameter file, data file, online log file, control file, archive log file storage directory of the source RAC CDB (jy) SQL > show parameter spfil

  2022-06-01 07:07:24 Views: 258
• 

  Percona MySQL 5.6Primary replication environment error & quot;Got fatal error 1236 from master.."

  Percona MySQL 5.6Primary replication environment error: mysql > show slave status\ Gateway * 1. Row *

  2022-06-01 07:07:24 Views: 217
• 

  AWR can not automatically generate snapshot solution

  AWR cannot automatically generate snapshot solution description: after the RAC archive is full, AWR cannot automatically generate a snapshot. The principle should be caused by MMON HANG, so the problem was solved after trying to restart MMON. ; MMON HANG solution 1) restart mm

  2022-06-01 07:07:23 Views: 244
• 

  MySQL usage

  The following error was found when connecting to MySQL remotely: java.sql.SQLException: null, message from server: "Host '192.168.30.23' is not allo

  2022-06-01 07:07:22 Views: 206
• 

  CLion 2019 for Mac (C and C + + IDE Smart Code Editor)

  CLion 2019 for Mac is a cross-platform IDE intelligent code editor designed for the development of C and C++. The CLion Mac version is designed on the basis of IntelliJ and contains many intelligent features to improve developer productivity. This kind of power

  2022-06-01 07:07:22 Views: 207
• 

  Mysqlbinlog's flashback tool binlog2sql

  Settings for binlog in my.cnf binlog_format = row binlog format must be row mode binlog_row_image = full must be full default is fu

  2022-06-01 07:07:20 Views: 271
• 

  [GP] Greenplum installation

  Configure system information to prepare for the installation of Greenplum 1.Greenplum Cluster introduction here uses a master,3 segment cluster, the ip is 192.168.6.119 master192.168.6.120

  2022-06-01 07:07:20 Views: 207
• 

  Partition of MySQL (2)

  Partition clipping using explain partitions can show whether partition clipping has been carried out. MySQL > drop table t2persQuery OK, 0 rows affected (2.90 sec) mysql

  2022-06-01 07:07:20 Views: 247
• 

  Oracle manual incomplete recovery (1): use the current control file

  Experimental environment operating system: CentOS 7.1database: Oracle 11.2.0.4 directory example 1: recovery based on SCN or point in time-restore mistakenly deleted at a certain time in the past example 2: the current log group is damaged, resulting in a database crash example 3: archive log

  2022-06-01 07:07:19 Views: 261
• 

  The uuid () function and uuid_short () function obtained by MySQL's server_uuid

  1. Uuid () function mysql > select uuid (), uuid (); +

  2022-06-01 07:07:19 Views: 282
• 

  Thoughts on deleting a large amount of data-1

  In a recent article about deleting columns from a table, I left an open question. What should / might you do after deleting columns? Because deleting columns is just a special case of "mass deletions". In this article, I plan to lay the foundation for how we think about "mass deletions" and the consequences.

  2022-06-01 07:07:19 Views: 229
• 

  [giant sequoia database Sequoiadb] what scenarios are lzw and snappy compression applied respectively?

  [problem description] which scenarios are suitable for lzw and snappy compression respectively? [solution] the snappy compression algorithm is to compress a single record, and the repeated reading of the data inside the record directly affects the compression ratio. Therefore, when the internal data of the record is highly repeated, such as every

  2022-06-01 07:07:19 Views: 216
• 

  Problems where a single instance of oracle rac cannot generate an awr report

  When my colleague generated a performance report on the rac cluster, he found that one instance of the rac cluster did not generate an awr snapshot, and the other instance snapshot was normal. The following are the specific processing steps. Instance 1 did not generate awr snapshot SQL > select SNAP_ID,END_INTERV

  2022-06-01 07:07:18 Views: 260
• 

  The use of the repair tool DBVERIFY

  The use of http://blog.csdn.net/leshami/article/details/6530890DBVERIFY tools Or is caused by hardware failure or operating system failure during the operation of Oracle database

  2022-06-01 07:07:18 Views: 270
• 

  Error 1270 mysql Master-Slave

  Author: Henan-Lao Song (Zhiqiang) link: https://zhuanlan.zhihu.com/p/26224566 Source: Zhihu copyright belongs to the author. Commercial reprint please contact the author for authorization, non-commercial reprint please indicate the source. Phenomenon: mysql

  2022-06-01 07:07:18 Views: 278
• 

  Relearn the logs in the MySQL database 10:MySQL

  This article is transferred from the Internet. This series of articles will be sorted out in my "Java interview Guide" warehouse on GitHub. For more wonderful content, please go to my warehouse to check out https://github.com/h3pl/Java-Tutorial if you like.

  2022-06-01 07:07:18 Views: 279