Database Administrator

RMAN backup and recovery-full recovery and Incomplete recoveryGlossary: As the name suggests, full recovery means that the index data has not been lost. Incomplete recovery refers to the loss of some data after recovery. They are two recovery

SQL Server 2014 installation Diagram SQL Server 2014 Enterprise Edition, business intelligence edition, and Standard Edition support the following operating systems: Windows Server 2008, Windows Server 2008 R2, Windows Server 2012, and Windows

Install mirror E 11g on Solaris 10 iSCSI 64 bit I went to a client yesterday to install the 11g database, and made a record of the entire installation process and encountered problems. Because the customer cannot remotely connect to the server using

Oracle 11.2.0.2 solve INS-35354 when RAC is installed When installing an Oracle 11.2.0.2 RAC database today, the INS-35354 problem occurs: Because the GI of 11.2.0.2 has been successfully installed, and all the status of the Cluster is normal, this

Oracle 11G R2 replicuard construction in CentOS 5.11 Datagard is a disaster tolerance solution for Oracle Enterprise Edition. It is widely used in enterprises and I will record the setup process for backup.Host Name database version Instance name

Phpmyadmin creates database users (local, any host) and phpmyadmin DatabasesPhpmyadmin User Creation You can use phpmyadmin to create a database user and Set permissions. Both User Creation and permission configuration are simple. Root User It

Mysql Performance Check script-mysql Performance Check script #! /Bin/sh# Ocpyang@126.com Export black = '\ 033 [0m'Export boldblack = '\ 033 [1; 0m'Export red = '\ 033 [31m'Export boldred = '\ 033 [1; 31m'Export green = '\ 033 [32m'Export boldgreen

Data room charging system VB (1)-system analysis, charging system vb First, let's answer two questions: 1. What is the charging system for the IDC room "? 2. What should I do with the data room charging system "? My answer: 1. As the name suggests,

Oracle Database permission management and oracle permission managementPermission management: the default three usernames and passwords in oracle 9: sys change_on_install // the Administrator with the highest permissions: system manager // normal

[Mysql] Common commands-user operations (create, authorize, modify, delete) and mysql user operations Each user in Mysql corresponds to different user addresses and permissions. There are three ways to create a Mysql user: 1. create user 2. grant 3.

SQL statement optimization: optimization of JOIN, LEFT JOIN and RIGHT JOIN statements; sqljoin In database applications, we often need to perform multi-table queries on the database. However, when the data volume is large, multi-table queries have a

Today is, in the database recovery when a long-time violation of the ora-600 [2662] error, the special sorting is as follows: Problem description: The system tablespace is deleted by mistake. The database is restored to the starting state by

Redhat 6.2 installation of the Oracle 11g client and Analysis of problems encountered, oracle11gOracle 11.2.0.1.0 client (32 bit) was installed on Redhat6.2 (64 bit) yesterday. The following are some problems encountered during installation and the

When the database needs to recover the media, in order to ensure that the database can smoothly perform the recovery process, restore the database to the current state. All we need to do is verify! What is verification? Of course, it is to verify

MongoDB basic (5) backup restoration and Export Import, mongodb Export See the official document: MongoDB Backup Methods The original snapshot of the operating system is used for Backup and restoration. After the Backup is successful, the

PostgreSQL tutorial (1): Detailed description of data tables and detailed description of postgresql I. Table definition: For any relational database, tables are the core and basic object units of data storage. Now let's start from here. 1. Create a

Compile and install PostgreSQL and osxpostgresql in Mac OSX Originally, the official installation package was used. However, the installation package will create postgre, which is a bit uncomfortable on the login interface. After searching for a

How to deal with the rapid growth of oracle archive logs, oracle archive logs Oracle archive logs are generally generated by dml statements, so the increase speed should be too frequent by dml. First, query the generation of the following daily

When the system fails, data logs can be used to restore data to solve database faults. As an SQL Server database administrator, it is important to understand the role of data log files and how to use them to solve common database faults. Since the

1. does the ms SQL Server and SQL Server agent service start and run as domain users. \ administrator users are also allowed) If you log on to the local account, the network function is not available and the following error occurs: the process