Database Administrator

Configure RMAN to delete archive logs that have been applied to the standby Database In DataGuard configuration, sometimes we need to use RMAN to automatically delete archive logs that have been applied to the slave database from FRA. When the

MySQL replication on Ubuntu12.04 I. Introduction MySQL Replication is based on the binnary logging mechanism to synchronize data between the master and slave. Both mechanism, configuration, and operation and maintenance are much simpler and more

After Oracle 11gR2 RAC is restarted, only one node can be started. Problem Background: After the normal deployment of Oracle 11gR2 RAC is complete, perform the two-node restart operation to find that the cluster resources of one of the nodes cannot

Delay Section Function of Oracle 11gR2 In versions earlier than 11gR2, when creating a table, the segment space is automatically allocated, which has several drawbacks: 1. space needs to be allocated during initial table creation, which naturally

Export of Oracle 10g Data Pump Partition Table In Oracle 10 Gb, Data Pump supports local export/import of Partition Table partitions, but NET_LINK does not support partition tables. The following are some export experiments. Local export: C: \ Users

Oracle ASM errors-ORA-15031, ORA-15014 Oracle ASM errors-ORA-15031, ORA-15014 System Environment: Operating System: AIX 5.3.8 Oracle: Oracle 10gR2 Fault symptom: [Oracle @ aix213 ~] $ Sqlplus/as sysdba SQL * Plus: Release 10.2.0.1.0-Production on

Use mysqlbinlog to restore data based on location or time point MySQL backup generally uses full backup and log backup. For example, a full backup is performed every day and a binary log backup is performed every hour. In this way, you can use full

Implementation of udf row_number in Hive and problems encountered Add row_number for each piece of hive data. First, add the row number. You must consider that the data must be put in a reduce for execution. Code first Package xx. xxxxx. hive.

MySQL Data Types Note: The following content is applicable to MySQL and later versions. MySQL has many data types. Selecting the correct data type is crucial for achieving high performance. This article is based on some blogs I have seen on the

[MongoDB] Download the mongoDB, mongodbdownload First open the broswer and type the following url in the address bar. Http://www.mongodb.com/ Then you will view the next page. Click the download mongodb button, and then register a

SQL advanced (2), SQLSQL advanced (2) if at least one keyword of SQL INNER JOIN exists in the table, the INNER JOIN keyword returns the row.Inner join keyword syntax SELECT column_name(s)FROM table_name1INNER JOIN table_name2 ON

Simple use of stored procedures, simple use of stored procedures Create a stored procedure: USE [ais20140425092531]GO/***** Object: StoredProcedure [dbo]. [HBSH_MS_BillType_in_ofmine] Script Date: 09/01/2014 14:34:24 ******/SET ANSI_NULLS ONGOSET

Multi-path and udev configuration in Suse 11 and udev configuration in suse11 Recently, we deployed Oracle 10g RAC in multiple paths Under SuSe 11 SP3. 10 Gbit/s in SuSe 11 is also a wonderful piece of cake, and even documents are hard to find. Who

Use DbUtils to add, delete, modify, and query the implementation class of the ResultSetHandler interface. In the previous article "use DbUtils to add, delete, modify, and query", we found that when executing the runner. query () line of code, we

Oracle cloud control 12c how to modify the sysman password, 12 csysmanOracle Cloud Control 12c was deployed on a virtual machine a few days ago, and the login password was forgotten. The main reason is that Oracle-related Software provides stronger

Bug 7715339: a logon Failure triggers 'row cache lock' wait, 7715339row Bug 7715339-Logon failures causes "row cache lock" waits-Allow disable of logon delay(Document ID 7715339.8) to the bottomModification time: 2012-7-26 type: PATCHFor this

SQL split string, SQL split Create function [dbo]. [fn_Split](@ SourceSql nvarchar (max), -- source separator string@ StrSeprate varchar (10) -- delimiter)Returns @ temp table (a nvarchar (max ))AsBeginDeclare @ I intSet @ SourceSql = rtrim (ltrim (@

Oracle Database 11g Release 2 Standard Edition and Enterprise Edition Software Downloads, oracle11g Download Oracle Database 11g 2nd Standard Edition and Enterprise Edition Software Microsoft Windows (32-bit) disc 1, disc 2 (2 GB) 1Microsoft Windows

SQL plus rescue data (test), sqlplusIndexed-- Execute plsql scriptDECLARETYPE RowIDTab istable of rowid indexby BINARY_INTEGER; CURSORc1 IS select/* + index (xifenfei ind_xifenfei) */rowidFromchf. xifenfeiWhereobject_id isNOT NULL; R RowIDTab;Rows

Distributed Database New Thinking: Cross-Cloud Platform This is a simple solution that has a long history: using a distributed architecture in the database to quickly return request data. This solution runs database query operations on multiple