Database Administrator

Recovery Based on backup control file (unsing backup controlfile) Applicable:Recovery Based on backup control files is applicable to the following situations: the tablespace is accidentally deleted; all control files are damaged.   1. Close the

MySQL 5.0 and later versions support stored procedures, which are consistent, efficient, and secure. MySQL 5.0 and earlier versions do not support stored procedures. However, with the increasingly sophisticated MySQL technology, stored procedures

The following three statements are used to refresh the Oracle cache. Here is a summary. 1)Alter system flush global context Note: For multi-tier architectures such as application servers and data block servers that communicate through the

MongoDB is one of the most popular NoSQL databases today. During the summer vacation, I finally had time to read some articles about it from the MongoDB authoritative guide and NoSQL Fan, below I will briefly summarize some interesting things of

MongoDB (from "humongous") is an open-source document-oriented NoSQL database developed using C ++. The storage format is BSON, and the mode is free, featuring high performance, easy deployment, and easy to use, it is very convenient to store data.

I have contributed a script to monitor the MYSQL process. I hope it will be helpful to you. Function: Monitors the MYSQL process and restarts upon failure. If the MYSQL process fails to be started, an Email notification is sent. The Code is as

Before Oracle 10 Gb, when we connect to the database in SHELL or JDBC, we need to enter the user name and password, and both are in plain text. Starting from 1OGR2, ORACLE provides the wallet tool to log on to the database without entering the user

Preface: When I used Oracle R12's consignment function, I encountered a very troublesome problem: price grabbing. Due to this problem, the consignment function is always unavailable in the company, and the inventory report basically requires them to

Database startup error, ORA-18008: cannot find OUTLN schemaSymptom:Database Version: Oracle 11g r2Hrdb1> startupThe ORACLE routine has been started.Total System Global Area 4392697856 bytesFixed Size 2233616 bytesVariable Size 1090521840

Oracle RAC Load Balancing allows connections initiated from clients to be effectively allocated to instances with low listener load. There are two methods to achieve load balancing on the client. One is to configure the load_balance of the client,

SQL statement to create job scheduling under SQL Server 2000 -- Define job creationDECLARE @ jobid uniqueidentifierEXEC msdb. dbo. sp_add_job@ Job_name = n' job name ',@ Job_id = @ jobid OUTPUT-- Define job stepsDECLARE @ SQL nvarchar (400), @

Today, I encountered a problem when I was doing database restoration. I had two backup sets under the directory. I wanted to specify a backup set for restoration. I checked the information and made a simple experiment record: RMAN> run {2> allocate

1. When installing Oracle, the installation path and Source Path must both be in English. 2. When Oracle JDBC is used in the example, the following conclusions are drawn after the solution is met: Classes12.jar-for Java 1.2 and 1.3Ojdbc14.jar-for

I. Oracle Data Dictionary A data dictionary is a place where Oracle stores database information. It is used to describe data. For example, the Creator information, creation time information, tablespace information, and user access permission

Recently, I joined two project teams, FALABELLA and FM, to support Oracle DB. Because the project is in the development stage, there are always some database replication work. I compared several methods, it seems that the use of EXPDP/IMPDP is not

When Rman Recovers Data, it can restore the control file and spfile with the help of catalog. Today, we have specially configured the catalog Database: 1> Create a tablespace in the catalog Database for catalog Create tablespace rman_ts datafile '/u0

1. Develop form in formbuilder ->From path $ AU_TOP/forms/USDownload TEMPLATE: TEMPLATE. fmb, and change the TEMPLATE Name to STUDENTS. fmb. -> Download all the files in the resource folder under the $ AU_TOP directory. -> Place the preceding

Statement: the answer is a personal understanding of Oracle. 1. Because of a power outage, instance failure has occurred. From what point in the redo log does recovery in and where does it end? A. Current redo log and inactive redo log B. Checkpoint

Today, the partner of Fuzhou University said that our database login password has expired. They cannot log on to the platform now. Hope to be resolved. "ORA-28002: the password will expire in 7 days". Cause: In oracle11g, "default profile" is set by

For most applications, access to hotspot data exists, namely:The Access Frequency of some data in a certain period of time is much higher than that of other data..Common hot data includes "the latest news", "the most popular news", and "movies with