PHP

LGWR and affrem, the log writing process synchronously writes REDODATA to the DISK. before writing the DISK, the control is not handed over to the user, and the online logs of the master database may not be used before archiving. LGWR and affrem,

ORACLE uses the ASM storage. When creating a database, the redundant attribute of the disk group uses EXTERN. To change the disk group to NORMAL, perform the following steps: ORACLE uses the ASM storage. When creating a database, the redundant

Reproduction and resolution of error ORA-12545TNS-12545 when using data link Reproduction and resolution of wrong ORA-12545/TNS-12545 when using data link 1. View entries in tnsnames. ora: Linux_dblk = (DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)

ORA-16249 master database down, logicalstandby direct change master database ORA-16249 master database down, logical standby direct change master database ORA-16249 master database down, logical standby direct change master database [Date: 2013-

As required by the project, you must use the latest MySQL5.6 Community version, and use CentOS6.3 as the operating system. The following error is reported during installation: fileusrsharemys As required by the project, you must use the latest MySQL5

Fortunately, starting from Oracle11g, the database can collect object statistics and histograms based on expressions or a group of columns to solve this problem. This new statistic is called Fortunately, starting from Oracle11g, the database can

Oracle evaluates the execution plan with the PGA_AGGREGATE_TARGET parameter, and selects the maximum or minimum memory that can be used in sort, HASH_JOIN, or Bitmap operations. Oracle evaluates the execution plan with the PGA_AGGREGATE_TARGET

The logical standby database fails after the primary database replaces undotablespace in the oracle10gpaa environment. The logical standby database fails after the undo tablespace of the master database is changed in the Oracle 10g locally. The

Development colleagues said that the use of ipvs extension row-to-column application has a problem, the example of the initial use of the extension package reference: www. linuxidc. comLinux2013-10 The developer said there was a problem with the

Note: The database should be supported in the archive mode. 1. Back up the SYSTEMG tablespace [Oracle @ bys001 ~] $ RmantargetRecoveryManager: Release11 Note: The database should be supported in the archive mode. 1. Back up the SYSTEMG tablespace

Xtrabackup is a mysql database backup tool provided by percona. According to the official introduction, this is the only open-source database in the world that can perform hot backup for innodb and xtradb databases. Xtrabackup is a mysql database

In CentOS6.4 environment, the solution of backing up a user database at every night is implemented: using the scheduled task mechanism in linux, the command is crontab; using the exp tool to export the database In the CentOS 6.4 environment, you can

Today just installed Oracle11g, after preparation ready to start the database encountered the following error: SQLgt; startupORA-27154: postwaitcreatefailedORA-27300: Today just installed Oracle 11g, after preparation ready to start the database

When you want to access data in another database table across local Oracle databases, dblink of the remote database must be created in the local database. When you want to access data in another database table across local Oracle databases, dblink

Yesterday, my colleague said that a test database could not be logged on, with PLSQLDeveloper login prompt: ERROR: ORA-00604: erroccurredatrecursivesqllevel1or Yesterday, my colleague said that a test database could not be logged on, with PLSQL

The election plays a very important role in the operation of the replica set. During the election, there is no master node in the replica set, and the client's reading request is unacceptable. The election plays a very important role in the

A single ROWID is often returned for finding a value through a UNIQUE index. If the UNIQUE or PRIMARYKEY constraint exists (it ensures that the statement only accesses a single row), Oracle often implements uniqueness. A single ROWID is often

Use plsql00009.0.6 on Windows 7 (32-bit) to remotely connect to the oracle10.2.0 database in Linux (64-bit. The oracle client used on window is instantcli. Use pl/SQL developer 9.0.6 on Windows 7 (32-bit) to remotely connect to the oracle 10.2.0

1. logon and exit command of RMAN: Method 1: $ rmannocatrman directly enters rman to back up data in non-catalog mode, or do not use nocatalogrman> connect 1. Run the following command to log on and exit RMAN: Method 1: $ rman nocatalog directly

Environment: Oracle10g10.2.0.4onSuSE11 + OracleDataGuard. Note: StandbyDB is read-only on a regular basis every morning for statistics, and then continues synchronization. Environment: Oracle 10g 10.2.0.4 on SuSE 11 + Oracle Data Guard. Note: