adm
1.capture, propagation, apply rule adjustment View the current rule select * from dba_rules where rule_name in (Select rule_name from dba_rule_set_rules where rule_set_name in (select rule_set_name from dba_capture)); select * from dba_rules where ru ...
two-way streams replication environment, update the conflict resolution (SET_UPDATE_CONFLICT_HANDLER) There are 4 method were MAXIMUM, by resolution_column the value of the column list in the column to determine the value of the value of the check wh ...
1. Initialization parameters (all nodes) alter system set aq_tm_processes = 2 scope = both; alter system set global_names = true scope = both; alter system set job_queue_processes = 10 scope = both; alter system set parallel_max_servers = 20 scope = ...
View this user all system permissions: select * from dba_sys_privs where grantee = 'BACKUSER'; GRANTEE PRIVILEGE ADM ------------------------------ -------------------- -------------------- BACKUSER CREATE SESSION NO Recycling: revoke create ...
12th step, prepare bank created under the application process: USER is "SCOTT" SQL> conn strmadmin / strmadmin Connected. SQL> begin 2 dbms_streams_adm.add_schema_rules ( 3 schema_name => 'scott', 4 streams_type => ' ...
The fifth step, to enable an additional log: Can be based on Database level or Table level, to enable additional logging (Supplemental Log). According to Schema particle size in the establishment of Oracle Stream replication environment, if confirmed ...
The fifth step, to enable an additional log: Can be based on Database level or Table level, to enable additional logging (Supplemental Log). According to Schema particle size in the establishment of Oracle Stream replication environment, if confirmed ...
Last night the Treasury found that the target stream archive full, 100%, the archive log oracle error is reported directly on the deletion of part of the documents in the archives, With pl / sql login, the error did not, and never seriously. This mor ...
Dbms_stats is oracle8i new package, which allows the generation of statistical data and processing more convenient and many people are recommended dbms_stats alternative analyze, but I did not used to record what rn estimate_percent - to estimate the ...
Oracle 10g configuration stream flow one-way replication and complete records Self-citation: http://hi.baidu.com/aku88168/blog/item/3b27cf1fc4870c6bf624e49c.html rn rn To Oracle 10g, there DBMS_STREAMS_ADM after, Stream flow has been very good to cop ...
Second, access to create a link, the operation is as follows: 1, the administrator account to create streams Recommendations for the management of streams tablespace the creation of an independent account to facilitate the management of maintenance. ...
This section we will copy the built environment a little bit more complex, so this is no longer copied between two databases, and coupled with the coming of a new database, synchronization of data between the three databases. I. Requirement Settings ...
The beginning of the operation of this chapter into practice, will demonstrate different ways to create a copy of a different environment to meet the different needs, of course, first and foremost thing is to proceed from the preparatory work. Streams is
Schema-level replication can create DBMS_STREAMS_ADM.MAINTAIN_SCHEMAS, after the previous table space level of the Trial, and then create a schema-level replication environment is relatively simple. Examples continue to be used in this chapter before ...
Second, create a replication environment Create a very simple, only the target side can perform the following process (if there are a number of table space to copy, simply add another t_names (2), t_names (3) ... t_names (n) can be): JSSSTR> DECLA ...
Fourth, clear Streams replication environment On the one hand, for the convenience of the back of the test environment set up, on the one hand because of 10g in the Streams replication environment is very simple to remove, so this as the last section ...
Fourth, a simple way to configure the replication environment There are two ways to configure a through DBMS_CAPTURE_ADM, DBMS_PROPAGATION_ADM, DBMS_APPLY_ADM several packages were created to capture, dissemination and application process, relatively ...
Second, create a replication environment Create a very simple, only the target side can perform the following process (if there are a number of table space to copy, simply add another t_names (2), t_names (3) ... t_names (n) can be): JSSSTR> DECLA ...
There is capture, and dissemination, the following should be applied is, What a coincidence , ORACLE is also a thought. In the Streams replication environment, the shared object changes in accordance with this logic is to be arrested -> spread -&g ...
DBMS_STREAMS_ADM provide table space to create three-level process of replication environment: MAINTAIN_SIMPLE_TTS: a single sheet of copy space MAINTAIN_TTS: more than a copy of table space PRE_INSTANTIATION_SETUP and POST_INSTANTIATION_SETUP: more ...
You should have the impression that we have when the first part of Section II has been demonstrated on the table-level replication to create the environment, compared to the whole database / table space level or schema level replication, Looking back ...
Fifth, the entire configuration manually copy the environment How do I remove a replication environment, you must have been cooked can not be cooked, not demonstrated here. Attention in front of auto-configuration has also created a number of other s ...
rnrnrnrn The timing of the Oracle database, hot backup (Exp) are usually two approaches can be achieved, one is in the Oracle database, provided the task of using Queue Manager (Job Queue) to be achieved; the other is to use the operating system to e ...
