Database Administrator

Oracle obtains the number of weeks and the start and end dates of each week. -- Obtain the start date and end date of the week of the last year, starting from Sunday.Select'20140901' | Sunday. the_week, decode (sign (Sunday. the_day-saturday.the_day)

Note: Do not use the "create pfile from spfile;" command to create a PFILE when maintaining the RAC environment. The reason is that in the RAC environment, SPFILE is stored in shared storage by default (on bare devices or ASM disk groups ), each

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

1. Previously, the control file was backed up and recovered using the backup control file. (1) backup control file (2) shut down the database and delete the control file. The simulated control file is missing. (3) database startup Error (4)

Renamedg, a tool used to rename an Oracle asm disk group TherenamedgTool enables you to change the name of a cloned disk group. The disk group must be dismounted on all nodes in the cluster before runningrenamedgOn the disk group. renamedgRenames a

Lab requirement: Build a mysql Graphics Management Tool on the server Linux: CentOS 6.5 1. Simple deployment of LAMP Platform # Yum-y install httpd mysql-server php-mysql php-pdo # Rpm-ivh php-mbstring-5.3.3-26.el6.x86_64.rpm // this package is not

Environment] AIX (5300-08), Oracle10g (10.2.0.1.0-64bit) [Goal] Due to the large data volume in the production environment, we want to speed up rman backup. [Method] Start block tracking Operation] SQL> alter database enable block changetracking

Let's take a look at a problem today.Environment Introduction:Gi version: 11.2.0.4.0Database version: 11.2.0.4.0Oracle linux: Linux Server release 6.4RAC dual-node ASM + restart-alone ASMProblem description:When you start the standby database

Environment OS $ Cat/etc/RedHat-releaseRed Hat Enterprise Linux Server release 5.5 (Tikanga)$ Uname-Linux yozhan1.Oracle.com 2.6.18-194. el5 #1 SMP Tue Mar 16 21:52:39 EDT 2010 x86_64 x86_64 x86_64 GNU/Linux Db 2-node rac 1 Oracle Database 11g

Oracle databases have many objects, such as tables, views, indexes, functions, triggers, and stored procedures. Table, the most important object in the database If the data size of a table is large, you can consider the Oracle partition table to

Oracle cursors are divided into explicit and implicit games. Explicit cursors are defined and operated by users and are used to process query results that return multiple rows of SELECT queries; implicit cursor is a SELECT query that is

1. Current database environment:Dual-node Oracle linux 5.4 RACGrid software 11.2.0.4Oracle software 11.2.0.4OPatch Version 11.2.0.3.4   2. Download OPatch  Download 11.2.0.4.1 Patch: 17478514P17478514_112040_Linux-x86-64.zip  According to the psu

If you simply use the following SQL statement, failure may be returned. The cause of failure is that the data table already exists. Create table sales3 (id NUMERIC, sale_date datetime not null)PARTITION by range (TO_DAYS (sale_date ))(PARTITION

Problem description: This prompt appears after Mysql is installed in Ubuntu. Setting mysql-server-5.5 (5.5.27-0ubuntu2)... start: Job failed to startinvoke-rc.d: initscript mysql, Action "start" failed. dpkg: error processing mysql-server-5.5 (--

Error description: When Oracle 10 Gb is installed on CentOS 6.3, the following error occurs: "/lib/i386/libawt. so: libXp. so.6: cannot open shared object file: No such file or directory" Solution Process: Refer to: Installing libXp. so.6: cannot

Accidental data deletion is a "low-level error" that is often encountered by junior O & M personnel. Some experienced veterans sometimes get lost when they are tired and calm ". Once a data file is deleted by mistake, restoring the database with the

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

Oracle redo log is used to record operation entries for database data recovery. To improve efficiency, we recommend that you set up three redo logs for oracle. This article will parse the status of the redo log group and switch between multiple

After the introduction of asmm from 10 Gb, compared with the previous manual adjustment of various memory components, this makes a huge step forward in automatic management. DBA only needs to define sga_target and sga_max_target. Other things are

Linux: CentOS 1. log on to the system as the root user, download postgresql9.3, decompress the package, and enter the decompressed postgresql directory. 2. Compile and install# Pwd#./Configure -- profix =/usr/local/pgsql(An error may occur. Install