Database Administrator

Incremental backup) Incremental backup is much faster than full backup. During Incremental backup, only files modified after the last full or Incremental Backup are backed up. For this reason, Incremental backup takes only a few minutes of full

Collected and sorted out a perfect installation tutorial for Oracle 10 Gb in CenotOS Linux 5. Share your friends! Author: David Young (e4twood@gmail.com) Last Update: 2008-1-10 System Environment: CentOS Linux 5 Final Oracle Enterprise 10g

Before Oracle 11g, the physical Standby database (physical Standby) cannot be opened when applying redo, but can only be mounted. Starting from 11g, when applying redo, the physical standby database can be in read-only mode, which is called Active

RMAN backup is easy to use for Oracle database backup and recovery, with low costs. For non-catalog mode, it is undoubtedly the first choice to embed the RMAN script into the shell script and then use crontab to back up small and medium databases.

1. dump redo description For the Dump redo log example, the [ID 1031381.6] documentation on MOS is described in detail. Dump has two methods: (1) run the 'alter session' command dumpredo header. (2) run the 'alter system dump logfile' command to

Use case First, let's look at an example: There is a user table User (username VARCHAR (5) character set utf8COLLATE utf8_general_ci ); Record ('username'); and ('username '); Select * from User where username = 'username'; two data items are

Environment: Database: 64-bit Oracle10.2.0.1.0 under AIX5.3 TSM5.4: Windows2003 With database: IBM3100 Problem description: 1. The error 3D32B80D occurs in the aix system. As follows: JTXXDBS01:> errpt | more Identifier timestamp t c RESOURCE_NAME

In the work involving database operations, we often encounter equivalent comparisons rather than fuzzy queries for two strings: for example, compare two names to be equal? However, when entering a string into the system, the operator may enter

In order to install Oracle on Windows 7x64, the system tried two days and downloaded several files, prompting various errors, such as unsupported operating system. The final success was recorded. 1. download the latest Oralce 11gR2. Only this

Oracle official documentation: Reserved words and keywordsare identifiers that have special meaning in PL/SQL. You cannot use reserved words as ordinary user-defined identifiers. you can use them as quoted user-defined identifiers, but it is not

I. Windows Environment 1. Change the table. It may be that your account is not allowed to log on remotely, but only on localhost. At this time, you only need to log in to mysql on the computer of localhost, and change the "host" entry in the "user"

Debug a backup script for RMAN today. This script has been used many times before, and there is no problem. When it is executed today, it cannot be used. OS: RedHat 5.8 Database: 11.2.0.3 The error is as follows: RMAN-00571: =========================

Recently, we want to implement a business. We need to query the corresponding data in the Oracle Core database based on the table data in the SQL Server database, and then make statistics in the SQL Server database. therefore, we need to implement

I didn't expect MongoDB to have so many choices for Node. js drivers! I thought for a while! It turns out that in addition to the Driver found on the MongDB official website, there are also a lot of good people who have written several MongoDB

I. Backup Type and other description: 1.1 whether the server will continue to provide service points during Backup: Hot Backup: read/write during Backup is not affected Warm backup: only read operations can be performed during Backup Cold backup:

Oracle Enterprise Manager (Oracle Enterprise controller (OEM) provides a governance service for the distributed environment through a set of Oracle programs. OEM includes a set of DBA tools, a repository, and a graphical console. The OEM console

I started to learn about Oracle, so today I plan to install Oracle 10 Gb. After the installation is complete, test whether the job works normally. During installation, the global database configured is tmt. However, when using SQL Plus to log on,

Content Define Collection type Declare Collection variables Initialize and reference Collection Reference Collection Element Assign a value to Collection Multi-dimensional Collection Compare Collection Collection Method Collection

My machine: AMD64x2 4400 + + 1 GB memoryPhase 1-compilation and installation:1. Download postgresql-9.1.3.tar.bz2 from sqlsql.2, copy the source code to the/usr/src/postgresql-9.1.3.tar.bz2 and cd/usr/src3, decompression: tar xjvf

I installed the Mongodb database in Ubuntu 13.10. Now I want to write down the installation method and the automatic start method: 1. apt-get update Software Library 2. apt-get install mongodb 3. After installation, You need to modify the relevant