Urbano R.
Table of contents :
Send Us Your Comments……Page 19
Preface……Page 21
1 Replication Overview……Page 35
Creating a Replication Environment Overview……Page 36
Before You Start……Page 38
2 Create Replication Site……Page 39
Overview of Setting Up Replication Sites……Page 40
Setting Up orc1.world……Page 42
Setting Up orc2.world……Page 47
Setting Up orc3.world……Page 50
Creating Scheduled Links Between the Master Sites……Page 53
Setting Up Materialized View Sites……Page 57
Setting Up mv1.world……Page 58
Setting Up mv2.world……Page 65
3 Create a Master Group……Page 71
Overview of Creating a Master Group……Page 72
Before You Start……Page 73
Creating a Master Group……Page 75
4 Create a Deployment Template……Page 85
Oracle Deployment Templates Concepts……Page 86
Creating a Deployment Template……Page 87
Packaging a Deployment Template for Instantiation……Page 96
Packaging a Deployment Template……Page 98
Saving an Instantiation Script to File……Page 100
Distributing Instantiation Files……Page 102
Instantiating a Deployment Template……Page 103
Refreshing a Refresh Group After Instantiation……Page 105
5 Create Materialized View Group……Page 107
Overview of Creating a Materialized View Group……Page 108
Creating the Materialized View Group at mv1.world……Page 110
Creating the Materialized View Group at mv2.world……Page 118
6 Configure Conflict Resolution……Page 127
Preparing for Conflict Resolution……Page 128
Overwrite and Discard Conflict Resolution Methods……Page 129
Minimum and Maximum Conflict Resolution Methods……Page 132
Timestamp Conflict Resolution Methods……Page 135
Additive and Average Conflict Resolution Methods……Page 139
Priority Groups Conflict Resolution Methods……Page 141
Site Priority Conflict Resolution Methods……Page 146
Creating Conflict Resolution Methods for Uniqueness Conflicts……Page 151
Creating Conflict Avoidance Methods for Delete Conflicts……Page 157
Workflow……Page 162
Token Passing……Page 163
Obtaining Ownership……Page 165
Applying the Change……Page 166
Viewing Conflict Resolution Statistics……Page 167
Clearing Statistics Information……Page 168
7 Managing a Master Replication Environment……Page 171
Option 1: All Master Sites Are Available……Page 172
Option 2: The Old Master Definition Site Is Not Available……Page 173
Adding New Master Sites Without Quiescing the Master Group……Page 174
Adding New Master Sites to a Quiesced Master Group……Page 198
Removing a Master Site from a Master Group……Page 207
Removing an Unavailable Master Site……Page 209
Updating the Comments Fields in Data Dictionary Views……Page 210
Restrictions on Procedural Replication……Page 212
User-Defined Types and Procedural Replication……Page 214
Generating Support for Replicated Procedures……Page 215
8 Managing a Materialized View Replication Environment……Page 219
Changing a Materialized View Group’s Master Site……Page 220
Dropping Materialized View Groups and Objects……Page 221
Dropping a Materialized View Groups Created with a Deployment Template……Page 222
Dropping a Materialized View Group or Objects Created Manually……Page 226
Cleaning Up a Master Site or Master Materialized View Site……Page 228
Altering Materialized View Logs……Page 233
Managing Materialized View Log Space……Page 234
Reorganizing Master Tables that Have Materialized View Logs……Page 237
Dropping a Materialized View Log……Page 240
Performing an Offline Instantiation of a Materialized View Site Using Export/Import……Page 241
Using a Group Owner for a Materialized View Group……Page 252
9 Managing Replication Objects and Queues……Page 259
Altering a Replicated Object in a Quiesced Master Group……Page 260
Disabling Replication……Page 263
Reenabling the Replication Facility……Page 264
Converting a LONG Column to a LOB Column in a Replicated Table……Page 265
Using the RECTIFY Procedure……Page 267
Pushing the Deferred Transaction Queue……Page 272
Purging the Deferred Transaction Queue……Page 273
Using the AnyData Type to Determine the Value of an Argument in a Deferred Call……Page 274
Managing the Error Queue……Page 276
Reexecuting Error Transaction as the Receiver……Page 277
Reexecuting Error Transaction as Alternate User……Page 278
10 Monitoring a Replication Environment……Page 279
Monitoring Master Sites……Page 280
Monitoring Master Groups……Page 281
Monitoring Masters……Page 284
Listing General Information About a Materialized View Site……Page 289
Listing General Information About Materialized View Groups……Page 290
Listing Information About Materialized Views……Page 291
Listing Information About the Refresh Groups at a Materialized View Site……Page 293
Determining the Job ID for Each Refresh Job at a Materialized View Site……Page 294
Listing General Information About Administrative Requests……Page 295
Determining the Cause of Administrative Request Errors……Page 296
Listing General Information About the Job that Executes Administrative Requests……Page 297
Monitoring Transaction Propagation……Page 298
Monitoring Purges of Successfully Propagated Transactions……Page 301
Listing General Information About the Error Transactions at a Replication Site……Page 304
Listing the Number of Error Transactions from Each Origin Master Site……Page 305
Determining the Error Operations at a Replication Site……Page 306
Monitoring Initialization Parameters……Page 307
Tracking the Average Number of Row Changes in a Replication Transaction……Page 308
Determining the Average Network Traffic Created To Propagate a Transaction……Page 309
Determining the Percentage of Time the Parallel Propagation Job Spends Sleeping……Page 310
Monitoring Parallel Propagation of Deferred Transactions Using V$REPLPROP……Page 311
11 Introduction to the Replication Management API Reference……Page 317
Examples of Using Oracle’s Replication Management API……Page 318
The Replication Management Tool and the Replication Management API……Page 319
Abbreviations for Datetime and Interval Datatypes……Page 320
12 DBMS_DEFER……Page 321
Summary of DBMS_DEFER Subprograms……Page 322
CALL Procedure……Page 323
COMMIT_WORK Procedure……Page 324
datatype_ARG Procedure……Page 325
TRANSACTION Procedure……Page 328
13 DBMS_DEFER_QUERY……Page 329
Summary of DBMS_DEFER_QUERY Subprograms……Page 330
GET_ARG_FORM Function……Page 331
GET_ARG_TYPE Function……Page 333
GET_CALL_ARGS Procedure……Page 335
GET_datatype_ARG Function……Page 337
GET_OBJECT_NULL_VECTOR_ARG Function……Page 340
14 DBMS_DEFER_SYS……Page 343
Summary of DBMS_DEFER_SYS Subprograms……Page 344
ADD_DEFAULT_DEST Procedure……Page 346
CLEAR_PROP_STATISTICS Procedure……Page 347
DELETE_DEF_DESTINATION Procedure……Page 348
DELETE_ERROR Procedure……Page 349
DELETE_TRAN Procedure……Page 350
DISABLED Function……Page 351
EXCLUDE_PUSH Function……Page 352
EXECUTE_ERROR Procedure……Page 353
EXECUTE_ERROR_AS_USER Procedure……Page 354
PURGE Function……Page 355
PUSH Function……Page 358
REGISTER_PROPAGATOR Procedure……Page 361
SCHEDULE_PURGE Procedure……Page 362
SCHEDULE_PUSH Procedure……Page 364
SET_DISABLED Procedure……Page 366
UNREGISTER_PROPAGATOR Procedure……Page 368
UNSCHEDULE_PUSH Procedure……Page 369
15 DBMS_MVIEW……Page 371
Summary of DBMS_MVIEW Subprograms……Page 372
BEGIN_TABLE_REORGANIZATION Procedure……Page 373
END_TABLE_REORGANIZATION Procedure……Page 374
EXPLAIN_MVIEW Procedure……Page 375
EXPLAIN_REWRITE Procedure……Page 376
I_AM_A_REFRESH Function……Page 377
PURGE_DIRECT_LOAD_LOG Procedure……Page 378
PURGE_LOG Procedure……Page 379
PURGE_MVIEW_FROM_LOG Procedure……Page 380
REFRESH Procedure……Page 382
REFRESH_ALL_MVIEWS Procedure……Page 385
REFRESH_DEPENDENT Procedure……Page 386
REGISTER_MVIEW Procedure……Page 388
UNREGISTER_MVIEW Procedure……Page 391
16 DBMS_OFFLINE_OG……Page 393
Summary of DBMS_OFFLINE_OG Subprograms……Page 394
BEGIN_INSTANTIATION Procedure……Page 395
BEGIN_LOAD Procedure……Page 396
END_INSTANTIATION Procedure……Page 398
END_LOAD Procedure……Page 399
RESUME_SUBSET_OF_MASTERS Procedure……Page 401
17 DBMS_OFFLINE_SNAPSHOT……Page 403
Summary of DBMS_OFFLINE_SNAPSHOT Subprograms……Page 404
BEGIN_LOAD Procedure……Page 405
END_LOAD Procedure……Page 407
18 DBMS_RECTIFIER_DIFF……Page 409
Summary of DBMS_RECTIFIER_DIFF Subprograms……Page 410
DIFFERENCES Procedure……Page 411
RECTIFY Procedure……Page 414
19 DBMS_REFRESH……Page 417
Summary of DBMS_REFRESH Subprograms……Page 418
ADD Procedure……Page 419
CHANGE Procedure……Page 420
DESTROY Procedure……Page 422
MAKE Procedure……Page 423
SUBTRACT Procedure……Page 426
20 DBMS_REPCAT……Page 429
Summary of DBMS_REPCAT Subprograms……Page 430
ADD_GROUPED_COLUMN Procedure……Page 436
ADD_MASTER_DATABASE Procedure……Page 437
ADD_NEW_MASTERS Procedure……Page 439
ADD_PRIORITY_datatype Procedure……Page 445
ADD_SITE_PRIORITY_SITE Procedure……Page 447
ADD_conflicttype_RESOLUTION Procedure……Page 448
ALTER_CATCHUP_PARAMETERS Procedure……Page 454
ALTER_MASTER_PROPAGATION Procedure……Page 456
ALTER_MASTER_REPOBJECT Procedure……Page 457
ALTER_MVIEW_PROPAGATION Procedure……Page 460
ALTER_PRIORITY Procedure……Page 462
ALTER_PRIORITY_datatype Procedure……Page 463
ALTER_SITE_PRIORITY Procedure……Page 465
ALTER_SITE_PRIORITY_SITE Procedure……Page 467
CANCEL_STATISTICS Procedure……Page 468
COMMENT_ON_COLUMN_GROUP Procedure……Page 469
COMMENT_ON_MVIEW_REPSITES Procedure……Page 470
COMMENT_ON_PRIORITY_GROUP/COMMENT_ON_SITE_PRIORITY Procedures……Page 471
COMMENT_ON_REPGROUP Procedure……Page 472
COMMENT_ON_REPOBJECT Procedure……Page 473
COMMENT_ON_REPSITES Procedure……Page 474
COMMENT_ON_conflicttype_RESOLUTION Procedure……Page 476
COMPARE_OLD_VALUES Procedure……Page 478
CREATE_MASTER_REPGROUP Procedure……Page 480
CREATE_MASTER_REPOBJECT Procedure……Page 481
CREATE_MVIEW_REPGROUP Procedure……Page 485
CREATE_MVIEW_REPOBJECT Procedure……Page 486
DEFINE_COLUMN_GROUP Procedure……Page 489
DEFINE_PRIORITY_GROUP Procedure……Page 490
DEFINE_SITE_PRIORITY Procedure……Page 492
DO_DEFERRED_REPCAT_ADMIN Procedure……Page 493
DROP_COLUMN_GROUP Procedure……Page 494
DROP_GROUPED_COLUMN Procedure……Page 495
DROP_MASTER_REPGROUP Procedure……Page 496
DROP_MASTER_REPOBJECT Procedure……Page 497
DROP_MVIEW_REPGROUP Procedure……Page 499
DROP_MVIEW_REPOBJECT Procedure……Page 500
DROP_PRIORITY Procedure……Page 501
DROP_PRIORITY_GROUP Procedure……Page 502
DROP_PRIORITY_datatype Procedure……Page 503
DROP_SITE_PRIORITY Procedure……Page 504
DROP_SITE_PRIORITY_SITE Procedure……Page 505
DROP_conflicttype_RESOLUTION Procedure……Page 506
EXECUTE_DDL Procedure……Page 508
GENERATE_MVIEW_SUPPORT Procedure……Page 510
GENERATE_REPLICATION_SUPPORT Procedure……Page 511
MAKE_COLUMN_GROUP Procedure……Page 513
PREPARE_INSTANTIATED_MASTER Procedure……Page 515
PURGE_MASTER_LOG Procedure……Page 516
PURGE_STATISTICS Procedure……Page 517
REFRESH_MVIEW_REPGROUP Procedure……Page 518
REGISTER_MVIEW_REPGROUP Procedure……Page 520
REGISTER_STATISTICS Procedure……Page 522
RELOCATE_MASTERDEF Procedure……Page 523
REMOVE_MASTER_DATABASES Procedure……Page 525
RENAME_SHADOW_COLUMN_GROUP Procedure……Page 526
REPCAT_IMPORT_CHECK Procedure……Page 527
RESUME_MASTER_ACTIVITY Procedure……Page 528
RESUME_PROPAGATION_TO_MDEF Procedure……Page 529
SEND_OLD_VALUES Procedure……Page 530
SET_COLUMNS Procedure……Page 533
SPECIFY_NEW_MASTERS Procedure……Page 535
SUSPEND_MASTER_ACTIVITY Procedure……Page 537
SWITCH_MVIEW_MASTER Procedure……Page 538
UNDO_ADD_NEW_MASTERS_REQUEST Procedure……Page 539
UNREGISTER_MVIEW_REPGROUP Procedure……Page 541
VALIDATE Function……Page 542
WAIT_MASTER_LOG Procedure……Page 545
21 DBMS_REPCAT_ADMIN……Page 547
Summary of DBMS_REPCAT_ADMIN Subprograms……Page 548
GRANT_ADMIN_ANY_SCHEMA Procedure……Page 549
GRANT_ADMIN_SCHEMA Procedure……Page 550
REGISTER_USER_REPGROUP Procedure……Page 551
REVOKE_ADMIN_ANY_SCHEMA Procedure……Page 553
REVOKE_ADMIN_SCHEMA Procedure……Page 554
UNREGISTER_USER_REPGROUP Procedure……Page 555
22 DBMS_REPCAT_INSTANTIATE……Page 557
Summary of DBMS_REPCAT_INSTANTIATE Subprograms……Page 558
INSTANTIATE_OFFLINE Function……Page 559
INSTANTIATE_ONLINE Function……Page 562
23 DBMS_REPCAT_RGT……Page 565
Summary of DBMS_REPCAT_RGT Subprograms……Page 566
ALTER_REFRESH_TEMPLATE Procedure……Page 569
ALTER_TEMPLATE_OBJECT Procedure……Page 571
ALTER_TEMPLATE_PARM Procedure……Page 574
ALTER_USER_AUTHORIZATION Procedure……Page 576
ALTER_USER_PARM_VALUE Procedure……Page 578
COMPARE_TEMPLATES Function……Page 580
COPY_TEMPLATE Function……Page 582
CREATE_OBJECT_FROM_EXISTING Function……Page 584
CREATE_REFRESH_TEMPLATE Function……Page 586
CREATE_TEMPLATE_OBJECT Function……Page 588
CREATE_TEMPLATE_PARM Function……Page 591
CREATE_USER_AUTHORIZATION Function……Page 594
CREATE_USER_PARM_VALUE Function……Page 595
DELETE_RUNTIME_PARMS Procedure……Page 597
DROP_ALL_OBJECTS Procedure……Page 598
DROP_ALL_TEMPLATE_PARMS Procedure……Page 600
DROP_ALL_TEMPLATE_SITES Procedure……Page 601
DROP_ALL_USER_AUTHORIZATIONS Procedure……Page 602
DROP_ALL_USER_PARM_VALUES Procedure……Page 603
DROP_REFRESH_TEMPLATE Procedure……Page 604
DROP_SITE_INSTANTIATION Procedure……Page 605
DROP_TEMPLATE_OBJECT Procedure……Page 606
DROP_TEMPLATE_PARM Procedure……Page 608
DROP_USER_AUTHORIZATION Procedure……Page 609
DROP_USER_PARM_VALUE Procedure……Page 610
INSERT_RUNTIME_PARMS Procedure……Page 611
INSTANTIATE_OFFLINE Function……Page 613
INSTANTIATE_ONLINE Function……Page 616
LOCK_TEMPLATE_SHARED Procedure……Page 619
24 DBMS_REPUTIL……Page 621
Summary of DBMS_REPUTIL Subprograms……Page 622
REPLICATION_ON Procedure……Page 623
FROM_REMOTE Function……Page 624
MAKE_INTERNAL_PKG Procedure……Page 625
SYNC_UP_REP Procedure……Page 626
25 Replication Catalog Views……Page 631
Summary of Replication Catalog Views……Page 632
ALL_REPCAT_REFRESH_TEMPLATES……Page 635
ALL_REPCAT_TEMPLATE_OBJECTS……Page 636
ALL_REPCAT_TEMPLATE_PARMS……Page 638
ALL_REPCAT_TEMPLATE_SITES……Page 641
ALL_REPCAT_USER_AUTHORIZATIONS……Page 642
ALL_REPCAT_USER_PARM_VALUES……Page 643
ALL_REPCATLOG……Page 645
ALL_REPCOLUMN……Page 647
ALL_REPCOLUMN_GROUP……Page 649
ALL_REPCONFLICT……Page 650
ALL_REPDDL……Page 651
ALL_REPGENOBJECTS……Page 652
ALL_REPGROUP……Page 653
ALL_REPGROUP_PRIVILEGES……Page 654
ALL_REPGROUPED_COLUMN……Page 655
ALL_REPKEY_COLUMNS……Page 656
ALL_REPOBJECT……Page 657
ALL_REPPARAMETER_COLUMN……Page 659
ALL_REPPRIORITY……Page 660
ALL_REPPRIORITY_GROUP……Page 662
ALL_REPPROP……Page 663
ALL_REPRESOL_STATS_CONTROL……Page 664
ALL_REPRESOLUTION……Page 665
ALL_REPRESOLUTION_METHOD……Page 666
ALL_REPRESOLUTION_STATISTICS……Page 667
ALL_REPSITES……Page 668
DBA_REPCAT_TEMPLATE_SITES……Page 669
DBA_REPCATLOG……Page 670
DBA_REPDDL……Page 671
DBA_REPEXTENSIONS……Page 672
DBA_REPOBJECT……Page 675
DBA_REPPROP……Page 676
DBA_REPRESOLUTION_STATISTICS……Page 677
DBA_REPSITES_NEW……Page 678
USER_REPCAT_REFRESH_TEMPLATES……Page 679
USER_REPCAT_USER_AUTHORIZATION……Page 680
USER_REPCOLUMN_GROUP……Page 681
USER_REPGROUP……Page 682
USER_REPPARAMETER_COLUMN……Page 683
USER_REPPROP……Page 684
USER_REPRESOLUTION_METHOD……Page 685
USER_REPSITES……Page 686
26 Replication Dynamic Performance Views……Page 687
V$REPLPROP……Page 688
V$REPLQUEUE……Page 690
27 Deferred Transaction Views……Page 691
DEFCALLDEST……Page 692
DEFERRCOUNT……Page 693
DEFLOB……Page 694
DEFSCHEDULE……Page 695
DEFTRANDEST……Page 698
28 Materialized View and Refresh Group Views……Page 699
ALL_BASE_TABLE_MVIEWS……Page 700
ALL_MVIEW_LOGS……Page 701
ALL_MVIEW_REFRESH_TIMES……Page 702
ALL_MVIEWS……Page 703
ALL_REFRESH……Page 707
ALL_REFRESH_CHILDREN……Page 708
ALL_REGISTERED_MVIEWS……Page 709
DBA_MVIEW_REFRESH_TIMES……Page 710
DBA_REGISTERED_MVIEW_GROUPS……Page 711
USER_MVIEWS……Page 712
USER_REGISTERED_MVIEWS……Page 713
A Security Options……Page 717
Security Setup for Multimaster Replication……Page 718
Trusted Compared With Untrusted Security……Page 719
Security Setup for Materialized View Replication……Page 723
Trusted Compared With Untrusted Security……Page 724
B User-Defined Conflict Resolution Methods……Page 729
Conflict Resolution Method Parameters……Page 730
Resolving Uniqueness Conflicts……Page 731
Multitier Materialized Views and User-Defined Conflict Resolution Methods……Page 732
Restrictions for User-Defined Conflict Resolution Methods……Page 733
Examples of User-Defined Conflict Resolution Method……Page 734
Creating a Conflict Notification Log……Page 736
Creating a Conflict Notification Package……Page 737
Viewing Conflict Resolution Information……Page 740
Index……Page 741
Reviews
There are no reviews yet.