dataguard oracle

Oracle Dataguard Introduction First, the basic principle of Dataguard When a transaction makes changes to data in the production database , the oracle database will record this change in an online redo log file. This process of writing logs can be configured in Dataguard

> Select process,pid,status,thread#,sequence# from V$managed_standby where process= ' MRP0 '; ★MRP process is on (if there are no record here, it means MRP isn't on)PROCESS PID STATUS thread# sequence#--------------------------- ---------- ------------------------------------ ---------- ----------MRP0 2898 Applying_log 1 62Sql> Select sequence#, name, applied from V$archived_log where resetlogs_change# = (select resetlogs_change# from V$dat Abase) Order by sequence#;sequence# NAME Applied-------

= ' primary ' setstandby_file_management= ' AUTO ' setlog_archive_config= ' DG _config= (primary,standby) ' Setlog_archive_dest_2= ' service=primarylgwrasyncvalid_for= (online_logfiles,primary_role) db_ Unique_name=primary ' nofilenamecheck;sqlchannelprmy1 ' Altersystemsetlog_ Archive_config= ' dg_config= (primary,standby) ' ";sqlchannelprmy1" Altersystemset log_archive_dest_2= ' service=standbylgwrasyncvalid_for= (ONLINE_LOGFILES,PRIMARY_ROLE) db_unique_name=standby ' ";sqlchannelprmy1" altersy

Label:1. Environmental information:System:Oracle-linux 5.7 Database version:Oracle Database 11g Enterprise Edition Release 11.2.0.3.0-64bit ProductionPL/SQL Release 11.2.0.3.0-productionCORE 11.2.0.3.0 ProductionTNS for Linux:version 11.2.0.3.0-productionNlsrtl Version 11.2.0.3.0-production Main Library: 192.168.12.31 Sid:yoon Db_unique_name:yoonLibrary: 192.168.12.231 Sid:yoon DB_UNIQUE_NAME:YOONDG 2. Check if DG is installed:Sql> SELECT * from v$option where parameter = '

ORACLE11G restores the rman backup of dataguard to the detailed process of standalone oracle in the test environment 1. copy the full backup file 1.1 from the production database to view the parameter file information. RMAN> list backup of spfile; Find the latest backup information from the large list information /Pddata2/oracle/backup/data/ctl_auto/c-3391761643

Get ready:Confirm objects and statements can be standby supportedMake sure that the rows of the tables in the primary library can be uniquely identifiedEnvironment:Operating system: RED HAT LINUX ENTERPRISE 5oracle:11.2.0.1.0PRIMARY:ip:192.168.1.11Sid:testDb_unique_name:testInstallation path:/oracle/oracle/product/11.2.0/dbhome_1Local Archive path:/oracle/oradata

('/oradata/netdata/stredo02.log ') SIZE 50M; ALTER DATABASE ADD STANDBY LOGFILE Group 6 ('/oradata/netdata/stredo03.log ') SIZE 50M; ALTER DATABASE ADD STANDBY LOGFILE Group 7 ('/oradata/netdata/stredo04.log ') SIZE 50M; Note that the size here is consistent with Redolog, a group more than Redolog : Sqlplus/nolog Create SPFile from pfile= '/oradata/netdata/ Standby.ora '; Startup Mount; ALTER DATABASE ADD STANDBY LOGFILE Group 4 ('/oradata/netdata/stredo01.log ') SIZE 50M; ALTER DATABAS

Although there are a lot of Oracle Dataguard configuration tutorials on the web, it's not hard to see that many of them are using Rman duplicate, although this approach is simpler. But in a way, but also misled the beginner, although also can be configured successfully, but only know that they do not know why, the essence of Dataguard did not understand, also not

The Main library parameters are detailed:?Keep all the same db_name in the same data guarddb_name=ora11g?? #为一个数据库指定一个唯一的名称, the parameter will not change once it is specified, unless the DBA actively changes it so that db_unique_namedb_unique_name=ora11g_primary is introduced in oracle?10g???? #定义数据库唯一名称, because the db_name parameter must be the same for the physical database, the logical database must be different for the parameter to determine the

Tags: error in Oracle 11g Dataguard installation1. log_archive_dest_1 parameter not set, archive file is not synchronizedMon Nov 07 17:39:12 2016Using standby_archive_dest parameter default value as Use_db_recovery_file_destMon Nov 07 17:40:12 2016Using standby_archive_dest parameter default value as Use_db_recovery_file_destMon Nov 07 17:41:12 2016Using standby_archive_dest parameter default value as Use_d

