Database Administrator

Common ErrorsError 1: Use SID = 'sqcx 'to create an automatic instance RMAN-00569: ==================== error message stack follows ==========================RMAN-00571: ========================================================== =====================

The naming method for Pg XLOG files (REDOLOG) names is defined in the XLogFileName macro, the time series ID, log ID, and segment ID are composed of eight hexadecimal numbers. For example, 000000000000000000008f. # Define XLogFileName(Fname, tli,

After the cluster was last installed, I didn't have time to write a test article (see). Today I wrote an article on the preliminary test, if you still want to know how to handle the ipvs cluster in different situations, you can leave a message to me

ORA-01552: cannot use system rollback segment for... error resolvedFault symptom:Today, the database is not completely restored, but several tables need to be created as the base table for recovery when preparing the environment. When creating a

Today, my colleague asked me to reduce the undo tablespace to the original 40 GB. Previously, the undo tablespace was extended to GB due to developers' needs, and now it needs to be reduced to 40 GB. Although the whole thing is a bit different from

Install three nodes on a set of Oracle 11gr2, but the dm paths of the multipath disks found by the three nodes are inconsistent, and the corresponding dm paths change after the restart: [Root @ db3 ~] # Multipath-l | grep dmMpath2 (3600140000125d8a52

MySQL master-slave synchronization is a mature architecture: advantages:① The query can be performed on the slave server (that is, the READ function we often call) to reduce the pressure on the master server.② Back up data from the master server to

Use sqlldr to import data: 1. Write the control file:Load dataInfile 'e: \ netbu.csv'InsertInto table temp_zhuren_needFields terminated ','Trailing nullcols -- when the table field does not have the corresponding value, it can be blank (space, blank,

I. undo preparation knowledge In the previous article, undo segment is described as follows: Current online Redo and Undo corrupt methods 1.1 When undo_management is set to MENUAL, the SYSTEM rollback segment is used to record undo records to the

ORA-600 [41XX] This error is basically related to UNDO. For more information about ORA-600 parameters, refer to my Blog: ORA-600 parameters description ORA-600 [4193] This error is also related to the UNDO, MOS has a few related articles. I. MOS

Stored procedures are essential tools in database systems. stored procedures are a collection of SQL statements pre-compiled to implement a complex function. I will not talk about its advantages. Let's talk about the problems I encountered. During

When an SQL data import is executed: ORA-14400: The inserted partition keyword is not mapped to any partition The details are as follows: SQL> @ "C: \ Documents ents and Settings \ Administrator \ Desktop \ 0109 new V8BS deployment \ to su hong

The installation of the Oracle RAC database is more complex than that of a standalone database, because the entire installation process involves network, operating system, and storage. Improper configuration of one link may lead to installation

Column value selection, Set cluster, and column chartRemember, the optimizer understands many important features of column data in a table. The most notable is the column value selectivity and the clustering factor of the column.For example, we can

Oracle startup and ShutdownI. startup and shutdown processesStartup: shutdown → nomount (routine startup) → mount → openShutdown: open → mount → nomount → shutdownIi. startup routine (nomount)The startup routine puts the database in the nomount

1. Problem DescriptionThe maintenance personnel reported to the center that the database/dev/fslv00 _ usage rate exceeded 88%. 2. Problem Analysis ProcessAfter investigation, a large number of *. aud files are generated under the minicomputer/Oracle/

There are two methods: one is to transfer controlfile out and modify the database name and then recreate it; the other is to use the nib tool to modify it. Here we will introduce how to modify the nib tool. The tool nib is provided by Oracle 9i and

The focus of this article is "Join clause (join_clause)", rather than table join itself. Content The table and its data used in this article Oracle 11g R1 (11.1) join clause (join_clause) Inner Joins) Cross-join) Outer Join (Outer Joins)

Create or replace trigger emp-- Before indicates the trigger before the operation-- After indicates the trigger after the operation -- Up to 12 triggers can be created for each table-- Before inset-- Before insert for each row-- After insert-- After

In Oracle, various components (listeners, database instances, and various configuration tools) are installed and run with Log and Trace files generated. Before Oracle 11g, the information was scattered in the Oracle component directory. At 11g,