NAV: SLTechnology News&Howtos > Database >

• 

  Dealing with the problem of Database error reporting when restoring Database by rman

  Error 1. Open block change tracking in the database, and open it after recovery because there is no error in the file. RMAN > alter database open resetlogs;RMAN-00571: =

  2022-06-01 10:01:10 Views: 207
• 

  [MongoDB Learning Notes 32] MongoDB modifies replica set configuration

  Delete the replica set member spock:PRIMARY > rs.config () {"_ id": "spock", "version": 1

  2022-06-01 10:01:10 Views: 221
• 

  PostgreSQL starts the switching of log sources during recovery

  The log source will be switched directly in XLOG_FROM_ARCHIVE- > XLOG_FROM_STREAM- > XLOG_FROM_ARCHIVE. If there is an error in the reading process, it will switch to another log source. But in the actual implementation process, XLOG

  2022-06-01 10:01:07 Views: 243
• 

  Oracle binds multiple services to a single instance

  Background: in the early stage of the project, two instances were established on one server, and the client configured two connections. Now it is necessary to integrate the two instances into one of the instances, requiring that the configuration of the client not be changed. For example, there are two instances of test,standby2 before integration and only standby2 after integration.

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

  CactiEZi Chinese version V10.1 is an operating system based on CentOS6.0 system and recompiled by integrating Cacti and other related software.

  Server operating environment: operating system: CentOS release 6.8 (Final) Web server software: Apache/2.2.15 (Unix) database system: MySQL 5.1.73 for default CactiEZi Chinese

  2022-06-01 10:01:06 Views: 206
• 

  Principle and Design of Database system-- projection Operation and selection Operation

  Books: principles and Design of Database system (3rd Edition)-- edited by Liao Guoqiong et al. Database version: SQL Server 2005/*select courseNO as course number, lower (coursename) course name, co

  2022-06-01 10:01:06 Views: 296
• 

  Oracle execution plan binding

  Sometimes when we query gv$sql, we can see some details about the operation of different subcursors of the same SQL: selet t.instcorrecidMagi t.sqlnumbergram.childnumbers numbert.planetary hashworthy value.last

  2022-06-01 10:01:06 Views: 214
• 

  Oracle Database 12c DBA Civil Service Manual (8th Edition)-Chapter 5 Development and implementation of applications

  1 adjust the design: best practice 1.1 to do as little work as possible should simplify the process involved in each step of the application. Emphasize the functionality of the application and the ability to meet business performance requirements. 1. Strive to eliminate logical reading in application design. If multiple users need to read the same data, they should save it.

  2022-06-01 10:01:06 Views: 295
• 

  Index optimization series 13-- aggregation optimization of all kinds of partitioned tables

  -- range partition sample drop table range_part_tab purge;-- Note: this partition is a range partition-- example 1create table range_part_tab (id number,de)

  2022-06-01 10:01:06 Views: 269
• 

  Mycat tutorials (2)-- mycat tutorials and slicing methods

  After completing the mycat installation, start an example to familiarize yourself with mycat 1. Server description server name address description mycat server 10.211.55.13mycat middleware server mysql server 10.211.55

  2022-06-01 10:01:02 Views: 234
• 

  The use of ORACLE stored procedure while Loop

  CREATE OR REPLACE PROCEDURE proc_testasi number;BEGINi:=0;while I < 10 LOOPbegini:= I + 1 Matsumi insert I

  2022-06-01 10:01:02 Views: 237
• 

  Bootstrap+jQuery+Thinkphp+Mongodb practical Development Community Exchange website platform

  Background of the course with the popularity of open source projects and nosql databases, more and more websites use bootstrap and jqu.

  2022-06-01 10:01:02 Views: 225
• 

  MySQL basic operation command to create library DDL

  System database: information_schema: virtual database, which mainly stores the information of some database objects in the system, such as user table information, column information, permission information, character information, etc. Informance_schema: mainly stores the database server's

  2022-06-01 10:01:02 Views: 213
• 

  Talk about Using filesort in explain

  Sometimes when you view the execution plan of SQL, you will encounter Using filesort, as follows. MySQL > explain select * from tb1 where col1 = 4 order by col2\ G

  2022-06-01 10:00:58 Views: 238
• 

  3.4-MongoDB replica set building

  * MongoDB replica set (repl set) describes the use of master-slave in earlier versions. One master and one slave is similar to MySQL, but slave is read-only in this architecture. When the master library is down, the slave library cannot be automatically switched to master. Maste has been eliminated.

  2022-06-01 10:00:58 Views: 207
• 

  Learning oracle

  Download oracle URL http://www.oracle.com/technetwork/index.html according to your model choice to download and install different versions, you must first sign up for an oracle account before you can download. The official website EX Edi

  2022-06-01 10:00:28 Views: 286
• 

  Used by dbms_sql to create a generic dynamic sql

  / * calling dbms_sql requires five steps:   1. Open a cursor   2. Analyze the statement to be executed   3. Bind any input variables that may be needed   4. Execute statement   5. Close the cursor * / DECLARE CUR P

  2022-06-01 10:00:20 Views: 271
• 

  Oracle Study-- an error case of ORA-12537 (TNS:connection closed)

  Oracle Study-- ORA-12537 (TNS:connection closed) error case system environment: operating system: RedHat EL55Cluster: Oracle 11gR2 GRIDO

  2022-06-01 10:00:20 Views: 287
• 

  Oracle function

  Single-line functions: single-line functions are mainly divided into the following five categories: character functions, numeric functions, date functions, conversion functions, general functions; character functions UPPER (string | column): return the input string in uppercase; LOWER (string | column): the word to be entered

  2022-06-01 10:00:19 Views: 287
• 

  Mongo aggregate query

  * not indexed * * > var startTime = new Date (); > db.tem

  2022-06-01 10:00:19 Views: 268