dataguard oracle

DG Principle: The host sends the log file to the standby machine, the standby machine executes the log file, this and the host data synchronizes.According to this principle, it is not difficult to deduce the sequence of DG's switch machineShutdown sequence first the host and then the machine, so that the log will not be brokenThe boot sequence is ready for the mainframe, so the goal is to keep the logSpecific stepsShutdown1. Perform on the main libraryShutdown immediate;2. Perform on the standby

Tags: OracleProblem: Dataguard cannot apply redo Log,alert without any error message.Symptom: Oracle RAC node alert has no error message and the other section reports the following errors.Thu Mar 15 15:26:22 2018Error 1017 received logging on to the standby Check, the primary and standby are using a password fileAnd Remote_login_passwordfile is set to SHARED or EXCLUSIVE,And that the SYS password are same i

Tags: Oracle 11g (Bare device Dataguard)Add Standby LogMain Library parameter file:crm.__db_cache_size=8254390272crm.__java_pool_size=33554432crm.__large_pool_size=33554432Crm.__oracle_base= '/u01/app/oracle ' #ORACLE_BASE set from environmentcrm.__pga_aggregate_target=3288334336crm.__sga_target=9865003008Crm.__shared_io_pool_size=0crm.__shared_pool_size=14763950

like ' ora% ';Usernam Sysdb SYSOP------- ----- -----Orasys TRUE FALSE Oraoper FALSE TRUE Create DataguardStandby:orclst--check v$pwfile_usersCol USERNAME format A7Select Username,sysdba,sysoper from v$pwfile_users where USERNAME like ' ora% ';Usernam Sysdb SYSOP------- ----- -----Orasys TRUE FALSEOraoper FALSE TRUE--check If the user created can connect to databaseSqlplus sys/"[email protected] as SYSDBA"Sqlplus orasys/"[email protected] as SYSDBA"Sqlplus oraoper/"[email protected] as sysoper"-

, ' dd-mon-rr hh24:mi:ss ') Start_time,item,sofar from v$recovery_progress where item in (' Active Apply rate ', ' Average Apply rate ', ' Redo applied ');2, real-time synchronization log View/ruiy/ocr/dbsoftware/app/oracle/diag/rdbms/dg1/dg/trace/alert_dg.log3, the following query before and after switching on the main and standby to check the archive log transfer from the main library to the standby librarySELECT sequence#,applied from V$archived_lo

Tags: dataguard selectlog_mode,open_mode,database_rolefromv$database;--View Dataguard Master Standby status Select statusfromv$instance;--View Database Status alterdatabaserecovermanaged standbydatabasecancel;--canceling the log application Alterdatabaserecovermanagedstandby databaseusingcurrentlogfiledisconnect;--Open Real-time application selectsequence#,applied The fromv$archived_logorderbysequence#;--r

This paper uses Oracle 11g Dataguard broker Switchover Test 1. Using Dataguard Broker Test switchover 1 Main Library situation Sql> select Open_mode,database_role,db_unique_name from V$database; Open_mode Database_role Db_unique_name -------------------- ---------------- ------------------------------ READ WRITE PRIMARY ORCL Sql> Sql> Conn ABC/ABC is con

In a production environment, DBAs tend to face dozens of of hundreds of g of data, or even the T-level, file system storage data files in these situations, I/O problems will gradually exposed, so the data storage in the production environment generally use ASM, or bare devices, Oracle 11G does not support raw devices to store data at the beginning, so this talk mainly describes the configuration of the guard physical database in the ASM environment. E

I. Backup 1. Data Backup (executed on the master database)Rman> backup full database format '/u01/rmanbak/port_full_backup % U. bk '; 2. database software backup (executed on the master database)$ Cd/home/Oracle/product/10.2.0/$ Tar cvf/u01/oraclehomebak/product.tar db_1 3. database parameter backup (executed on the master database)Sqlplus "/as sysdba"SQL> create pfile = '/home/oracle/initport1.ora' from sp

) 'specify the path to the local archivelog_archive_dest_1= ' location=/u01/app/oracle/archive valid_for= (all_logfiles,all_roles) DB_UNIQUE_NAME= Ora11g_primary 'Specify the archive path for the remote standby librarylog_archive_dest_2= ' Service=ora11g_standby lgwr ASYNC valid_for= (online_logfiles,primary_role) DB_UNIQUE_NAME= Ora11g_standby 'Log_archive_dest_n (from 1 to 10) defines the redo file path. This parameter must specify the archive file

