Database Administrator

Crosscheck backup ORA-19554 A ORA-19554 error occurs when a friend executes crosscheck backup in rman.RMAN> crosscheck backup; Using channel ORA_DISK_1Released channel: ORA_DISK_1RMAN-00571: ==========================================================

How to control the access of common users to pdb information in cdb Purpose:Study the permissions required for common users to switch between different PDBs;Study how to restrict a common user to access only information corresponding to a certain

How Does Oracle ASM Add a new disk to a disk? Applicable platform: AIX hp linux win Solaris Applicable versions: all databases 10.1.0.2 to12.1.0.1 Applicable to rac and standalone Take the RAC environment as an example: Assume that Oracle is an

Basic tutorial on getting started with Redis Redis is an open-source, advanced key-value storage perfect solution for building high-performance, scalable Web applications. Redis inherits three main features from its many competitions: The Redis

Knowledge about MySQL database operations in CentOS 6.5 In CentOS 6.5, you can use Shell to modify the initial MySQL password, enable remote logon, and authorize remote logon users. I recently wrote a Shell script for automated deployment. I need to

OGG synchronizes two Oracle databases Here is a simple example to illustrate how goldengate synchronizes two Oracle databases.The content is as follows:1. Configure the database information.2. Install golden gate.3. Configure golden gate.4. Test

ORA-00600 kcratr_nab_less_than_odr In the morning, the Oracle database reported the following error: Successful mount of redo thread 1, with mount id 339694234Database mounted in Exclusive ModeLost write protection disabledCompleted: ALTER DATABASE

Oracle 11g transparent gateway connected to sybase Database I have already compiled two documents about connecting the Oracle transparent gateway to the mysql database and the SQL Server database. I thought that I would not connect to other

Xinxing analyzes several keywords in the database. The first is the candidate keyword. It refers to the candidate keyword of a given link that has one or more attributes with unique identifiers. For example, if a student has an ID card number and a

Oracle group by, oraclegroupby The group by statement is used in combination with the aggregate function to GROUP result sets based on one or more columns.A group by statement is often required for Aggregate functions (such as SUM. SyntaxSELECT

MongoDB V3 & V2 lock performance comparison test and lock basic overview, mongodbv31. mongo lock Overview: Features of each version lock: The current Production Version is 2.6.7 [Production Release (2.6.7)] and the Development Version is 3.0.0-rc7

Poor memory Head 21-JAVA database connection pool DBCP, 21-javadbcp Each request requires a link to the database. Creating a connection to the database usually consumes a relatively large amount of resources and takes a long time to create a

Oracle physical storage structure, oracle physical storage The architecture of the Oracle database analyzes the composition, working process, and how the database manages and organizes data from a certain perspective, including the physical storage

. NET (C #) connection to various databases-highlights,   1. C # connect to AccessProgram code:------------------------------------------------------------------------------- Using System. Data;Using System. Data. OleDb;..String strConnection =

[Oracle] The View INVALID and cboinvalid brought by the CBO version Source: Oracle 11.1.0.7 Target end: Oracle 11.2.0.4 In the CASE of a recent data migration, the status of a VIEW changes from VALID to INVALID after the data migration is completed.

Data room charging system storage process and charging system storage process Some people use the stored procedure to reduce the workload of code in the Process of charging the data center. What are the advantages and disadvantages of the stored

Recognize databases and databases again I haven't summarized the database for a long time. Let's take a look. What is the database used? Let's discuss it with us. I. Introduction Databases are developed from the file management system and are an

After rman incrementally restores the dg gap, the master database adds a new data file, rmangap1) On the standby database, close (MRP)SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;2) On the standby database, obtain the minimum scn

Argument-difference between select count (*) and select count (1),-selectcount Preface: Today, I saw a blog reposted by my colleague titled "The difference between select count (*) and select count (1)", which is due to interest, just like verifying

MySQL MHA introduction and its advantages MHA is the best choice for many enterprises that use MySQL databases for high availability. It is easy to use and powerful, and implements automatic master-slave failover Based on the MySQL replication