Solved

Oralce Async CDC

Posted on 2014-10-19
3
169 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
  • 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 76

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

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

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

Suggested Solutions

If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
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 explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…

785 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