Solved

Oralce Async CDC

Posted on 2014-10-19
3
172 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 500 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

How Do You Stack Up Against Your Peers?

With today’s modern enterprise so dependent on digital infrastructures, the impact of major incidents has increased dramatically. Grab the report now to gain insight into how your organization ranks against your peers and learn best-in-class strategies to resolve incidents.

Question has a verified solution.

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

Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
Confronted with some SQL you don't know can be a daunting task. It can be even more daunting if that SQL carries some of the old secret codes used in the Ye Olde query syntax, such as: (+)     as used in Oracle;     *=     =*    as used in Sybase …
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.

729 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