Tags:des using files io data for art problem The principle of 1 and Dataguard is dataguard by establishing a primary and standby group to establish its reference relationship. Once standby is created, Dataguard passes the redo of the primary database (PRIMARY) to the standby database and then applies standby in redo to synchronize the database. has two types o

Tags: DG architectureThe Dataguard operation principle is very simple: transfer logs, application logs. Represents the basic architecture of DG650) this.width=650; "Title=" DG. PNG "alt=" wkiol1w-gytxgwmtaafzjosfyge543.jpg "src=" http://s3.51cto.com/wyfs02/M00/70/C6/ Wkiol1w-gytxgwmtaafzjosfyge543.jpg "/> The Log Transport service uploads the log data generated by the main library to the slave library. The app service validates the log da

Tags: dataguard dg rman Backup OracleBuild Oracle DataGuard (using Rman Backup)Operating system: Windows 2008Database: 11.1.0.6I. Information collection1. Configuration information CollectionDescription Host name IP address db_name SID db_unique_name Service_NameMain Library DG1 192.168.0.11 ORCL ORCL orcldg1 ORCLDG1Standby library DG2 192.168.0.22 ORCL ORCL orcl

' and table_name = ' CUSTOMERS '; no rows S Elected4. The sql-apply of a logical repository is performed by a unique identifier of the table, which means that the table must have a primary key or a unique index.Sql> Col owner for A10sql> Col table_name for a30sql> SELECT owner, table_name from Dba_logstdby_not_unique;owner TABLE_NAME----------------------------------------SCOTT Bonusscott Salgradescott T1What if the table does not have a primary KEY or a unique constraint?

Tags: share automatic data environ setting SYN view NET Mem1. Primary library settings Dataguard related parameters 1.1. Force the Primay Library to log in any state SYS@userdata>SelectForce_logging fromv$Database; Force_log--------- NO SYS@userdata>Alter DatabaseForce Logging; Databasealtered. SYS@userdata>SelectForce_logging fromv$Database; Force_log---------YES 1.2. Set the Primay Library in archive mode SYS@userdata>shutdownimmediate; SYS@userdat

Physical Dataguard Maximum Performance mode configuration process Main Library Host EDBJR2P1 Repository Host EDBJR2P2 1. Create the main library [Root@edbjr2p1 ~]# Xhost + Access control disabled, clients can connect to any host [Root@edbjr2p1 ~]# Su-oracle [Oracle@edbjr2p1 ~]$ DBCA The process of building a library is slightly ... Oracle_sid=orcl 2. Mai

Tags: Files information man file processing Drop directory Add method sidBrief: When querying database data, prompt temporary table space exception, error ORA-01157 ORA-01110, after the data file processing, has resolved this fault. Environment: Oracle 11g RAC for Linux 6, library for Dataguard 1. Query the data times wrong, as follows: ERROR:Ora-01157:cannot identify/lock data file 226-see DBWR trace fil

=tongLog_archive_dest_10 stringLog_archive_dest_11 string5. Check disk usage space (sometimes the flashback recovery area cannot write to the file due to insufficient disk space)[Email protected] ~]$ df-thFilesystem Type Size used Avail use% mounted on/dev/sda3 ext3 17G 11G 4.4G 72%//DEV/SDA1 ext3 510M 28M 456M 6%/bootTmpfs tmpfs 1.1G 520M 523M 50%/DEV/SHM[Email protected] ~]$6. Open the Dataguard database correctly (start the primary node database fi

/archivelog/2018_03_04/o1_mf_2_112F9q9qmwy. arcMedia Recovery log/archlog/strac/archivelog/2018_03_04/o1_mf_2_113F9q9qmyd. arcMedia Recovery log/archlog/strac/archivelog/2018_03_04/o1_mf_2_114F9Q9QNCN. arcMedia Recovery waiting for thread 1 sequence 180Fetching gap sequence in thread 1, Gap sequence 180-180Sun Mar 04 16:01:11 2018RFS[6]: Opened log for thread 1 sequence dbid-1759711868 branch 947273412Archived Log entry added for thread 1 sequence RLC 947273412 ID 0x971d6184 dest 2:Media Recover

This paper uses Oracle 11g Dataguard broker Fastfailover Test Oracle 11g Dataguard Fast failover configuration, requires a primary database to turn on the flash back function, flash back to open this article skip. When the flash-back is activated to the Mount state, the primary standby listener do