dg_common.ksh

dg_common.ksh is a common DataGuard library designed to allow DataGuard functions to be performed via many functions in the library [code language=”sql”]</pre> #!/bin/ksh ############################################################################ # Script Name..: dg_common.ksh # Description..: Common DataGuard functions # Author…….: Michael Culp # Date………: 04/23/2010 # Version……: .65 # Modified By..: Michael Culp # Date Modified: # Comments…..: Change this […]

DataGuard Switchover Recipe MRC

Currently there is a status of UNRESOLVABLE GAP on database DBFSXD01 and DBFSXD02 [code language=”sql”] mrcche1de [DBFSXD021]> sql SQL*Plus: Release 12.1.0.2.0 Production on Mon Jul 23 14:54:50 2018 Copyright (c) 1982, 2014, Oracle.  All rights reserved. Connected to an idle instance. SQL> startup ORACLE instance started. Total System Global Area 8589934592 bytes Fixed Size                  7663544 bytes Variable […]

DataGuard

Steps for Dataguard failover dg_shutdown_stdby_inst dg_chk_stdby_pre dg_shutdown_pre_inst before primary instances 2,3

DR_Mon.ksh

[code language=”sql”] #!/bin/ksh #set -x Set_Env() { HOSTNAME=`hostname` HR2SPOOL=/tmp/spool4drmonh2.rep; MAXSPOOL=/tmp/spool4drmonmax.rep; DRSPOOLFILE=/tmp/spool4dr.rep; MREPORT="/oracle/admin/scripts/logs/dr_monitor_${ORA_SID}_at_`date +%H`.log" rm -f $MREPORT REMOTE_SID=DPODSB01 #NOTIFY2="mike.culp@gmail.com,test.culp@gmail.com" NOTIFY2="mike.culp@gmail.com" } Get_Info() { sqlplus -s /<<EOF set echo off verify off head off feed off pages0 trimspool on; spool $MAXSPOOL; select   thread#, max(sequence#) from     v\$archived_log val, v\$database vdb where    val.resetlogs_change# = vdb.resetlogs_change# group by thread# order […]

Dataguard Create Process Exadata

Step #1 Check both sides Step #2 Execute dg_

Dataguard Broker

Dataguard Services Setup via SRVCTL

Starting with 11gR2, with the advent of the new Grid Infrastructure software, we have the ability to set up services in our databases that can now automatically be tied to the specific role that a database is playing in our Data Guard configuration.  Data Guard Broker must be configured and running to use this new […]

Oracle Dataguard Auto Block Recovery

In this post, I will demonstrate automatic block media recovery introduced in 11g Data Guard. This feature can be used only if active dataguard is enabled. This feature enables the automatic repair of corrupt blocks transparent to the user and application. If corruption occurs on the primary database, block media recovery is performed automatically using […]

Dataguard FAQ

DATAGUARD SWITCHOVER GUIDE (PHYSICAL STANDBY) Resolving Gaps   DG Switchover / Failover DataGuard First Apply Doc

Protected: Data Guard Protection Modes

There is no excerpt because this is a protected post.