Database Administrator

This article mainly summarizes the operation tips such as pending operations, shrinking databases, compressing databases, and transferring databases to new users with existing user permissions, checking backup sets, and restoring databases during

7. Change the MySQL directoryThe default data file storage directory of MySQL is/var/lib/mysql. To move the directory to/home/data, perform the following steps:1. Create a data directory under the home DirectoryCd/homeMkdir data2. Stop the MySQL

1. Download the MySQL Installation FileThe following two files are required to install MySQL:MySQL-server-4.0.23-0.i386.rpmMySQL-client-4.0.23-0.i386.rpmOpen this webpage at http://www.mysql.com/downloads/mysql-4.0.html, pull down the webpage to the

Oracle has set up a dedicated apt source server for Ubuntu users. You only need to add a line in/etc/apt/source. list:Deb http://oss.oracle.com/debian unstable main non-freeYou can. Before running the apt-get update command, you must add the public

For PHP programmers, SQLite can quickly build a database development environment and provide a database environment with ease, self-container, no configuration, and no independent services. All data is stored in one file. When MySQL is used as the

Oracle is installed on Linux in the Virtual Machine. Since PL/SQL Developer is used on Windows physical machines to connect to Oracle in the virtual machine,But I don't want to reinstall Oracle on the Physical Machine (too big, no more =. = ).

SCN-based recovery, article 2   1. Check the current SCN to facilitate data loss in the future for restoration: SQL> select current_scn from v $ database;   CURRENT_SCN ----------- 1511297   SQL> select file #, checkpoint_change # from v $ datafile;

As the application complexity increases, database segmentation is constantly refined, resulting in complicated and messy database applications in applications. Most programmers may encounter this situation, and the application needs to connect to

[Oracle @ node1 dbs] $ rman target/ Recovery Manager: Release 10.2.0.1.0-Production on Thu Sep 27 16:37:55 2012 Copyright (c) 1982,200 5, Oracle. All rights reserved. Connected to target database: MYRAC (DBID = 4177338842) RMAN> list backup; Using

An error occurred while creating pfile in your environment today. Environment: OS: 11.2.0.2 RAC, OS: RHEL 5.6 Create pfile, reporting ORA-01565 this is because spfile cannot be found.[Oracle @ 11rac1 ~] $ Sqlplus/as sysdba SQL * Plus: Release 11.2.0.

In the RedHat Linux environment, set to manually start the Oracle 10 Gb Database 1. Modify the file/oracle/product/10.2.0/db_1/bin/dbstart. # Vi/oracle/product/10.2.0/db_1/bin/dbstart Modify the following content: ORACLE_HOME_LISTNER

Oracle creates a user-managed copy database on the same host The following are some steps:1. Back up all data files in the primary database (rau), and back up the control files to the tracking files. (Rau is the primary database ).[Oracle @ source ~]

Today, at, I ran to CICC to check the data and found that the archive of the Library (11gR2 RAC, 4 nodes under AIX6.1) was full recently. I ran to ask the middleware buddy who had arrived in advance, no exception was found ...... It's just a bit

After the jar file of the hive udf udaf udtf function is developed, you must put the jar file into the hive environment. You can add the following three methods: 1. Use the add jar path/test. jar; Method to add The disadvantage of this method is

Clustering factor is one of the parameters used to calculate cost in the CBO optimizer mode in Oracle statistics. It determines whether the current SQL statement is indexed, or full table scan and nested External table connection. In this case, what

Oracle RAC automatic patching Opatch auto 1. Install the latest Optach version.Patch 6880880: OPatch patch of version 11.2.0.3.4 for Oracle software releases 11.2.0.x (release L 2013) 2. Update the Opatch files of gird and oracle users.Unzip p68808

Database performance is an eternal topic, that is, how to use less resources to achieve more efficient performance. The Oracle system parameter RESOURCE_LIMIT is a parameter used to control the user's usage of database resources. It is enabled when

Install the Oracle 11g Database on RHEL 6.3, check the dependency of the package during installation, and find that the pdksh-5.2.14-1.i386.rpm package is missing, while installing the pdksh-5.2.14-1.i386.rpm package, find this package conflicts

Materialized View synchronization count 1. Usage Now we need to synchronize some data in the production database to the Data Warehouse. Considering the cost and convenience, we need to regularly refresh the materialized view for data synchronization.

Preface Every DBA in the Process of database management should inevitably encounter a variety of errors (ORA-1547, ORA-904, ORA-1578 ......). Some errors are often called "classic errors" by Oracle DBAs due to frequent and complex causes ". The ORA-3