Solved

Oralce Async CDC

Posted on 2014-10-19
3
165 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
Comment Utility
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
Comment Utility
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
Comment Utility
tks,.
0

Featured Post

What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Join & Write a Comment

I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
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 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.

762 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

Need Help in Real-Time?

Connect with top rated Experts

7 Experts available now in Live!

Get 1:1 Help Now