Database Administrator

Oracle 11g two nodes RAC build a single instance DG Process Problems and Solutions I used to build a single-instance database of DG, and it was quite simple. Later I came to the company's first project to build a DG for RAC. I was confident that I

The rman backup script in the Oracle database is very practical. The rman backup script in the Oracle database is very practical. Query character sets SQL> select * from nls_database_parameters; NLS_CHARACTERSETAL32UTF8 Character Set is very

Full and incomplete Oracle database recovery and user management Backup Recovery Comparison between full recovery and Incomplete recovery: 1. Full recovery: restores the database to the latest status, including all submitted data changes until the

SQL server calculates the value of a field in the database, removes duplicate data, and SQL server Sometimes, some duplicate data exists in the database, but we want to calculate the value of a field, and we need to remove the duplicate data ,: In

RAC a node database cannot be started: ORA-00600: internal error code, arguments: [4: kg1_lditomicrots], [1], [], [], [], [], [, internalerror The hardware of a customer's RAC node has changed. After the host is restarted, the database instance

Mongodb stores and reads Word documents and mongodbword documents To ensure that printed letters can be restored, You need to record the content of Word letters every time you print a letter. SQL Server can only record the text content of a letter.

A big and comprehensive choice between SQL and functions: Who is a more effective SQL ?, More effective SQL Reprinted please indicate the source: jiq •'s technical Blog Note that the Oracle11g database is discussed here. It is not applicable to SQL

SQL Server trigger and SQL Server trigger Brief Introduction: A trigger is a special stored procedure, which is automatically executed only when a specific event occurs. Stored Procedures and triggers are a collection of SQL statements and flow

Connecting PL/SQL to oracle database and plsqloracle DatabaseConnecting PL/SQL to oracle database 1. Introduction Use pl/SQL to connect to a remote oracle database without installing the oracle database. 2. steps: A) install PL/SQL and the oracle

Oracle Exadata All-in-One and cloud computing applications (I), oracleexadata1. Exadata 1.1 Introduction to Oracle cloud computing As the cloud computing infrastructure continues to mature, more and more enterprises are paying attention to the

Description of PK, NN, UQ, BIN, UN, ZF, and AI fields in mysql workbench, and workbenchuq When using mysql workbench to create a table, the fields include PK, NN, UQ, BIN, UN, ZF, and AI basic field type identifiers. They respectively mean: PK:

Install redis in Windows and redis in Windows The following is a reference to the definition of apsaradb for redis: Redis is a key-value storage system. Similar to Memcached, Memcached supports more storage value types, including string, list, set,

Migration of login accounts and database users in SQL Server, SQL Server 1. Create a login name for SQL Server Authentication and map it to the database. For example, if you create a user [kk] To map to the database [mytest], the database [mytest]

DB2 Client installation + SysBase installation tutorial + SysBase Client installation tutorial, db2sysbase Related DB2 client, SysBase database, SysBase client file resources: http://yunpan.cn/cKKzYYVdgXi4v extract code f27d 1. Install the DB2

8. Basic Redis commands-management-persistence-RDB, redis-rdb1. Redis supports two methods of Persistence: RDB and AOF. It can be used separately or in combination.2. The rdb a and RDB modes are the default persistence methods adopted by Redis,

[Use rman to copy the Database 10 Gb -- clone-1], rman10g -- clone-1 Target Database: jadl0g Replicated result Database: d10g Note: *** the target database and clone result database are on the same host **** 1.

Mysql5.5 multi-instance deployment and mysql5.5 instance deployment To deploy MySQL Databases on multiple instances, follow these steps. 1. mysql multi-instance principle 2. Features of mysql multi-instance 3. mysql multi-instance application

Use sqlprofile to optimize slow SQL statements in goldengate and SQL statements In HP unix, a process is monitored to occupy a high cpu. Later, it was found that the statement execution plan in gg had a problem, resulting in a high cpu. Since the

Mysql_ping () and MYSQL_OPT_RECONNECT MySQL server has gone away "error, mysqlgoneawaySource: http://www.felix021.com/blog/read.php? 2102Yesterday @ Zind found my previous blog (modified), which mentioned mysql_ping and MYSQL_OPT_RECONNECT.The

Oracle displays the user's table names, Table Comments, field names, field comments, whether it is empty, field type, and oracle fields. -- Oracle: view all the table names, Table Comments, field names, field comments of the user, whether the table