Solved

Oralce Async CDC

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

Resolve Critical IT Incidents Fast

If your data, services or processes become compromised, your organization can suffer damage in just minutes and how fast you communicate during a major IT incident is everything. Learn how to immediately identify incidents & best practices to resolve them quickly and effectively.

Question has a verified solution.

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

Suggested Solutions

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. …
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 how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

839 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