Database Administrator

Based on Oracle's dependence on the platform, this article uses the NT platform as an example to describe some features of Oracle on the NT platform, and provides an Oracle System Optimization idea.Currently, Oracle is developing rapidly as a

Regardless of the platform, we must first clarify our goals: 1) execute at every night 2) Full backup of the database, backup control files and archive log files at the same time, and save the backup files to the/u01/app/Oracle/backup/directory.

This article briefly records how to import and export common data involved in PostGIS. 1. Import osm data to PostGIS Osm2pgsql-c-d osm-l-E 4326-S/usr/share/osm2pgsql/default. style xxxxx. osm Here, pay attention to a few parameters. Whether to

DATETIMEType is used when you need to include the date and time information at the same time. MySQL retrieves and displays DATETIME values in 'yyyy-MM-DD HH: MM: ss' format, the supported range is '2017-01-01 00:00:00 'to '2017-12-31 23:59:59 '.

The following error is reported after the backup definition is modified.OB2BARLIST is the correct solution with the library ID. Incorrect:Allocate channel 'dev _ 4' type 'sbt _ tape 'parm' ENV = (OB2BARTYPE = Oracle8, OB2APPNAME = syprd, OB2BARLIST

During exp import, we often encounter the issue of inconsistent warning characters. The following describes how to configure the nls_lang parameter during imp/exp import and export. It is recommended that the configuration of nls_lang be consistent

1 set operation Definition: displays the results of Multiple SQL statements in a logical integrated operation. By default, set operations are sorted by the first column of the First query in ascending order, except for union all: Minus: Get

1. the following error occurs during running, Error = "Unknown output plugin 'mongo '. run'gem search-rd fluent-In in' to find plugins"Search for mongodb plug-insGem search-rd fluent-plugin-mongoExpected result* ** Remote gems ***Fluent-plugin-mongo

If you want to perform one-way MySQL Data Synchronization, read another article: I. Prepare the environmentMaster:Ip: 192.168.211.128Mysql version: 5.0.77 (you can view it by running the command mysqladmin-uroot-p123 version)Slave:Ip: 192.168.211.131

SQL> alter database add logfile thread 1 group5 ('+ data/myrac/onlinelog/myrac1_redolog_group5_01') size 100 m; SQL> alter database add logfile member '+ data/myrac/onlinelog/myrackets redolog_group5_02' to group 5; SQL> alter database add logfile

This document will introduce the following content: 1. Configure master-slave replication for mysql2. Configure semi-sync3. SSL-based Replication4. Copy Filtering5. Master Model I. System Environment Master: 192.168.56.101Slave: 192.168.56.102MySQL-5

1. OS and DB versions DB Version: 9.2.0.6 OS Version: HP-UXiasd5_pb B .11.23 U ia64 0515426764 unlimited-user license2. alert log Thu Oct11 18:14:17 2012 Errors infile/Oracle/product/9.2.0/rdbms/log/ingwdb_ora_17366.trc: ORA-07445: exception

Oracle 11g RAC, internal time is synchronized through the ctss service, during installation, ntpd will be removed by default, using ctss.However, after running for a period of time, it is found that there is a time difference between the oracle

In daily applications, there is often a need for data changes in Audit, or data that needs to be tracked for data synchronization. (The most common applications, such as data synchronization in a data warehouse, need to synchronize data changes to a

(1) Determine whether the Oracle connection is correct 1. Install a client on the local machine and use. net manager to configure the listener. 2. Use plsql to log in with the user name and password (use the normal user role to import and export

Today, when installing Oracle 10g on Windows XP, there was no problem when installing Oracle software, but when DBCA database creation, there was a "ORA-12638: Credential retrieval failed" error. The reason is that Oracle cannot apply operating

Oracle Net trace is used to track or debug oracle connection failures, abnormal disconnection, connection timeout, and other situations. It generates detailed tracking information to analyze and diagnose Oracle Net-related faults. Network debugging

1. What is Trial Recovery? Official explanation: A trial recovery applies redo in a way similar to normal media recovery, but it never writes its changes to disk and it always rolls back its changes. Trial recovery occurs only in memory. Trial

When my colleague retrieved the database, it was Oracle 10 Gb, and the previous deletion method was delete. I don't know how to use trancate. The SCN (System Change Number) is spelled as System Change Number, which is a very important data structure

In Oracle, there are two optional parsing processes for a submitted SQL statement: Hard parsing and soft parsing. A hard parsing requires parsing, creating execution paths, optimizing access plans, and many other steps. hard explanation not only