oracle data guard 12c

The Oracle Data guard 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 the logs to the slave database. The slave database uses logminer to parse the SQL statements executed by the master database from the logs of th

Previously wrote an article by modifying the control file to modify the path of the problem, now use method two through rename to modify the path of the problemExperimental object: Two Linux stand-alone Oracle 12C databases (both large and small versions are consistent), data migration takes a cold backup way.Migration stepsFirst turn off monitoring, and kill the

Oracle Data Guard provides the most effective and comprehensive Data availability, Data protection, and disaster recovery solutions for enterprise databases. It integrates management, monitoring, and automated software infrastructure to create and maintain one or more synchr

Tags: User proof use. com img Note ora ref optionWhat is Data redactionThe data redaction is a new feature of Oracle Database 12c's Advanced security options, and Oracle China translates it as a "compilation" When it comes to this feature, and in the Chinese interface of em12c R3, this function is translated into "

. 3. Insert tablespace Invoke the Data Pump utility to plug the set of tablespaces into the primary database. Redo data will be generated and applied at the standby site to plug the tablespace into the standby database. Call the Data Pump to insert the tablespace to the master database. Then, the slave database will obtain the redo

Oracle 12C new Features-extended data type, in 12c, the size of data types such as VARCHAR2, NAVARCHAR2, and raw are extended from 4K and 2K bytes to 32K bytes, compared to earlier versions. As long as possible, the size of the extended character decreases the use of the LOB

Tags: cold backup Oracle Database Migration 12cExperimental object: Two Linux stand-alone Oracle 12C databases (both large and small versions are consistent), data migration takes a cold backup way. The path of the target machine is inconsistent with the source library and needs to be rebuilt controlfile.Migration 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

DataFile (s) in backup setincluding standby control file in backup setChannel ora_disk_1:starting piece 1 at 2016-11-23 21:20:42Channel ora_disk_1:finished piece 1 at 2016-11-23 21:20:43Piece Handle=/home/oracle/ctlfile.bak tag=tag20161123t212041 comment=noneChannel Ora_disk_1:backup set complete, elapsed time:00:00:01Finished backup at 2016-11-23 21:20:43Rman> Then, when the backup task is finished, on the main library, the control fil

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 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

In 12C, the VARCHAR2,NVARCHAR2 and raw types extend from previous 4K to 32KAfter upgrading to 12C, the parameter max_string_size default value is standard, that is, does not change the size limit of VARCHAR2, NVARCHAR2, and raw data types, and 11g is consistent.sql> Show parameter max_string_sizename TYPE VALUE--------------

Apply before you can change the log files. 1. If the redo application is running, you must cancel the redo application after you change the log file. 2. If the STANDBY_FILE_MANAGEMENT initialization parameter is set to AUTO, change the value to MANUAL. If the STANDBY_FILE_MANAGEMENT initialization parameter is set to AUTO, change it to MANUAL. 3. Add or drop an online redo log file: 3. add or delete online redo log files: Bytes To add an online redo log file, use a SQL statement such as this: A

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

We have provided an overview of the unique features of Oracle 11g R2. At the same time, we also describe the enhancement of the data warehouse performance related to Oracle 11g R2. The following describes the enhanced features of Data guard in

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