Return-Path: X-Original-To: oracle-l@orafaq.com Delivered-To: oracle-l@orafaq.com Received: from puck1183.startdedicated.com (localhost [127.0.0.1]) by puck1183.startdedicated.com (Postfix) with ESMTP id 03B821960591 for ; Tue, 11 Nov 2014 15:39:43 +0100 (CET) Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by puck1183.startdedicated.com (Postfix) with ESMTP for ; Tue, 11 Nov 2014 15:39:42 +0100 (CET) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 3A29E33004; Tue, 11 Nov 2014 09:39:42 -0500 (EST) X-Virus-Scanned: Debian amavisd-new at turing.freelists.org Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id PTaULc5hY8nT; Tue, 11 Nov 2014 09:39:42 -0500 (EST) Received: from turing.freelists.org (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id E204232F93; Tue, 11 Nov 2014 09:39:26 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Tue, 11 Nov 2014 09:38:03 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 845343232F for ; Tue, 11 Nov 2014 09:38:03 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id HNuokjHlcyLX for ; Tue, 11 Nov 2014 09:38:03 -0500 (EST) Received: from mout.gmx.com (mout.gmx.com [74.208.4.201]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 45B253231D for ; Tue, 11 Nov 2014 09:37:42 -0500 (EST) Received: from [167.19.250.100] by 3capp-mailcom-lxa04.server.lan (via HTTP); Tue, 11 Nov 2014 15:37:42 +0100 MIME-Version: 1.0 Message-ID: From: "Lyall Barbour" To: oracle-l Subject: Logical Standby Ghost table?? Content-Type: text/html; charset=UTF-8 Date: Tue, 11 Nov 2014 15:37:42 +0100 Sensitivity: Normal X-Provags-ID: V03:K0:xag5oKdewMYPn6uHwubjqdz7gEZy4bF2mvz0WQhlCy4 XrSabLU6/WeoHpX+SYyfXLJBRONP6CQx+cRqQcumyUGjZ3EhtX gisozXZusMJ3JHGdzEuleLdxC4Zlq0Z1vktFAVxBOW/Ke5KsmU T4iEHonq5aLojygI4OwSWFqNpV/lB8swTDsAN9gjlXPIluOAo0 S7bWFwbQxTLC6+akfeh6mg7Bw1OjqFoWHfingvrbSp0hTO3Gi8 bD0fvYVeqFxjm3TD2KXQcWJBT1EarFHm73eZaWvXL6wBixlN7Q C864V4nFQ1VNH6dIFPiy9z5ByS1 X-UI-Out-Filterresults: notjunk:1; X-archive-position: 57461 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: lyallbarbour@sanfranmail.com Precedence: normal Reply-To: lyallbarbour@sanfranmail.com List-help: List-unsubscribe: List-software: Ecartis version 1.0.0 List-Id: oracle-l X-List-ID: oracle-l List-subscribe: List-owner: List-post: List-archive: X-list: oracle-l

Hi,

Oracle 11.2.0.4, RHEL 5.10

Our logical Standby showed some strange actions in testing for this weekend's project. We are now done with the project, but now Production is showing the strange action too.

1) In Production, there are SIEBEL "loading" tables, that the STandby database doesn't need for the application team that uses the standby.

2) I DBMS_LOGSTDBY.SKIP those.

3) Last night the Production Primary/Standby replication created two ghost copies of one of these tables i specifically skipped, called CMP4$xxxxxx.

Any seen that before? I can't find a metalink or google page about this.

Lyall Barbour

PS. I skipped those tables and Data GUard is working just fine. Would like to know why this happened in the first place though, so it doesn't happen in the future.

-- http://www.freelists.org/webpage/oracle-l