Database Administrator

I. REPORT1. Report the physical structure of the target databaseRMAN> REPORT SCHEMA2. REPORT the data files to be backed up. Before performing the BACKUP, you often NEED to obtain the information of the data files to be backed up. Run the report

In Linux, if no prompt is displayed when the listener is started, check whether the content format of your/etc/hosts file is correct. If not, change it; after the change, start the lsncrtl start command again, may prompt TNS-01150 and TNS-01153

There are a lot of useful things in Ubuntu 10.04, and so is the well-known MongoDB system. Related reading: Installing MongoDB on Ubuntu 10.04 As long as sudo apt-get install mongodb should be installed. However, you may find that it cannot be

Oracle has four types of constraint enabling and disabling: enable validate; enable novalidate; disable validate; disable novalidate. Enable constraints: Enable (validate): enable constraints, create indexes, and execute constraints on existing

1. After you create an OCR and VOTE shared disk in the VM, you can use fdisk-l to partition the disk at one vertex. However, you must check whether the raw data is available. Once or twice, it is sometimes available. Sometimes the Raw prompt

Installation environment: RedHat es 5.5 64-bit, 8 GB system memory, 10 Gb swap, Oracle 11G R2 Standard Edition 1. Preparations before Oracle InstallationCheck the packages and install them all:Binutils-2.17.50.0.6Compat-libstdc

This knowledge point is only applicable to Oracle 9i and later versions. To view table data changes, use the SQL statement: select * from user_tab_modifications; The fields in the user_tab_modifications table are as follows. From this table, you can

ORA-16014 error and flash space full Create table user as select name from t_userinfo created yesterdayThe t_userinfo table is very large. After a while, I have been reading and writing the hard disk for three hours.PL/SQL DEVELOPER cannot be

Experiments show that Oracle11gR2 creates objects such as tables and indexes without data. In order to save space, oracle does not allocate segment, but allocates segment only when there is a dml operation, even if the dml is rolled back, the

ORA-01555 ultra-long Query Duration time Symptom:The Alert Log reports a ORA-01555 error, but what is incredible is the ultra-long Query Duration (1382909202 sec ).Mon Oct 28 05:26:42 2013ORA-01555 caused by SQL statement below (Query Duration = 1382

1. Forget the root user logon password for the mysql database. The solution is as follows: A. Reset the password. #/Etc/init. d/mysqld stop # Mysqld_safe -- user = mysql -- skip-grant-tables -- skip-networking & # Mysql-u root mysql Mysql>

Premise nagging: I just learned mysql and want to go home and play on my own virtual machine. As a result, mysql immediately gave me a question and refused to connect to the root user. First of all, I patiently searched for a solution on the

First, download the database you need to install.Second, configure your yum source. If it is CentOS, you do not need to configure the yum source.Third: Put the mysql-xxx.tar file you downloaded and the script in the/usr/local/src directory.4.

1. InstallDownload the compiled installation package or pre-compiled installation package. Here, use the pre-compiled version. [@ S1.yejr.com ~] # Tar zxf mysql-proxy-0.6.0-linux-rhas4-x86.tar.gz [@ S1.yejr.com ~] # Cd

Operating Environment: CentOS 6.4 64-bit First, create the/ibddir directory and modify the owner of the/ibddir directory and the corresponding group: chown-R mysql: mysql/ibddir Operation 1: Create table 'd _ TF_DATA_AGGREGATION_MYISAM '( 'Strative _

There are three Oracle encryption methods: transparent encryption, password encryption, and dual-mode encryption. By default, Oracle disables the encryption function:RMAN> show all;Configure encryption for database off; # defaultConfigure encryption

MySQL -- Binary log Recently, when I checked the monitoring server, I found that there were as many as 14 GB log files. I checked the information and introduced it as follows: Binary log is a very important part of mysql. It has two main functions:

In MySQL5.5, if you want to modify the size of the ib_logfile (redo log) file, follow these steps: 1. set global innodb_fast_shutdown = 0; Ii. mysqladmin shutdown 3. Modify the innodb_log_file_size parameter value in the my. cnf file. Iv. mv

Because there are Too many online mysql instances, the Too connector connections problem is often encountered. This problem is also the most common problem. The following describes the solutions to this problem based on your own experience. When

Today is. During the database performance tuning process, I suddenly moved to the previous email with the following information: From the log, it is found that there is a row-level exclusive lock contention, resulting in a deadlock. Problem