?
Solved

Oralce Async CDC

Posted on 2014-10-19
3
Medium Priority
?
174 Views
Last Modified: 2014-10-20
DEar all,

I am reading this to setup the Oracle Async CDC, http://psoug.org/reference/cdc_demo2.html

and I and trying this out and I have something don't understand what it tried to do:

SELECT supplemental_log_data_min LOG_MIN, supplemental_log_data_pk LOG_PK, supplemental_log_data_ui LOG_UI, supplemental_log_data_fk LOG_FK,
 supplemental_log_data_all LOG_ALL, force_logging FORCE_LOG
 FROM v$database;

when I try to do on my Oracle, the result is :

LOG_MIN  LOG_PK LOG_UI LOG_FK LOG_ALL FORCE_LOG
-------- ------ ------ ------ ------- ---------
NO       NO     NO     NO     NO      NO       
1 row selected.

Open in new window


what is that mean?

and I tried this:

SELECT tablespace_name, force_logging
 FROM dba_tablespaces;

and my result is:

TABLESPACE_NAME                FORCE_LOGGING
------------------------------ -------------
SYSTEM                         NO           
UNDOTBS1                       NO           
SYSAUX                         NO           
TEMP                           NO           
USERS                          NO           
BOULDERGBS                     NO           
ITDATA                         NO           
STATISTICS                     NO           
DEN_LOG                        NO           
DEN_QUERY                      NO           
SWLOGSTORE                     NO           
GCUK_DENVER_IDX                NO           
GCUK_DENVER                    NO           
GCSA_DENVER_IDX                NO           
GCSA_DENVER                    NO           
DEN_REFERENCE                  NO           
DENVER_IDX                     NO           
DENVER                         NO           
PERFSTAT                       NO           
COGNOS                         NO           
DEN_CDRSTORE_OLD               NO           

TABLESPACE_NAME                FORCE_LOGGING
------------------------------ -------------
DEN_DATAMART_SAN2              NO           
DEN_DATAMART_SAN1              NO           
DEN_COMMON                     NO           
DEN_ALERT                      NO           
BSS_DATA_SAN1                  NO           
DEN_BILLING_SAN1               NO           
CDRTEMP_SAN2                   NO           
DEN_DATAMART_SAN2B             NO           
CDRTEMP_OL                     NO           
DEN_BILLING_IDX_G              NO           
DEN_DATAMART_IDX_F             NO           
DEN_BILLING_IDX_F              NO           
DEN_DATAMART_IDX_G             NO           
CDR                            NO           
TEMP01                         NO           
DEN_DATASTORE                  NO           
DEN_DMTERM_IDX_F               NO           
DEN_DMTERM_IDX_G               NO           
DEN_CDRSTORE                   NO           
DENREFDATA                NO           
DENIDX_SML                NO           

TABLESPACE_NAME                FORCE_LOGGING
------------------------------ -------------
DENDMART                  NO           
DENIDX_MED                NO           
DENCDR                    NO           
DENIDX_LRG                NO           
DENTEMP                   NO           
DENDMART_G                NO           
DENDMART_F                NO           
TEMP02                         NO           
DENDMOVE                  NO           

51 rows selected.

Open in new window


what is that mean ?

and this :

-- examine CDC related data dictionary objects
 SELECT table_name
 FROM dba_tables
 WHERE owner = 'SYS'
 AND table_name LIKE 'CDC%$';

result of my Oracle is :

TABLE_NAME                    
------------------------------
CDC_CHANGE_COLUMNS$           
CDC_CHANGE_SETS$              
CDC_CHANGE_SOURCES$           
CDC_CHANGE_TABLES$            
CDC_PROPAGATED_SETS$          
CDC_PROPAGATIONS$             
CDC_SUBSCRIBED_COLUMNS$       
CDC_SUBSCRIBED_TABLES$        
CDC_SUBSCRIBERS$              
CDC_SYSTEM$                   

10 rows selected.

Open in new window


it just a strucure, right? what is that mean to me ?

and this:
SELECT * FROM cdc_system$;

give me this :

MAJOR_VERSION MINOR_VERSION
------------- -------------
            1             0
1 row selected.

Open in new window


what I expected to REACT ?
0
Comment
Question by:marrowyung
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 1

Author Comment

by:marrowyung
ID: 40391305
and what is this for :

SELECT username
 FROM dba_users u, streams$_privileged_user s
 WHERE u.user_id = s.user#;

my result is : no row selected.

when i do this:

SELECT *
 FROM dba_streams_administrator;

result is hte same: no row selected
0
 
LVL 77

Accepted Solution

by:
slightwv (䄆 Netminder) earned 2000 total points
ID: 40391917
I suggest you look for the information in the online docs.

For example:
the first query can be found here:
http://docs.oracle.com/cd/E11882_01/server.112/e17069/strms_cpmon.htm#STRMS897

What the query is telling you is if supplemental logging has been enabled.  You need this for CDC.  In the example you are following, farther down the page, it shows you how to enable it.


After checking the rest of those queries in the online docs, if you still have questions, just ask.
0
 
LVL 1

Author Comment

by:marrowyung
ID: 40393574
tks,.
0

Featured Post

Percona Live Europe 2017 | Sep 25 - 27, 2017

The Percona Live Open Source Database Conference Europe 2017 is the premier event for the diverse and active European open source database community, as well as businesses that develop and use open source database software.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I'm trying, I really am. But I've seen so many wrong approaches involving date(time) boundaries I despair about my inability to explain it. I've seen quite a few recently that define a non-leap year as 364 days, or 366 days and the list goes on. …
This article describes how to use the timestamp of existing data in a database to allow Tableau to calculate the prior work day instead of relying on case statements or if statements to calculate the days of the week.
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question