Database Administrator

Case study of incomplete records of RAC split-brain logs due to not configured diagwait1. Fault A rac with the CRS version 10.2.0.4. After the server goes DOWN at the second node, the server goes DOWN at the first node.2. CRS log analysis 2.1 2-node

New Features of Oracle 11gR2 relink New Features of Oracle 11gR2 relink Source:Oracle 11gR2 Relink New Feature (Document ID 883299.1) Applicable:Oracle Database-Enterprise Edition-Version 11.2.0.0 to 11.2.0.0 [Release 11.2]Generic UNIX Solution:I)

Trace in SQL Server Preface When talking about tracking, many people think of scenes in the Police film. Similarly, "tracking" is everywhere in our SQL Server database. If we make good use of tracking techniques, in this way, you can perform

Conditions in Oracle databases where a datafile can be dropped Refer to the mos article:Unable to Drop a Datafile From the Tablespace Using Alter Tablespace Command (Document ID 1050261.1) This datafile cannot be dropped because of any of the

SQL Server database startup process details and analysis and solutions to problems that cannot be started Currently, as an excellent RDBMS of Microsoft, the SQL Server database has very few problems when it is started. When we use it at ordinary

A ORA-03262 is reported when an empty datafile is deleted from tablespace Reference: Cannot Drop Empty Datafile From Tablespace ORA-03262 (Document ID 1353029.1) Applicable: Oracle Server-Enterprise Edition-Version: 11.2.0.2 and later [Release: 11.2

Path to mathematics-sas memo (7), path to mathematics-sas memo Show variable name Libname saslib "H: \ sas "; /* Varnum indicates the name of the variable sorted by the observed position. The default value is in alphabetical order */ DataSaslib.

Prepare for the ocp_ SQL topic "DELETE" and prepare for ocp_sqldelete. Original Works are from the blog of "Deep Blue blog". You are welcome to reprint them. Please note the following source when reprinting them. Otherwise, you will be held legally

Summary of methods used by the SQL SERVER database to determine whether an object exists. -- Whether the database existsIf exists (select * from master .. sysdatabases where name = n '')Print 'exists'ElsePrint 'not exists' -- Determines whether the

ORACLE Installation and oracle Installation Statement:Original Works are from the blog of "Deep Blue blog". You are welcome to repost them. Please indicate the source when you repost them. Otherwise, the copyright will be held legally

Vernacular Oracle: Hotspot table optimization summary, vernacular oracle1. Optimize the SQL related to the hotspot table. If the SQL Execution takes too long, it will hold latch for a long time. For statements with a small number of returned results,

Table space that can be transferredOracle2271 There is an important concept for the table space that can be transferred: Self-Contained ).During tablespace transmission, the tablespace set must be self-contained. The self-contained indicates that

Analysis of pub/sub function in Redis, Xinxing redis The pub/sub function is the publish/subscribe function, that is, the publish and subscribe function. In an event-based system, pub/sub is a widely used communication model. It uses events as the

ORACLE 10G Official documentation Demonstration: Search for manual database creation statements, oracle database creation Original Works are from the blog of "Deep Blue blog". You are welcome to reprint them. Please note the following source when

Character Set OverviewA brief overview of the oracle031 Character Set: A character set corresponds to the encoding. 1. Functions and meanings of character setsCharacter encodingUsageDatabase Character Set(1) used to store CHAR, VARCHAR2, CLOB, LONG,

[Translated from mos] How to obtain the growth information of datafile backup, mosdatafile How to obtain the growth information of datafile backup? Source:HOWTO get information about the growth of the datafile backup (Document ID

Import External SQL Server data from MySQL, mysqlsql In the previous blog "MySQL 5.6.22 installation tutorial", we introduced MySQL installation. Today, we will mainly explain how to import External SQL Server data in MySQL. In short, it is how to

[Translated from mos] file # = 0 is damaged in V $ BACKUP_DATAFILE, Source:V $ BACKUP_DATAFILE Shows before uptions for File #0 (Document ID 399113.1) Applicable:Oracle Database-Enterprise Edition-Version 9.2.0.1 to 11.1.0.6 [Release 9.2 to

Know the file # Of datafile and find out which backuppiece the datafile belongs, F:\oracle\product\10.2.0\db_1\BIN>sqlplus / as sysdbaSQL*Plus: Release 10.2.0.4.0 - Production on Mon Feb 23 09:41:48 2015Copyright (c) 1982, 2007, Oracle. All Rights

Know the archived log sequence # And find out which backuppiece the archived log belongs ., F:\oracle\product\10.2.0\db_1\BIN>sqlplus / as sysdbaSQL*Plus: Release 10.2.0.4.0 - Production on Mon Feb 23 08:41:41 2015Copyright (c) 1982, 2007, Oracle.