Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Database Link to check Standby Database

Database Link to check Standby Database

From: Ton <Ton.van.veenendaal_at_hccnet.nl>
Date: 23 Aug 2004 05:22:40 -0700
Message-ID: <81466266.0408230422.bb99538@posting.google.com>


I want to to create a Database Link from the production database to its Standby database.

Purpose: Checking " V$LOG_HISTORY " on the Production and Standby server to idenity if all available production redo log files have been applied on the Standby datase.

Questions:

  1. Is it sensible to create and drop the Database Link connection everytime I run the script?
  2. What will be consequences for the Standby server by creating a DB link by the Production server? In other words: During applying the redo log files from the production to the standby database will the Standby database also try to create database link (to itself)?
  3. Is there a handier solution to check automatically if the both (Prod. & Standby) are in sequence?

Thanks Received on Mon Aug 23 2004 - 07:22:40 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US