Oracle

Today, a bug was found in the data pump import operation. The previous article recorded the phenomenon of the problem, and this one continues to be studied in depth. The previous article has described the problem, and it is difficult to reproduce

Briefly describe the process of adding a node in the Oracle 10203 for Solaris SPARC Dual-node environment. Shared storage is already configured on a third node, which focuses on the configuration on the operating system and on Oracle. This article

With Oracle's standby technology, a single-instance database can be upgraded to a RAC database. This approach can effectively reduce the downtime for single instance migration to the RAC environment. This article describes the switchover process of

According to Oracle's documentation, the data pump in different ways to export imports, performance can be significantly different, this time just have the opportunity to test, migration table space, direct path, external table, and database chain

First, the concept Tablespace: is a logical collection of one or more data files Table Space Logical Storage objects: Permanent segment--> such as tables and indexes Temporary segment--> such as temporary table data and sorted segments Rollback

Oracle upgrades from 10g to 11g detailed steps database old version: 10.2.0.4 Database new version: 11.2.0.2 OS Version: Solaris 10 Reference Documentation: Complete checklist for Manual upgrades to 11GR2 [ID 837570.1] Part I-Installing 11GR2

Change the Oracle 11g archive mode on the Win7, describing the errors that may be encountered, as well as the original purpose of writing this blog in order for other channels to avoid the same error, or how to solve the same error guidance, because

Rman is a physical-structured backup based on data block backup, supporting the recovery operation with online redolog and archive Redolog, and is Oracle's recommended backup recovery tool. The data imp/exp is a logical structure based import

1. Main Library Broker Configuration 1) Query Switchover status Sql> select Database_role,switchover_status from V$database; Database_role Switchover_status ---------------- -------------------- PRIMARY to STANDBY 2) Query Dg_broker_start

1, the function of the data dictionary The data dictionary records the system Information of the data, which is a collection of read-only tables and views. The owner of the data dictionary is the SYS user, and it is saved in the system table space.

Kill session is one of the things that DBAs often encounter. If you kill a session that should not kill, it is destructive, so avoid such an error as much as possible. It should also be noted that If the session of Kill belongs to an Oracle

Data block corruption due to hardware failure or operating system failure during Oracle database operation that causes Oracle to not recognize or contain content in Oracle format Failure, this bad block can be divided into media damage and logical

Products: AIX, Oracle Platform: pseries, AIX Version: All Conflicts in memory access now when the process requests more memory than the total physical memory of the system, in order to handle this situation, the system swaps the program and the

The online log file status is active or current indicates that the data modifications that the log contains have not been fully synchronized to the data file, and that the redo record in which the instance will need to be read repeats itself, so if

Sql*loader principle Sql*loader is a tool provided by Oracle for data loading, it is more suitable for business analysis type database (Data Warehouse), can handle multiple format flat files, bulk data loading is more efficient than traditional

There is a need to transfer a record of a business table before a point in time to its history table. If the current business table is not based on the partition table settings for this business point in time, it can only insert and delete

A backup is the preservation of the data information in the database, while recovery restores the backed-up database information to the database system. The backup type of the database There are 3 standard forms of Backup for Oracle databases:

Oracle, platform, Linux, database, Archive,sql Operating system: Linux Redhat 4.7 oracle:10.2.0.1 Main Library: ORCL_PD Prepare library: LGDG A. Logical standby creation Process 1. Create Physical standby Specific reference: Oracle Data

Oracle Data Guard Linux Platform Physical Standby Build example Data Guard Environment: Operating system: Redhat 4.7 Primary database: IP address: 10.85.10.1. Database SID:ORCL Db_unique_name:orcl_pd Standby database: IP Address: 10.85.10.2

Related commands The main use of the article three commands, here to introduce a separate: Export: Back up the data in the database into a binary system file, it has three modes: User mode, table mode, entire database schema. can also be divided