Database Administrator

1. Use SQL * plus to move data files SQL>SelectFILE_NAME, ONLINE_STATUSFromDba_data_filesWhereFILE_NAMELike '% Ttb %'; FILE_NAME ONLINE _ Certificate ----------------------------------------------------------------------------------------------

/U01/app/Oracle/product/11.2.0/dbhome_1/root. sh Running Oracle 11g root. sh script... The following environment variables are set: ORACLE_OWNER=Oracle ORACLE_HOME=/U01/app/oracle/product/11.2.0/dbhome_1 Enter the full pathname of the local

A redo log group can contain one or more log members, which should be stored on different disks as disk log images. The same group of Members has the same content, the purpose is to prevent all online logs from being lost due to a disk failure. If

1. Modify the archiveCreate pfile = '/Oracle/pfile0209.ora' from spfile;Srvctl stop database-d orcl 2. Change *. cluster_database in/oracle/pfile. ora to false.Startup mount pfile = '/oracle/pfile0209.ora ';Alter database archivelog;Alter database

Recently, the company has prepared a test machine to install Oracle 11 GB to RedHat AS4, which records Oracle considerations: Oracle open file descriptor 65536 Error modification: ulimit-a first view the relevant parameters, and then modify them

Indexing is a good method for tuning and greatly improving the query speed. However, in addition to creating an index for each field, you can also create an index as follows: 1. Create a joint index for the query condition: Combining all the

My personal experience in configuring a mysql cluster. Installation preparation:1. Required software.Management node:MySQL-Cluster-gpl-management-7.1.9a-1.rhel5.i386.rpmMySQL-Cluster-gpl-tools-7.1.9a-1.rhel4.i386.rpmSQL node:MySQL-Cluster-gpl-server-

Method 1/// Query the record serial number and Add 1Public int RecnoSelect (string strSq1) { // Record serial number Int r = 0; String t = ""; OracleCommand cmd = null; Cmd = new OracleCommand (); Cmd. Connection = conn; Cmd. CommandText =

When Oracle 9i Database is logged on, A ORA-01003 & ORA-01110 message is prompted, which probably means that the data file storage media is corrupt. Startup nomount, normal; Alter database mount, also normal; Alter database open:  Alter database

The following uses PostgreSQL 9.1.2 as an example. You can also refer to the INSTALL file in the package. The procedure is as follows: 1. Download the PostgreSQL source code package, put it in any directory http://www.postgresql.org/ftp/source/v9.1.2

Check the status of the Replica Set and execute rs. status (). Rs. status (){"Set": "set1 ","Date": "Thu Oct 28 2010 10:09:28 GMT + 0800 (CST )","MyState": 2,"Members ":[{"_ Id": 0,"Name": "192.168.95.216: 10000 ","Health": 1,"State": 1,"Uptime": 2

The default "&" in SQL * Plus indicates the substitution variable. That is to say, as long as the symbol appears in the command, SQL * Plus requires you to enter the substitution value. This means that you cannot input a string containing this

1. The following two types can be used in Oracle: 01:Create table newtable as select * from oldtable; // this parameter is used when no new table is created before replication.02:Insert into newtable select * from oldtable; // when a new table

1. [root @ host ~] $ Oracle_HOME/bin/localconfig delete [this step may not be successfully executed, but it will not be affected] 2. [root @ host ~] Rm-rf $ ORACLE_BASE/* [You can manually delete the installation directories and files in oracle] 3.

View All jobs: select * from dba_jobs; Add a JOB with parameters. Method 1: Begin Sys. dbms_job.submit (job =>: job1, What => 'Clare n1 number (6); s2 varchar2 (2000); begin pkg_xnb.prc_all (n1, s2); end ;', Next_date => to_date ('2017-02-16 20:00:00

Table: msg_content Table: msg_contact_person Expected results Key Point Analysis: the difference between the result table and table 1 is that the real name of table 2 is added to the "er" field. Implementation Method: Step 1: Split the fields in

1. access the Internet through Linux: After Red Hat 9 is installed on the Virtual Machine VMware, the network connection problem occurs. Determining IP information for eth0. .. failed; no link present. Check cable? This problem has been fixed for

1. The logminer usage log file stores all the data for database recovery and records every change in the database structure, that is, all DML statements for database operations. The logminer tool can be used to analyze online logs or offline log

The getToken function of SQLite3 is used to determine the Token in the SQL statement and return the length of the Token. Some basic tokens (such as operators and parentheses) are placed in lengthy Switch... case. The judgment on keyword refers to

The following is an example of 10046, which can be used to analyze specific SQL Execution plans and make a record! Set 10046 events for SQL tracking. You can set different tracking levels. Level 0 disables SQL tracing, which is equivalent to SQL