Database Administrator

This article mainly summarizes the operation tips such as pending operations, shrinking databases, compressing databases, and transferring databases to new users with existing user permissions, checking backup sets, and restoring databases during

In work, we need to use Datastage to import Oracle Data to DB2. We found that IBM's documents are not comprehensive,I asked a lot of people, including my colleagues, such as Lao du, Bryan Zhang, and Robert, to finally connect to Oralce. I just made

For PHP programmers, SQLite can quickly build a database development environment and provide a database environment with ease, self-container, no configuration, and no independent services. All data is stored in one file. When MySQL is used as the

1. Introduction to system environment Oracle Database Server Operating System: RHEL4.8 64-bit, IP: 192.168.12.242 Oracle Database Version: oracle 10g Mysql database server operating system: RHEL 4.8 32-bit, IP: 192.168.5.186 Mysql database version:

SCN-based recovery, article 2   1. Check the current SCN to facilitate data loss in the future for restoration: SQL> select current_scn from v $ database;   CURRENT_SCN ----------- 1511297   SQL> select file #, checkpoint_change # from v $ datafile;

As the application complexity increases, database segmentation is constantly refined, resulting in complicated and messy database applications in applications. Most programmers may encounter this situation, and the application needs to connect to

Sometimes the development of table structure design, whether the table field is empty is too casual, such as id1 = id2, if the field is allowed to be empty, because the Oracle empty value is not equal to the null value, unexpected results may be

[Oracle @ node1 dbs] $ rman target/ Recovery Manager: Release 10.2.0.1.0-Production on Thu Sep 27 16:37:55 2012 Copyright (c) 1982,200 5, Oracle. All rights reserved. Connected to target database: MYRAC (DBID = 4177338842) RMAN> list backup; Using

OUI: Oracle Universal Installer (for details about OUI, refer to google)My system: RedHat enterprise server 6.0My oracle: 10g. 2.1 Graphical installation process using OUI:1) confirm the disk size: u01 5G; swap 400 m;Du-sh/tmp/Df-h 2) install

I. Official Oracle description Oracle Database assigns each datafile two associated file numbers, an absolute file Number and a relative file number, that are used to uniquely identify it  Absolute: Uniquely identifies a datafile in the database.

Some users asked this question: How do I escape the @ symbol in the password during the export operation?Because the default Oracle will parse the strings after the @ symbol as the service name, it will not work without processing.Some enterprises

Oracle uses Incomplete Database-level recovery to solve the logical errors caused by data loss or human error before 10 Gb. After 10 Gb, RMAN introduces a new feature called "tablespace point-in-time recovery", TSPITR for short, which can actually

1. Structure of the SMON_SCN_TIME table The SMON_SCN_TIME table stores the mappings between SCN and Time. This table is maintained by the SMON process. SQL> desc smon_scn_time Name Null? Type ----------------------------------------------------------

Today, when deploying Oracle Summit Demo to a standalone Weblogic, ORA-01005 exceptions are reported, and running in Integrated Weblogic is always normal. The main exception Log is as follows: #### WatchRuleType: LogWatchRule: (SEVERITY = '

To build a WebCenter, you need to build an environment. I plan to write several articles for sharing and recording: database, RCU, Weblogic, WebCenter Portal, WebCenter Content (UCM), and environment configuration. 1. First, you need to install the

Clustering factor is one of the parameters used to calculate cost in the CBO optimizer mode in Oracle statistics. It determines whether the current SQL statement is indexed, or full table scan and nested External table connection. In this case, what

Oracle RAC automatic patching Opatch auto 1. Install the latest Optach version.Patch 6880880: OPatch patch of version 11.2.0.3.4 for Oracle software releases 11.2.0.x (release L 2013) 2. Update the Opatch files of gird and oracle users.Unzip p68808

The slow query log of mysql database is a very important auxiliary log for tuning. However, the log format recorded by mysql by default is not friendly enough to read. This is determined by the mysql Logging rules, capture one log. Although the

Install the Oracle 11g Database on RHEL 6.3, check the dependency of the package during installation, and find that the pdksh-5.2.14-1.i386.rpm package is missing, while installing the pdksh-5.2.14-1.i386.rpm package, find this package conflicts

Content Data Pump provides different export modes to detach different parts of the database. Specify the mode by entering appropriate parameters in the command line. The following are available export modes: Full Export Mode Schema mode Table