data guard oracle 11g step by step

in the Oracle Data Guard configuration. See ' performance Versus Protection in Maximum availability Mode ' For information about the Redo transport settings NEC Essary to support Maximum availability and associated trade-offs. Transactions on the primary is considered protected as soon as Oracle

[Oracle] Data Guard series (6)-role conversionThe core function of DG is to provide high-availability Disaster Tolerance. Therefore, the role conversion content described in this section is the most important part of DG. Role Switching between master and slave databases of DG is divided into the following two types: 1) SwitchoverSwithchover refers to role switchi

EnvironmentOn servers 192.168.1.89 and 90, the operating system is linux Red Hat as 5.2, Oracle 10.2.0.4 is installed, and a single instance database webdb is created respectively.Configure the Data Guard environment with the webdb Of the 89 database as the master database and the slave database of the 90 database as the backup database. Procedure for creating

Oracle is the first step in database learning: database installation, and oracle 1. Local oracle Server 1. to install the oracle server, you can download the server that matches your computer on the official oracle website. Gene

Oracle Data Guard (2) Physical Standby 1. check whether the Primary database is archivelog mode SQL> select log_mode from v $ database; if the result is not "ARCHIVELOG", run the following command: SQL> shutdown immediate; SQL> startup mount; SQL> alter database archivelog; SQL> alter database open; 2. check whether the Primary database is in force logging mode S

Oracle 11gR2 Database and Active Data Guard migration case, 11gr2guard The customer's core system is composed of an Oracle Database 11.2.0.3.4 single machine and an Active Data Guard, which run on two PC servers respectively. The

/emctl start dbconsole # start the Enterprise Manager. After this line is added, you will find that startup is very slow! This is because EM is slow to start. Of course, you can also add iSQL startup after this line:Isqlplusctl start(4) Of course, we recommend that you put the opposite code (stop) in the same position in the dbshut script!4. How to start multiple databases in LINUXAfter you have mastered the preceding manual startup method, to implement LINUX auto-start, you actually need to kno

The first time Oracle 11g R2 Active Data guard is configured today, after physical standby database is created with rman,The following error occurs when you try to open standby in read only mode: SQL> alter database open read only;Alter database open read only*Error at line 1:ORA-10458: standby database requires recove

Oracle Database Change and backup database step tutorial, oracle backup tutorialOracle Database Change 1. Stop the Application Middleware involved/lock the oracle user alter user GWM_BL_UAT account lock View select username, account_status from dba_users where username = 'gwm _ BL_UAT '; 2. use plsql tool-session kill

Oracle Data Guard is an important configuration parameter. Oracle Data Guard provides one or more backup databases for the production database (a copy of the database ), to ensure that data