Database Administrator

The database file storage location in the default configuration of MySQL installed in Ubuntu is/var/lib/mysql. If you have not mounted/var to a large enough partition, then/var will share the available space with the root directory/in the same

MySQL does not have a flashback mechanism for Oracle. After you execute drop table xxx, this table is permanently deleted. You can only recover from the backup. If you do not have a backup, then you can only cry. This article provides a way of

Analysis and Processing of Oracle jobs not executed Steps: 1) Check the last date, next date/failure times, broken, and check whether the job fails to run multiple times because of the exception or deadlock in the Stored Procedure executed by the

Postgres 9.3 is currently under intensive development. A new feature worth noting in this version is the JSON data type. After reading the new functions for data generation article, let's take a look at the description of the new JSON feature in the

Environment: OEL + Oracle 11.2.0.1 ORACLE_SID = orcl2 Create the following directory: [Root @ DBA2/] $ mkdir/backup[Root @ DBA2/] $ mkdir/backup/0[Root @ DBA2/] $ mkdir/backup/1[Root @ DBA2/] $ mkdir/backup/2[Root @ DBA2/] $ mkdir/backup/3[Root @

The for loop in Oracle is easy to use. However, when a for loop containing the select statement is used, you still find something you didn't pay attention to before. My code is as follows: Declare Val1 date;Val2 date;BeginFor I in (select empno from

The Web Cache Configuration Assistant check failed when installing Oracle 10.2.0.1 grid control in Configuration Assistants (Configuration Detection), prompting a OUI-25031 error, the solution is as follows: The following error is reported: Then,

Recently, in the project, because the system needs to provide the database backup function, after some online searches, I think the simple mysqldump is used. Using mysqldump in Linux to back up a MySQL database as an SQL File Use mysqldump in Linux

Source database RHEL4.5: 192.168.137.199 GLOBAL_NAME = WENDING. LK Oracle_SID = WENDING Clone database RHEL4.5: 192.168.137.200 GLOBAL_NAME = STRM. LK ORACLE_SID = STRM 1. Full backup source database $ Sqlplus '/as sysdba' Write down the SCN before

Write the corresponding backup script rmanbklevel_0.sh rmanbklevel_1.sh rmanbklevel_2.sh[Oracle @ oracle11gR2 scripts] $ pwd/U01/scripts[Oracle @ oracle11gR2 scripts] $ llTotal 44-Rw-r --. 1 oracle oinstall 102 Jul 20 audit. SQL-Rwxr-xr-x. 1 oracle

1. Data Guard master database archive deletion policy: When we set: RMAN> configure archivelog deletion policy to applied on standby; In Maximum Availability and Maximum Performance, when RMAN backs up the archive file and adds delete input, the

Add the MySQL service to the System Service of the server in Linux 1. Understand the MySQL program path MySQL data DIRECTORY:/home/mysql/dataMySQL program Directory:/usr/local/mysql5 2. Modify the MySQL Service Startup Program [Root @ www.bkjia.com ~

In Oracle 11 g2, duplicating a database has two methods: 1. Active database duplication2. Backup-based duplication The advantages of using duplicate for a database are:Test backup and recovery proceduresTest an upgrade to a new release of Oracle

Server: CentOS 6.0Required packages: Installation in order64-bit http://www.nomachine.com/download-package.php? Prod_Id = 1, 3596① Nxclient-3.5.0-7.x86_64.rpm② Nxnode-3.5.0-7.x86_64.rpm③ Nxserver-3.5.0-9.x86_64.rpmClient: Windows 7Package: nxclient-3

Oracle temporary table introduction: In addition to permanent tables, the ORACLE database can also create temporary tables. These temporary tables are used to save the data of a SESSION or the data required in a transaction. When the session exits

Static registration is used before Dynamic Registration of Oracle Listener. The so-called static registration refers to reading listener when an Oracle instance is started. the configuration in ora is then registered to Listener. It has two main

Lab environment, Oracle 11gR2 standalone test data software and database upgrade, operating system Linux6.3Oracle version 11.2.0.1 upgrade package 11.2.0.3After the database software and database are upgraded successfully, the following error is

Recently, my colleagues reported that the database could not perform some data dictionary queries. An error occurs even when you query dba_users. From the error log, all are some error information of the data dictionary, and the user data is OK.

BYS @ bys1> set arraysize 200BYS @ bys1> set autotrace traceonly statBYS @ bys1> select * from test2 order by 3;72465 rows selected.Elapsed: 00:00:00. 57Statistics----------------------------------------------------------1 recursive cballs0 db block

Who determines the number of Hive maps or the number of MAPREDUCE maps? Inputsplit size, how is the inputsplit size calculated? This is the key to adjust the number of maps.Hadoop provides the Inputformat interface to describe the format of input