Database Administrator

This is a production database's rman backup shell script, divided into zero-level backup and one-level differential cumulative backup, zero-level backup once a week, and other one-level differential cumulative backup. 1. Zero-level backup shell

The purpose of setting unused is to use the unused flag to delete the unused when the cpu, memory, and other resources are insufficient. After setting the unused column, the column data is not deleted immediately, but hidden physically. The recovery

1. By default, Oracle log files are recorded in the $ ORACLE/rdbms/log directory. [Oracle @ oracle log] $ pwd/Home/oracle/product/10.2.0/db_1/rdbms/log The log file is (alert _ ): [Oracle @ oracle log] $ ll Total 848 -Rw-r -- 1 aaa 962 06-20

Login as: rootRoot@192.168.88.xx's password:Last unsuccessful login: Tue May 15 22:15:03 BEIST 2012 on ssh from 192.168.88.xxLast login: Thu Aug 23 01:27:54 BEIST 2012 on ssh from 192.168.88.xx **************************************** ***************

This is the case: Due to my carelessness, I helped other departments to update some data in batches on October 13, July 30. Who knows that the global update is complete, and I was notified of this problem only on October 10, September 26. They

The developer asked me to set an Oracle 11g sga slightly larger. Therefore, follow the previous 10 Gb memory operation on oracle.[Oracle @ localhost db_1] $ sqlplus/nolog SQL * Plus: Release 11.2.0.1.0 Production on Saturday June 30 13:42:07

Baidu search has many articles about how to add and delete nodes, and this operation does not have much technical content. However, I tested it myself and recorded it for future queries, at the same time, I hope to provide some help to my friends in

The distinct keyword can only be used to filter all records in the query field that are the same (the record set is the same). If you want to specify a field, it does not work. In addition, the distinct keyword is sorted, Which is

Oracle EBS R12.1.1 on Oracle Linux 64 5.7 The dependency package selects only the oracle-validated-1.1.0-14.el5, and no other dependency package verification is performed. 1. All http-related services fail to be verified in the last step. 1.1 run

Environment: Oracle 11.2.0.1.0 RHEL5.3 64bit mysql Server version: 5.5.9 1: Download [ODBC Driver Manager] unionODBC2.2.14, decompress the package, and put it in the/u01/app/tools/unionodbc directory. [Oracle @ wonder tools] $

I learned about the Partition Table Technology in Oracle today. Now I want to save the statement for creating a partition table here! SQL> conn system/windows @ studyConnected. SQL> create tablespace test datafile 'd: \ oracle \ product \ 10.2.0 \

Currently, ASM instances are widely used in both rac and single-instance database environments. This article mainly introduces the management of ASM instances in Oracle 11.2.0.3, including the following:1: view the status of the ASM disk and disk

What is the maximum storage space supported by a single mysql table? In fact, this problem has to be split into two problems. The first is the size of a single file supported by the file system used by the operating system, for example: Linux

In view of the problem that DBCP is directly used for JDBC connections, I made a simple example. All resources are from the Internet. It does not need any Web Container, but is a simple console

Recently, after Oracle Developer Suite has been installed, you cannot log on to the system, enter an account logon error: ORA-12154: TNS: failed to parse the specified connection identifier. Generally, this is because the configuration file does

I. environment required The IP addresses of MYSQL services installed on both virtual machines are 192.168.1.1 192.168.1.2. 2. The procedure is as follows; Virtual Server 1 [Root @ localhost ~] # Yum install mysql-server-y [Root @ localhost ~] #

1. ORA-01403 in Stored Procedure: no data found Error In the stored procedure, select field name into variable from table name where .........; An error with ORA-01403: no data found occurs if the query is empty Test Table: Create table TEST_TABLE(T_

Data Integrity Overview 1. entity integrity An object is an object in the world. Every row in RDBMS represents an object. Entity integrity means that every entity can be differentiated. Therefore, entity integrity is generally achieved through

Rename a data file If the primary database re-commands one or more data files, the modification will not be automatically transmitted to the standby database. If you want to make standby and data files consistent with primary, you can only manually

After the page is not operated for a long time, the program will report an error when the page is operated again. The exception is as follows:   Com. mysql. jdbc. exceptions. jdbc4.CommunicationsException: Communications link failure Thelast packet