Database Administrator

Problems with using the yum install command on OEL 5.4 32bit Problems with using the yum install command on OEL 5.4 32bit [Root @ localhost yum. repos. d] # yum install elfutils-libelf-devel-static *Loaded plugins: securitySetting up Install

Oracle Data Pump content = data_only Next, let's look at a test to verify that the data can be restored only after being exported. Even if the table structure has changed, it can restore the corresponding columns, 1) SQL> desc liuwenhe.

Method 1 for modifying schemas in Oracle Because of service requirements, you need to rename one of schemas. You can find two rename methods after Oracle 11.2.0.2. Method 1: Use the import/export method to modify schemas.• Do a user-level export

New feature 3 of Oracle12c -- ASM & Grid, oracle12casm 1. Enhancements to Automatic Storage Management (ASM) 1.1. Flex ASM In a typical Grid Architecture Installation, each node has its own ASM instance running and plays the role of the database

[Oracle] restores all redo logs physically when the database is running. oracleredo Lab environment: OEL5.6 Oracle11.2.0.1 Lab started: Database running status, delete all logs: [Oracle @ itaa test] $ ls Control01.ctl redo01.log sysaux01.dbf undotbs0

Redis _ dictionary and redis dictionaryTwo things you should know before reading this article. First, Redis is a Key-Value database, and second, the dictionary is an abstract data structure that stores Key-Value pairs. It is difficult to guess that

About rman duplicate from active database to build dataguard, rmandataguard For rman duplicate from active database, the actual operation is backup as copy. Many empty blocks will be copied. It is not recommended for those with database data files

[Translated from mos] Do I need to manually set the CLUSTER_DATABASE parameter during dbua upgrade ?, Clusterdatabase Do I need to manually set the CLUSTER_DATABASE parameter when using dbua upgrade?Source:Is Manual Setting Of CLUSTER_DATABASE

[Translated from mos] When the asm disk is specified as FRA, The dbua hang of 11.2.0.3 stays at 11.2.0.3dbua. When the asm disk is specified as FRA, The dbua hang of 11.2.0.3 stays Source:11.2.0.3 DBUA Hangs While Specifying ASM Disk To FRA

Redis master-slave replication complete synchronization and partial re-synchronization process, redis master-slave synchronization process I recently read the master-slave replication section of redis. I have summarized the two Synchronization

When creating a table in an Oracle 11.2 database, the RESULT_CACHE (mode default) ORA-00922: missing or invalid option, invaliddefault The RESULT_CACHE (mode default) ORA-00922: missing or invalid option was encountered when creating tables in

MySQL Optimization-securely shut down MySQL instances and optimized mysql instances Reprinted please indicate the source: http://blog.csdn.net/l1028386804/article/details/46812371Closing Process: 1. initiate shutdown and send a SIGTERM Signal 2.

Query the record set of the Linq able using linq, and query the datatable using Linq. Query a dataset that meets the conditions in a able data set through linq 1. First define the variables of the query field, such as depth String strDepth = query

Be alert to InnoDB and MyISAM Create Hash index traps, innodbmyisamMySql common storage engines InnoDB and MyISAM do not support Hash indexes. Their default indexes are B-Tree. However, if you define the index type as Hash when creating the index,

Install MongoDB and kylin15.05mongodb on Ubuntu Kylin15.05Install MongoDB on Ubuntu Kylin15.05 MongoDB is a typical NoSQL, but it is also said that many people are using it. So I tried to install the database on Ubuntu Kylin. First, go to its

Vertical table sharding and SqlServer vertical When there is too much data in a single table, we can divide the table horizontally. For more information, see SqlServer partition view to achieve horizontal table sharding, which can improve the table

Mysql uses a cursor to delete a stored procedure, mysql cursor BEGINDECLARE hprocessInstanceId bigint DEFAULT 0; -- Historical Process instance idDECLARE hprocessInstanceIdStarttime CHAR default ''; -- Historical Process instance Start TimeDECLARE

Impdp reports error ORA-39083 & ORA-01917, impdp times ora-39083Impdp reports error ORA-39083 & ORA-01917ORA-39083: Object Type OBJECT_GRANT creation failed with error:ORA-01917: the user or role 'hq _ 88 'does not existFailed SQL:Grant alter,

Mongodb Study Notes 09, mongodb Study NotesOverview Shard sharding divides different data into different servers. Model Where: All user operations on mongodb are requested from mongs.Configsvr is used to save a piece of data on which shardHow to

Introduction to set serveroutput on in Oracle, oracleserveroutputDefinition Set serveroutpu on enables oracle to use its own output methodDbms_output.put_line ('xx ');Scope of use Used in PL/SQL command window and SQL PLUSPermanently valid To