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
Simple CDC, the simplest CDC. Here, each CDC table change is captured independently, and there is no need to consider the consistency of data between tables that have primary foreign key reference relationships.1 Environment PreparationSOURCE table: Odi_src. DEPT Target table: Odi_tag. DEPT Configuration topology See the creation and configuration of the ODI studio topology (Oracle) Model Reverse engineerin
Tags: database oracle Standby databases activeA data guard configuration consists of a production library and one or more standby databases, in the data guard configuration, both the primary and standby environments can be either RAC or standalone.This article mainly introdu
The failover of Oracle Data Guard was described in both previous articles, but there was no systematic explanation, so in this paper, DG's failover is described in a systematic note.
The processing of failover redo under physical data Guard
http://www.cndba.cn/Dave/article/
move datafile '/u01/app/oracle/oradata/cdb/pdb/pdb_users01.dbf ' to '/u01/app/pdb_user01.dbf ';Database altered.Sql> Select Name,status from V$datafile where file#=10;NAME STATUS-------------------------------------------------------------------------------- -------/U01/APP/PDB_USER01.DBF ONLINESuccess!Summary: Although Oracle 12c log files are shared, CDB and e
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.