An Issue of Oracle distributed uard Broker has been studying how to build Data Guard with a Broker. It has been a good job in the past. A strange problem was suddenly found in the past two days, the configuration process is correct, but the following error message is displayed: DGMGRL> show configuration; Configuration Name: dgmgrl_1 Enabled: YES Protection Mode: maxPerformance Fast-Start Failover: DISABLED Databases: prod-Primary database sbdb-Physic

Since 9i, Oracle Dataguard generally do not need to manually process the lost log, FAL will automatically help us deal with, the following case by hand to handle the Lost log method: 1. What logs are missing from the standby query and not applied to the repository Sql> select * from V$archive_gap; thread# low_sequence# high_sequence# ------------------------------------- 1 9873 9876

did the following operations and finally found out the problem, the red font section below, it was truncated. Dgmgrl> show database verbose sbdb DatabaseName: sbdbRole: Physical standbyEnabled: YesIntended state: OnlineInstance (s ):Sbdb Properties:Initialconnectidentifier = 'sbdb'Logxptmode = 'async'Dependency =''Delaymins = '0'Binding = 'optional'Maxfailure = '0'Maxconnections = '1'Reopensecs = '000000'Nettimeout = '000000'Logshipping = 'on'Preferredapplyinstance =''Applyinstancetimeout = '0

We know that when Standby_file_management is set to auto, if the primary library creates a new Datafile,standby, it automatically synchronizes a new datafile; but when primary Rename a datafile, although Standby_file_management is set to Auto,standby will not sync, at this time need manual modification;Do the following experiment to verify that the datafile of the Zyh tablespace is renamed to/U01/ORACLE/ORADATA/STANDBY/ZYH02.DBF The code i

Note: This article is translated from Oracle Data Guard 11g Handbook Page 78–page 88 In terms of data Guard (later written as DG), we only focus on the following three types of parameters: 1. Parameters independent of database roles2. Parameters when the database role is primary3. Parameters when the database role is standby Although DG has a lot of configuration parameters, we actually use only a few of them, and since many of the DG features are

protected]_s>alter database Recover managed standby database cancel;3.11.emptying the repository log group[Email protected]_s>alter DATABASE CLEAR LOGFILE GROUP 1;Database altered.Note: If the standby log mode is used, it does not need to be emptied and will appear if emptiedsql> ALTER DATABASE CLEAR LOGFILE GROUP 1;ALTER DATABASE CLEAR LOGFILE GROUP 1*ERROR at line 1:Ora-19527:physical Standby Redo log must be renamedOra-00312:online Log 1 Thread 1: '/u01/oradata/badly9/redo01.log 'Note: If st

---------- ------------- ------------ ------------------- ------------------------756171 757560 2017-03-01 20:29:55 YESOmit >827738 833358 2017-09-28 14:20:09 YES833358 834365 2017-09-28 14:57:39 YES94 834365 834411 2017-09-28 14:57:39 YESsequence# first_change# next_change# TIMESTAMP Applied---------- ------------- ------------ ------------------- ------------------------834411 834994 2017-09-28 14:57:40 YES834994 837710 2017-09-28 15:01:28 YES837710 840227 2017-09-28 15:02:06 YES98 840227 8427

Tags: dataguard switchover1. Check the status of the main library:Sql> SELECT switchover_status from V$database;Switchover_status--------------------To STANDBY2. Set the main library to standby roleALTER DATABASE commit to switchover to physical standby;Shutdown immediate;startup Mount;3. Convert Standby to PrimarySql> Select NAME, Db_unique_name, open_mode,database_role from V$database;NAME db_unique_name open_mode database_role--------- ---------

Tags: standby oracle change recordDataguard provides two different ways to apply logs to the standby database: Redo apply (physical standby), SQL apply (logical standby).The main goal of DG is to protect database data from loss. Another goal is to provide a high degree of isolation between master and slave libraries.Physical Standby:Redo apply uses the method of media recovery, reads the Redo record from the SRL in memory, and then applies the change

DataGuard provides the following three data protection modes) maximumProtection the maximum protection here refers to the maximum protection of data loss, that is, at least one sta Data Guard provides the following three Data protection modes) maximum Protection: the Maximum Protection is to protect data from loss, that is, at least one sta. Data Guard provides the following three Data protection modes: Data Guard provides the following three Da