Database Administrator

When the control file is lost in Oracle, sometimes we can only recreate the control file. The specific syntax is as follows: Create controlfile reuse database "SQUAN" NORESETLOGS ARCHIVELOGMAXLOGFILES 16MAXLOGMEMBERS 3MAXDATAFILES 100MAXINSTANCES 8#

On the ASM instance of 11.2, execute show parameter spfile:[Grid @ rac1 ~] $ Sqlplus/as sysasm SQL * Plus: Release 11.2.0.1.0 Production on Sun MAY 11 15:56:12 2014Copyright (c) 1982,200 9, Oracle. All rights reserved.Connected:Oracle Database 11g

The sequence starts from 0 every morning during Oracle storage. Create or replace procedure seq_resetN NUMBER (10 );Tsql VARCHAR2 (100 );BEGINExecute immediate 'select SQD_LSH.nextval from dual'INTO n;N: =-(n );Tsql: = 'alter sequence SQD_LSH

A customer is concerned about the recovery of logical errors. The solution we recommend to him is to use the flashback Technology on the disaster recovery database. Below is a simple Linux script. #! /Bin/bash Export LOGIN_USER = testExport

The volume installation package specified by Oracle 11gR2 is 10.2, but it is not actually usable. It downloads the 11.1 package, but it still encounters several errors and is modified back and forth ...... If the installation fails and you need to

ORA-00980: synonym translation is no longer valid ORA-00980: synonym conversion is no longer valid Master TOM's explanation of the error: http://asktom.Oracle.com/pls/asktom/f? P = 100: 11: 0: P11_QUESTION_ID: 7095288486502  That means you lost some

MongoDB has been widely used as a NoSQL Database in recent years. More and more enterprises are trying to use MongoDB instead of the original Database. MongoDB also performs well in clusters, sharding, and replication. I will introduce various

1. Create a data directory under the same-level installation directory of MongoDB. The directory structure is as follows: /Data/rs0 /Data/rs1 /Data/rs2 2. Use the command line to start the three instances of mongod, open the three command line

Mongodb does not recommend master-slave replication. We recommend that you create a Replica Set to ensure that one service is down. If there are other services on top, the program runs normally and the data of several services is the same, automatic

RMAN backup can only be performed in Oracle archive mode.Check whether the database is in archive ModeArchive log list Change the database archive ModeShutdown immediateStartup mountAlter database archivelog;Alter database open; View the RMAN backup

+++ 10gR2If the host name is modified and the corresponding information of/etc/hosts is not changed, an error will be reported during database shutdown and startup. [Oracle @ oracle ~] $ Sqlplus/as sysdba SQL * Plus: Release 10.2.0.1.0-Production on

I. Here we mainly use the Oracle-validated package to simplify some configurations for installing the oracle software.2. Install the oracle database software 10.2.0.1.0. 3. Upgrade the oracle database software 10.2.0.2.0. Recommended reading:Install

MySQL 1064 error means that My SQL syntax is incorrect and the specific location of the error is displayed. View the content to be updated and execute new php statements. The php statement is as follows: If (! $ Handle = @ fopen ($ fname, "r")

Error message in ALERT Log: Mon Jan 20 15:03:22 2014Incremental checkpoint up to RBA [0x442f. abd.0], current log tail at RBA [0x442f. 338a. 0]Mon Jan 20 15:08:13 2014Errors in

Archive logs are stored in the following ways: I. ASM Method If the operating systems of Oracle 10G, oracle11g, and oracle 12C are AIX, HPUX, and Linux, the ASM database creation method is generally adopted, especially for oracle 11g and oracle12C,

Problem description: It takes 12 minutes for Oracle to delete 2000 records by using the primary key id. Solution Process: 1. First, check the SQL Execution Plan. The execution plan is normal, and the cost is only 4. The primary key index is used. 2.

1. restore refers to accessing the previously generated backup set, obtaining one or more objects, and then restoring these objects at a location on the disk.Recovery is an actual process that allows a database to be opened at a given time point,

1. You cannot perform Incomplete recovery operations on only a part of the database, because this gives a part of the database a different system change number (SCN) or time point from the rest of the database.2. Use the set command in the run code

I have never been clear about the usage of rman crosschcek and obsolete, and it is a bit confusing. This will have a great impact on the management of rman backup sets and even backups. I will test it in time today, make up for this important link

In the Data Guard environment, Standby Redo Log is a special Log type. We recommend that you configure the Standby Redo Log on the Primary and Standby ports from the latest DG Installation Guide. To put it simply, Standby Redo Log is the online Redo