Database Administrator

About the entries parameter of the orapwd command When I read the Oracle official document Administrator's Guide this morning, in the password file section, the entries PARAMETERS OF THE orapwd command are described as follows: This argument

RMAN-06061 WARNING skipping archivelog compromises -- RMAN-06061 Processing-- During routine database backup check, the backup status of a database is completed with errors.-- So I went to the operating system to check and found the following alarms

Common RMAN parameter settings View All RMAN configurationsRMAN> show all; RMAN configuration parameters for database with db_unique_name Oracle007 are:Configure retention policy to recovery window of 7 DAYS; ------ backup files are saved for 7 DAYS

Expdp encountered a ORA-39126 Error Problem description:The Oracle database is RAC of 11.2.0.4 and expdp is performed on one of the nodes. the following error is returned: Estimate in progress using BLOCKS method...ORA-39126: Worker unexpected fatal

OS block size and Oracle block size to find the OS Blocksize I have read similar articles, most of which are about the blocksize of the file system. I don't know if it is related to the Oracle block size. I tried to find that, even if it is a file

MySQL Study Notes _ 5_ SQL language design and writing (on), study notes _ 5_ SQL SQL language design and writing (I) I. SQL statement Classification Data Definition Language (DDL ): Defines and manages data objects, including databases, data

Database and database LearningRelational system Purpose of this chapter:RDBMS query procedureQuery Optimization conceptsBasic methods and technologies Query Optimization classification:Algebra OptimizationPhysical Optimization RDBMS query processing

Mysql partition, mysql table Partition I. Functions of mysql partitions Ii. Mysql partitioning Methods Iii. Mysql partition implementation Master-slave Problems1. Database Backup (Master/Slave database) 2. database load balancing

Effect of add & split partition on global & local index in oracle, oracleadd The partitions of some large tables in the production database are abnormal. You need to perform online operations on the existing tables to add the lost partitions.

RMAN-06061 WARNING skipping archivelog compromises recoverability processing, rmanarchivelog-- RMAN-06061 Processing-- During routine database backup check, the backup status of a database is completed with errors.-- So I went to the operating

Redis learning, redisFeatures of Redis master-slave copy After the slave is connected to the master, slave sends a SYNC command to the master. After the master receives the command, whether it is the first connection established during

SQL Server column-to-row refer, sqlbench Today, we are doing a data presentation. We use column-to-row conversion. There are multiple methods for column-to-row conversion. The feature is one of them, and Povit is a function that is available only

Use the Oracle 11g adrci ips to package an incident, adrciips [Oracle @ rhel63single ~] $ Which adrci/u02/app/oracle/product/11.2.0.4/db_1/bin/adrci [oracle @ rhel63single ~] $ AdrciADRCI: Release 11.2.0.4.0-Production on Sat May 2 22:32:28 2015 ----

Database and database LearningDomain integrity restrictions SQL supports the concept of DOMAIN, and can use the CREATE DOMAIN statement to CREATE a DOMAIN and the integrity constraints that the DOMAIN should meet. [Example 14] CREATE a Gender DOMAIN

Oracle data recovery, oracle Recently, I am confused about how to clear the table data in oracle. 1. Back up the current data first. It is a good habit to back up data. Remember that there must be a backup each time you operate the database. 2.

Database and database LearningDatabase integrity Data correctness and compatibility Data integrity and security are two different conceptsData IntegrityPrevent the database from having non-semantic data, that is, prevent the database from having

Database and database LearningComputer System Security Various Security Measures Established and taken for computer systems to protect hardware, software, and data in computer systems and prevent accidental or malicious damage to the system, data

Solve and analyze the slow MySQL remote access speed and mysql remote access speedEnvironment Introduction:OS: RHEL5.4MySQL: 5.5.10Exception scenarios:The database has been accessed and used in the Intranet of the data center. A foreign node needs

MySQL SQL optimization and mysqlsql OptimizationPreface Some people have reported that the previous articles are too theoretical and lack practical operation details. This article is more practical. Note: This article is based on MySQL. A lot of

PostgreSQL tutorial (17): client commands (1), postgresql tutorial 0. Password File: Before providing other PostgreSQL client commands, we need to first introduce the password file in PostgreSQL. The reason why this file is described in advance is