Database Administrator

Amanda (Advanced Maryland Automatic Network Disk archive Advanced Maryland Automatic IC Network Disk ArchiverI have heard of network backup software since I first came into contact with Linux, but I have never used it. When I need to back up data, I

OS environment: The RedHat Linux 2007 Virtual OS installed in Virtual PC 9.0 is a bare operating system and has not been installed with any other software. Mysql version: 5.1.7 ========================================================== ==============

According to a recent user survey by Oracle, open-source software is occupying the installation share of Oracle Database software, and about 60% of IT facilities are using some form of open-source software. The survey conducted by the Independent

I. Check whether the Oracle database is in archive mode:1. select name, log_mode from v $ database;NAME LOG_MODE------------------------------------------QUERY NOARCHIVELOG2. Use the archive log list CommandDatabase log mode No Archive ModeAutomatic

1. Run the following command to check whether the development kit has been installed:Rpm-qa | grep gcc cpp compat-libstdc ++ glibc-devel glibc-kernheaders binutils2. decompress the packageZcat Linux9i_Disk1.cpio.gz | cpio-idmvZcat Linux9i_Disk2.cpio.

The principle of replacing the cryptographic algorithm is to use the replacement method for encryption, that is, replacing characters in plain text with other characters to form the ciphertext. For example, the plaintext letters a, B, c, and d are

Directory: Pg_buffercachePgfincorePg_prewarmDstatLinux ftoolsUse pg_prewarm to pre-load the relationship/index:Pgfincore output:How to refresh the relationship/index in the operating system cache?Use the range Function of pg_prewarm to pre-load

Automatic Memory Management type Automatic Memory Management: New Features of Oracle 11g, allowing the database to fully automatically manage memory SGA and PGA Components Automatic shared memory management: If this option is selected, SGA can be

Installation and introductionImplementation of backup and RestorationFull + incremental + binary log backup and Restoration#####################################I. Installation and introduction 1. IntroductionXtrabackup is a mysql database backup

Use SSH or XShell to access remote Linux. The SSH logon interface is as follows: The Host Name is the IP address of the remote server. User Name is a User Name of the server. The default port number is 22. You can enter the server password after

When using mysqldump to back up MySQL, the backup file is a text file in SQL format, which consists of a series of create table and insert statements. When restoring, you only need to use the SQL file as the input of the mysql program, as shown

Mysql uses the InnoDB Storage engine by default from 5.5. to use the InnoDB Storage engine, you must add the compilation parameters when compiling and installing mysql. The compilation parameters of different versions are also slightly different,

Today is. Due to the analysis of deadlock, writing RAC was delayed. Today, I will write an article about the disk management log voting in RAC. Record it here.Votedisk is created because of split-brain caused by network. The voting disk is stored in

O & M Engineers deployed a set of Oracle (Database not built) on an IBM P750 (AIX6.1), allowing me to perform a disaster tolerance for a commercial database with its DG. I deployed the DG following the normal steps. 1. Start log recovery in the

8.3.2Dropping Tablespaces and Deleting Datafiles8.3.2 Delete Tablespaces and data files When you delete one or moredatafiles or drop one or more tablespaces in the primary database, you also need to delete the corresponding datafiles to the standby

There are many ways to view execution plans. I will introduce them one by one in my blog in the future. This article describes the first method. You can use the explain plan command to view the execution plan. 1. log on to the database with an hr

Operating System: 64-bit Linux RedHat 6.3 Environment preparations for installing Oracle 12C 1. Install the dependency package Binutils-2.20.51.0.2-5.11.el6 (x86_64)Compat-libcap1-1.10-1 (x86_64)Compat-libstdc ++-33-3.2.3-69.el6

Building Database Clone objects is a common daily O & M requirement. During actual development and testing, you often need to quickly copy a database environment containing business data. Previously, we have introduced how to use the RMAN Duplicate

1. Order During the historical data transfer-out test, through continuous optimization, including SQL adjustment and database adjustment, we can see from AWR that it is basically difficult to improve performance, therefore, we are prepared to try

In Oracle 10 Gb database applications, the UNDO tablespace is too large, leading to insufficient disk space and crash. After analyzing the problem, the main reasons for the problem are summarized as follows: 1. There is a large volume of