Database Administrator

This article describes in detail the initial settings after installing the MySQL database in Ubuntu.1. It should be easy to install MySQL, and I don't think there is much problem in the installation, so I will not talk about it much. Next let's talk

1. Explain the differences between cold backup and hot backup and their respective advantagesAnswer: Hot Backup is applicable to databases in the archive mode. When the database is still in the working state, it is backed up. Cold backup refers to

[Oracle @ test2 ~] $ Sqlplus/nologSQL * Plus: Release 10.2.0.1.0-Production on Sun Jan 21 12:01:35 2007Copyright (c) 1982,200 5, Oracle. All rights reserved.SQL> conn/as sysdbaConnected.SQL> r1 * select program, count (1) from v $ session group by

Just installed linux as 4.The first problem we face now is how to use mysql> [root @ server tmp] rmp-qa | grep mysql to check the current mysql version.I:When I input mysql in the command line, the following error occurs: Can't connect to local

I am not using mysqldump for backup, because it is used to back up the MYSQL database on the server, as long as all files under DATA are copied directly. Install MYSQL in E: \ PHPsetup \ mysql \ data, and store the backup file D: \ beifen \ 1; D: \

Recently I plan to study the Linux bare device, so I tested it in linux to create an Oracle 10g Database Based on the bare device. Follow these steps: I. Partitioning Partition steps are not mentioned. The hard disk is divided into the following

HBase source code analysis-GET operation-to-scan Conversion 1. Let's look at the constructor first. Public Get (byte [] row ){This (row, null );} Public Get (byte [] row, RowLock rowLock ){This. row = row;If (rowLock! = Null ){This. lockId = rowLock.

As the business volume increases, the amount of data to be stored also increases. If all data is stored in a database, it will inevitably increase the performance consumption of the database. This will eventually lead to user unfriendly feelings. In

System: AIXDatabase Version: 10.2.0.3 The following error is reported:Tue Jan 15 04:08:18 2013Errors in file/Oracle/admin/RASDB/udump/rasdb_ora_766202.trc:ORA-00600: internal error code, arguments: [kcbnew_3], [0], [8], [1639086], [], [], [], [], []

I. Cluster Classification1. Category by Purpose(1) High Availability Cluster)(2) Load Balance Cluster)(3) High Performance Computing Cluster)2. Structure-based classification(1) active-standby mode)(2) mutual standby (mutual backup mode)(3)

Today, the customer wants to use Oracle 9.2.0.5, which is no longer supported by aix 6.1, so he has to copy the software from other databases and recompile it. However, you can only create a database manually. I haven't used manual database creation

1. Use the sys account to create a database connection The installation of Oracle 11g will bring a tool called SQL Developer. It has very powerful functions and has never been known before. It also uses plsqldev and navicat to connect to the

Today, we found that the exported tables from Oracle 11gR2 Exp are incomplete, and some non-recorded tables are not exported. I checked it online and said it was caused by the new Deferred Segment Creation of Oracle 11g R2. Check the user_tables

The Oracle9Dialect dialect has been deprecated; use either Oracle9iDialect or Oracle10gDialect insteadThat's because Dialect is undefined. Rewrite the class and register the undefined Dialect,And add it to hibernate. cfg. xml.Org. hibernate. dialect.

Description of statistics in AUTOTRACE: RECURSIVE cballs: RECURSIVE readTo ensure the smooth execution of SQL statements sent by users, Oracle must execute some additional statements. These statements are called recursive reads.For example, if you

RMAN backup refers to the method for backing up data files, control files, archiving logs and spfiles using Recovery Manager. In addition, because RMAN backup is completed by the Target Database server process, when RMAN is used for backup, the

After the RegionServer node is expanded, You need to migrate some of the original Region to the new RegionServer to enable Load Balancing for each RegionServer. To improve the HBase write performance after one node is added, You need to evenly

When you use the dbca command to delete a database instance, for example: We can see that the column "delete database" is gray and cannot be deleted! Some people solve this problem: Windows 7, 10g 10.2.0.4 Find dbca. bat in bin and right-click

Starting from Oracle 10 Gb, Oracle provides new features of Automatic SGA Management (ASMM for short, that is, Automatic Shared Memory Management. The so-called ASMM means that we no longer need to manually set the size of several memory pools such

Eight Important Notes for Data Guard to deploy the physical standby database. These eight points are mainly for DG deployment after 10g R2. ① Set the master database to force logging Mode Idle> select force_logging from v $ database; Idle> alter