Activar Dataguard Oracle 10g

ORACLE DATAGUARD
Objetivo: El objetivo de este documento es contener los pasos que se realizan para habilitar el DataGuard para la versión 10g de Oracle.
SITUACIÓN ACTUAL
Base Origen
V$DATABASE - Origen
Campo
Valor
DBID
2010826731
NAME
DWH
CREATED
02/07/2011 12:51
RESETLOGS_CHANGE#
521803
RESETLOGS_TIME
02/07/2011 12:51
PRIOR_RESETLOGS_CHANGE#
1
PRIOR_RESETLOGS_TIME17/04/2007 03:34
LOG_MODE
ARCHIVELOG
CHECKPOINT_CHANGE#
2718522
ARCHIVE_CHANGE#
2667176
CONTROLFILE_TYPE
CURRENT
CONTROLFILE_CREATED
02/07/2011 12:51
CONTROLFILE_SEQUENCE#
4783
CONTROLFILE_CHANGE#
2723068
CONTROLFILE_TIME
28/11/2011 19:01
OPEN_RESETLOGS
NOT ALLOWED
VERSION_TIME
02/07/2011 12:51
OPEN_MODE
READ WRITE
PROTECTION_MODE
MAXIMUM PERFORMANCE
PROTECTION_LEVEL
MAXIMUMPERFORMANCE
REMOTE_ARCHIVE
ENABLED
ACTIVATION#
2010872299
SWITCHOVER#
2010872299
DATABASE_ROLE
PRIMARY
ARCHIVELOG_CHANGE#
2718521
ARCHIVELOG_COMPRESSION
DISABLED
SWITCHOVER_STATUS
SESSIONS ACTIVE
DATAGUARD_BROKER
DISABLED
GUARD_STATUS
NONE
SUPPLEMENTAL_LOG_DATA_MIN
NO
SUPPLEMENTAL_LOG_DATA_PK
NO
SUPPLEMENTAL_LOG_DATA_UI
NO
FORCE_LOGGING
NO
PLATFORM_ID
7
PLATFORM_NAMEMicrosoft Windows IA (32-bit)
RECOVERY_TARGET_INCARNATION#
2
LAST_OPEN_INCARNATION#
2
CURRENT_SCN
2723152
FLASHBACK_ON
NO
SUPPLEMENTAL_LOG_DATA_FK
NO
SUPPLEMENTAL_LOG_DATA_ALL
NO
DB_UNIQUE_NAME
dwh
STANDBY_BECAME_PRIMARY_SCN
0
FS_FAILOVER_STATUS
DISABLED
FS_FAILOVER_CURRENT_TARGET
 
FS_FAILOVER_THRESHOLD
0
FS_FAILOVER_OBSERVER_PRESENT
 
FS_FAILOVER_OBSERVER_HOST
 V$INSTANCE
Campo
Valor
INSTANCE_NUMBER
 
INSTANCE_NAME
dwh
HOST_NAME
FAB-PERSONAL
VERSION
10.2.0.3.0
STARTUP_TIME
01/09/2011 19:16
STATUS
OPEN
PARALLEL
NO
THREAD#
1
ARCHIVER
STARTED
LOG_SWITCH_WAIT
 
LOGINS
ALLOWED
SHUTDOWN_PENDING
NO
DATABASE_STATUS
ACTIVE
INSTANCE_ROLE
PRIMARY_INSTANCE
ACTIVE_STATE
NORMAL
BLOCKED
NO

Base Destino
V$DATABASE - Origen
Campo
ValorDBID
4226825853
NAME
BDRESP
CREATED
29/11/2011 20:11
RESETLOGS_CHANGE#
534907
RESETLOGS_TIME
29/11/2011 20:11
PRIOR_RESETLOGS_CHANGE#
1
PRIOR_RESETLOGS_TIME
30/08/2005 13:49
LOG_MODE
ARCHIVELOG
CHECKPOINT_CHANGE#
588314
ARCHIVE_CHANGE#
534907
CONTROLFILE_TYPE
CURRENT
CONTROLFILE_CREATED
29/11/2011 20:11
CONTROLFILE_SEQUENCE#
464
CONTROLFILE_CHANGE#
590542
CONTROLFILE_TIME30/11/2011 09:32
OPEN_RESETLOGS
NOT ALLOWED
VERSION_TIME
29/11/2011 20:11
OPEN_MODE
READ WRITE
PROTECTION_MODE
MAXIMUM PERFORMANCE
PROTECTION_LEVEL
MAXIMUM PERFORMANCE
REMOTE_ARCHIVE
ENABLED
ACTIVATION#
4226808701
SWITCHOVER#
4226808701
DATABASE_ROLE
PRIMARY
ARCHIVELOG_CHANGE#
588313
ARCHIVELOG_COMPRESSION
DISABLED
SWITCHOVER_STATUS
SESSIONS ACTIVE
DATAGUARD_BROKERDISABLED
GUARD_STATUS
NONE
SUPPLEMENTAL_LOG_DATA_MIN
NO
SUPPLEMENTAL_LOG_DATA_PK
NO
SUPPLEMENTAL_LOG_DATA_UI
NO
FORCE_LOGGING
NO
PLATFORM_ID
7
PLATFORM_NAME
Microsoft Windows IA (32-bit)
RECOVERY_TARGET_INCARNATION#
2
LAST_OPEN_INCARNATION#
2
CURRENT_SCN
590560
FLASHBACK_ON
NO
SUPPLEMENTAL_LOG_DATA_FK
NO
SUPPLEMENTAL_LOG_DATA_ALL
NO
DB_UNIQUE_NAME
bdrespSTANDBY_BECAME_PRIMARY_SCN
0
FS_FAILOVER_STATUS
DISABLED
FS_FAILOVER_CURRENT_TARGET
 
FS_FAILOVER_THRESHOLD
0
FS_FAILOVER_OBSERVER_PRESENT
 
FS_FAILOVER_OBSERVER_HOST
 

V$INSTANCE
Campo
Valor
INSTANCE_NUMBER
1
INSTANCE_NAME
bdresp
HOST_NAME
FAB-VIRTUAL
VERSION
10.2.0.1.0
STARTUP_TIME
30/11/2011 09:20
STATUS
OPEN
PARALLEL
NO
THREAD#
1
ARCHIVER
STARTED
LOG_SWITCH_WAIT
 
LOGINSALLOWED
SHUTDOWN_PENDING
NO
DATABASE_STATUS
ACTIVE
INSTANCE_ROLE
PRIMARY_INSTANCE
ACTIVE_STATE
NORMAL
BLOCKED
NO
PROCESO
1. Definir Origen y Destino

ORIGEN
DESTINO
Nombre en el proceso
PRIMARY
STANDBY
SID
DWH
bdresp
VERSIÓN
10.2.0.3.0
10.2.0.1.0
IP
10.3.0.33
192.168.1.128
HOST
FAB-PERSONAL
FAB-VIRTUAL
S.O.
Windows Home Premium
Windows XP


2. Asegurar que...