dba

This article summarizes the database backup process of all possible errors, you can refer to the following. If you do not have a long DBA, the backup of the database some worry, hoping to find a way to ease your backup solution, then this article is

I. Classification of authority: System permissions: The system requires users to use the database permissions. (System permissions are for users). Entity permissions: The access rights of a user to a table or view of another user. (For a table or

Configure mysql+lvs+keeplived to achieve load balancing for MySQL read operations Environment: Test1192.168.46.131master Test2192.168.46.130slave Backup Test Library TEST3 Scheduler 1, installation and configuration keepalived First installs

The simplest type of writing is a fool Oracle_database_linux32.zip is the name of the installation package Configuration is simpler and more simple, so no variables are used #!/bin/bash ################### Yum and rpm ###################

The Oracle 10g version is designed to redesign the operational functions of data entry and output to increase the ability to disconnect and connect in the input or output work. Minor changes to these features can facilitate the operation of the DBA

The function of the query log is to record all the SQL statements sent by the client, that is, to record all operations of the client Log parameter is going to be obsolete, now replace with General_log Open Query Log Feature Mysql> showvariables

When executing a stored procedure, we may experience permission problems defined by rights stored procedures Caller rights stored procedures When a stored procedure is created in a database, the definition permission is the default mode when

Responsibilities related to DBA 1. Install and upgrade database servers (such as Oracle, Microsoft SQL Server), and application tools. 2. Database design System storage solution, and develop future storage requirements plan. 3. Once a developer

server| Recovery | data | database Work is over, this afternoon is free, write an article, may be helpful to everyone: No database system can avoid a crash situation, even if you use a clustered, two-machine hot standby ... It is still not possible

Access to | data | The database has recently written a common database access Class (C #); Supports OLEDB\SQL\ORACLE\ODBC data connections. Provides SYSBASE,DB2 interface support, If there are any mistakes, opinions, suggestions. Please contact me

Oracle This installation step is through my days of practice and reference to other users of the document synthesis, only for the Redhat LINUX 9.0 installed Oracle 8.1.7. I would like to express my heartfelt thanks to those netizens. Step 1: Prepare

There are two ways to create the undo Talespace: (1) Create the undo tablespace when the database is created; (2) created in a database that already exists. Database objects cannot be created in the undo tablespace because this tablespace is

Use the data Studio Administrator to preserve and migrate information during complex database changes Introduction: Do you need to make complex changes to the database? For example, the column is moved to another table while the original data is

Oracle Domestic Oracle Related site name address introduction Oracle China company HTTP://WWW.ORACLE.COM/CN provides the latest product and service introduction. China Oracle user group Http://www.cnoug.org/ORACLE enthusiasts home

Data | Databases as a qualified DBA (database administrator), you need to have a profound knowledge of computer software and hardware, especially the technology within the DBMS. Also have the ability to analyze and solve problems. Give an example.

I. GENERAL principles of database operation and maintenance 1, can not give the database to do things do not give the database, the database only to do data containers. 2, for the database changes must have records, you can roll back. Ii.

This question is the examination authority knowledge Point, the authority divides into two kinds, the system permission and the object permission, this question mainly speaks the system authority, we first comes to understand what is the system

Rebuilding the database (no defragmentation) You can follow these steps to perform a rebuild task that does not defragment disk fragments. 1. Close SQL Anywhere and adaptive Server Anywhere database servers because version 10 of the Dbunload

Oracle's classic Oracle books: Oracle High performance tuning for 9i and 10g by Gavin Powell Book Description There are three parts to tuning a Oracle database:data modeling, SQL code tuning and physical database configuration. A data Model

oracle| Script In a longer period of interaction with Oracle, each DBA, especially some heroes have a variety of scripting tools to complete a variety of purposes, so very convenient and quick to complete the day-to-day work, the following part of