Database Administrator

System Environment:Operating System: AIX 5300-08Oracle: Oracle 10.2.0.1.0 Error: RMAN> restore datafile 4;Starting restore at 20-MAY-14Allocated channel: ORA_DISK_1Channel ORA_DISK_1: sid = 139 devtype = DISKChannel ORA_DISK_1: starting datafile

The following error message is reported when the customer imports data from imp. IMP-00051: Direct path exported dump file contains illegal column length IMP-00008: unrecognized statement in the export file For the cause and solution of this error,

I can only say that it seems that I have solved this Configure problem, but I still want to recommend that you confirm the input method when you press the Enter key. This is what I felt afterwards. I believe you have already searched the internet.

Heap table Storage: In the Oracle database system, the most common is heap tables. The data storage mode of the heap table is unordered, that is, any DML operation may make the current data block available free space. In consideration of space

Symptom: Reporting PRVF-5646 when installing Oracle grid 11.2.0.3/4: The DNS response time for an unreachable node exceeded "15000" MS on following nodes Solution: 1. Modify the/etc/named. conf file of the DNS server and add the fil "/dev/null";

The latest MySQL 5.6 startup error on RedHat Linux is reported as follows: [Root @ tserver mysql] #/etc/init. d/mysql startStarting MySQL. The server quit without updating PID file (/var/lib/mysql/tserver. pid). [FAILED] Check the error message

Implementation: Use php to save the names of all files in a folder to the MySQL database. Note: enter it as A folder A. If this folder contains another folder B, only files in A are not displayed. The source code is as follows: // Function: Save the

MySQL management-backup and recovery You must be aware of the importance of data. Here we have to briefly introduce the importance of backup: Backup is a means to ensure availability, but it cannot be guaranteed. For scenarios with high data

Environment: VBOX Oracle enterprise linux 5.8 _ X86_64 Oracle database 10.2.0.1.0 Oracle clusterware 10.2.0.1.0 When you re-build a RAC environment, because you do not want to create a new OCR/voting disk shared DISK, you plan to use the shared DISK

Build an MHA Environment Https://code.google.com/p/mysql-master-ha/ // Environment Introduction 1. Host deployment Manager: 10.10.54.154Master: 10.10.54.156Server Load balancer 1: 10.10.54.155 (Backup master) Server Load balancer: 10.10.54.157 2.

Generally reported ORA-00054, it is likely that the object is locked, this error is generally "the resource is busy, but the specified way to obtain resources in NOWAIT, or timeout failure ", the solution is as follows: 1. query which objects are

If you simply use the following SQL statement, failure may be returned. The cause of failure is that the data table already exists. Create table sales3 (id NUMERIC, sale_date datetime not null)PARTITION by range (TO_DAYS (sale_date ))(PARTITION

Sometimes, as the business grows, you need to re-plan the redo log. For example, if there are three groups of existing logs, one member in each group, and each member is 50 MB in size, it is obviously unreasonable for the production database. We

Oracle self-diagnostic tools play a major role in daily performance diagnosis. Since Oracle 8, Oracle has been continuously promoting the development of comprehensive self-diagnostic kits. From the earliest Statspack to the current AWR and ADDM,

Upgrading any software, especially enterprise-level system components, is a very complicated process. The upgrade path, data retention plan, rollback steps, and impact degree of original business functions all require repeated tests and

In the Oracle environment, PL/SQL is the best way for us to implement business logic, and it is also the best language to combine with the Oracle database itself. Using PL/SQL itself can greatly improve our work efficiency. From the very beginning

As the version continues to increase, the role of RMAN as a standard backup tool is constantly enhanced. From the traditional backup and restoration tools in the past to the new environment migration and building of DG, we can see the enhancement of

Massive Data processing is a common requirement for many system developers, sometimes even O & M personnel. Interfaces for loading and storing massive data files, batch data updating, and staged data archiving and deletion are common application

SQL statements are a convenient and confusing language. This is mainly reflected in its set operation features. Update statements are identical regardless of whether the data volume is one or 0.1 billion. However, the actual execution results (or

During RMAN backup, preview is often used to verify the recoverability of the current database, as well as the backup piece, archivelog, and whether the corresponding file exists during restoration. -------------------------------------- Split line -