PHP

There are many ways to create a consumer uard. This article describes one of these methods, applicable to both 10g11g and 10g11g. This article uses the RMANtarget master database and the local auxiliary database to restore data files through local

The OracleDataGuard logical standby database uses a backup of the master database to first create a physical standby database and then convert it to a logical standby database. After that, the master database transmits logs to the slave

Download link: wgetwww. percona. xtrabackup-2.1.2-611 Xtrabackup-2.1.2-611 download link: wget http://www.percona.com/downloads/XtraBackup/XtraBackup-2.1.2/binary/Linux/x86_64/perc Xtrabackup-2.1.2-611 download link:Wget Install the dependent

In the first two articles, we described the backup and recovery solutions for Small and Medium databases using RMANcatalog, and provided all related scripts to simulate OracleDat in a certain vehicle. In the first two articles, we described how

Create a new oracledatabase_name and SID using dbca. You can also learn how to create a table in oracle and insert data through dbca. A tablespace is created by default. Create a new oracle database_name and SID using dbca. You can also learn how to

The so-called parallel execution refers to the physical division of a large serial task (any DML, General DDL) into multiple small parts, which can be processed at the same time. The so-called parallel execution refers to the physical division of a

Enter sqlldr. If no parameters are followed, a simple description of all command line parameters and their default values are displayed. (when you forget some parameters, you can also query them quickly. Enter sqlldr. If no parameters are followed,

To master this technology, you need to clearly understand the path where the session tracking file is stored and the naming rules for generating the tracking file. Otherwise, there is already a production environment with tens of thousands of trc

OracleDataGuard provides one or more slave databases for the production database (a copy of the database) to ensure that data is not available in the master database or when exceptions occur. Oracle Data Guard provides one or more slave databases

RAC: RealApplicationCluster (real application cluster) is widely used. As an oracle Database Cluster Environment, RAC technology has its own set of management functions. RAC: Real Application Cluster (Real Application Cluster) is widely used. As an

This view can be viewed as a logical Standby operation log. If an error occurs, you can view the recent logical Standby operations in this view. By default This view can be viewed as a logical Standby operation log. If an error occurs, you can view

Some DBAs are afraid to delete the REDOLOG in the production database, because they are worried that deleting the redologgroup in the ACTIVE or ACITVE status will cause a database accident. If Some DBAs are afraid to delete the redo log in the

ORA-01017: Invalid Username Password; login denied, SP2-0157: Unable to connect to ORACLE after 3 attempts, exit SQL * Plus ORA-01017: invalid username/password; login denied, SP2-0157: Unable to connect to ORACLE after 3 attempts, exit SQL * Plus

PHP is recommended to operate Oracle databases by using the OCI8 extension. PHP is recommended to operate Oracle databases by using the OCI8 extension. PHP is recommended to operate Oracle databases by using the OCI8 extension. The method for

The modification of Oracle parameters is complex. Some parameters can be modified at the session level, while others must be modified at the system level. Some parameters take effect immediately after modification (no restart is required. The

A Brief Introduction to the Oracle process. SMON: This process is used for data rediscovery. This process is mainly responsible for inspecting the system and cleaning the system, A Brief Introduction to the Oracle process. SMON: This process is

RHEL6.4 _ 64 install a single instance Oracle12cR1 preinstallation dependency package yum-yinstalllibXp.x86_64libXp.i686elfutils-libelf.x86_64elfutil RHEL6.4 _ 64 install a single instance Oracle 12cR1 pre-install dependency package yum-y install

Before assigning the appropriate size to the database with the new automatic memory management feature, you must first find the current amount of memory allocated to SGA and PGA. But it does not mean that sga _ Before assigning the appropriate size

In project development, you always need to view the SQL statements executed in the background, and the mysql database is no exception. Generally, you prefer to use showprocesslist. In project development, you always need to view the SQL statements

DataGuard is a high-availability technology specifically designed for oracle databases launched by oracle. It was called StandbyDtabase before 8i and officially changed its name from 9i to DataGuar. DataGuard is a high-availability technology