Optional DDL on objects in replication（实践操作）
Optional DDL on objects in replicationYou can enable the replication of the following DDL when it is issued on objects that are in the configuration file. To enable the replication of a DDL command, set the associated parameter to 1.
DDL command Set this parameter to 1
CREATE / DROP TRIGGER SP_OCT_REPLICATE_TRIGGER
CREATE / DROP SYNONYM SP_OCT_REPLICATE_SYNONYM
GRANT SP_OCT_REPLICATE_GRANT
See the SharePlex Reference Guide for details about these parameters.
SP_OCT_REPLICATE_SYNONYM
This parameter controls whether SharePlex replicates CREATE SYNONYM and DROP SYNONYM commands
that are issued for tables that are listed in the configuration file.
Default: 0 (disabled)
Range of valid values: 0 or 1
Takes effect: when Capture is restarted
SP_OCT_REPLICATE_TRIGGER
This parameter controls whether SharePlex replicates CREATE TRIGGER and DROP TRIGGER commands that
are issued for tables that are listed in the configuration file.
Default: 0 (disabled)
Range of valid values: 0 or 1
Takes effect: when Capture is restarted
SP_OCT_REPLICATE_GRANT
This parameter controls whether SharePlex replicates GRANT commands that are issued for tables that are
listed in the configuration file.
Default: 0 (disabled)
Range of valid values: 0 or 1
Takes effect: when Capture is restarted
2017/4/7 17:05:19
sp_ctrl (node1:2100)> exit
$
$
$
$
$ clear
$ sp_ctrl
*******************************************************
* SharePlex for Oracle Command Utility
* Copyright 2016 Quest Software Inc.
* ALL RIGHTS RESERVED.
* Protected by U.S. Patents: 7,461,103 and 7,065,538
*******************************************************
sp_ctrl (node1:2100)> status
Brief Status for node1
Process State PID Running Since
-------------------------------------------------------------------------
Cop Running 254307-Apr-17 04:46:09
Capture Running 255107-Apr-17 04:46:39
Read Running 255707-Apr-17 04:46:42
Export Running 256607-Apr-17 04:46:44
Cmd & Ctrl Running 267107-Apr-17 05:05:32
System is used as a source machine
There is 1 active configuration file
sp_ctrl (node1:2100)> exit
$ ssh node2
oracle@node2's password:
Last login: Fri Apr7 01:32:43 2017 from node1
$ sp_ctrl
*******************************************************
* SharePlex for Oracle Command Utility
* Copyright 2016 Quest Software Inc.
* ALL RIGHTS RESERVED.
* Protected by U.S. Patents: 7,461,103 and 7,065,538
*******************************************************
sp_ctrl (node2:2100)> status
Brief Status for node2
Process State PID Running Since
-------------------------------------------------------------------------
Cop Running 252307-Apr-17 04:46:21
Import Running 253807-Apr-17 04:46:44
Post Running 252407-Apr-17 04:46:21
Cmd & Ctrl Running 258707-Apr-17 04:56:35
Cmd & Ctrl Running 267007-Apr-17 05:05:44
There are no active configuration files
sp_ctrl (node2:2100)>
sp_ctrl (node2:2100)>
sp_ctrl (node2:2100)>
sp_ctrl (node2:2100)> exit
$ exit
logout
Connection to node2 closed.
$
$
$ sp_ctrl
*******************************************************
* SharePlex for Oracle Command Utility
* Copyright 2016 Quest Software Inc.
* ALL RIGHTS RESERVED.
* Protected by U.S. Patents: 7,461,103 and 7,065,538
*******************************************************
sp_ctrl (node1:2100)> list param
sp_ctrl (node1:2100)> list param capture
Capture parameters:
ParameterName Actual Value Units Set At
----------------------------------------------------------------------------------------
SP_OCT_ARCH_LOC Live
SP_OCT_ASM_USE_OCI 0 booleanRestart Process
SP_OCT_AUTOADD_ENABLE 1 booleanRestart Process
SP_OCT_AUTOADD_MVIEW 1 booleanRestart Process
Default Value: 0
SP_OCT_AUTOADD_SEQ 1 booleanRestart Process
Default Value: 0
SP_OCT_BIO_CHECKSUM 0 booleanLive
SP_OCT_CHECKPOINT_LOG 2 logs Live
SP_OCT_DATA_OBJ_CACHE_SIZE 50 values Live
SP_OCT_DATE_MSG 0 Live
SP_OCT_DDL_LOGGING 2 Live
SP_OCT_DEF_DAY 1 Live
SP_OCT_DEF_HOUR 0 Live
SP_OCT_DEF_MIN 0 Live
SP_OCT_DEF_MONTH 1 Live
SP_OCT_DEF_SEC 0 Live
SP_OCT_DEF_YEAR 1999 Live
SP_OCT_DENIED_USERID 0x00000000 number Live
SP_OCT_INCLUDE_UNCHANGED_COL 0 booleanLive
SP_OCT_LOG_MEMBER % Restart Process
SP_OCT_LOGWRAP_RESTART 0 secondsLive
SP_OCT_ONELINE_DEBUG Live
SP_OCT_ONELINE_DEBUG_COLUMNS 0 Live
SP_OCT_OPTIMIZE_ROW_MOVEMENT 0 booleanLive
SP_OCT_PREFER_ARCHIVE 0 booleanRestart Process
SP_OCT_REPLICATE_ALL_DDL 0 Live
SP_OCT_REPLICATE_CTAS 1 Restart Process
SP_OCT_REPLICATE_DDL 3 Live
SP_OCT_REPLICATE_DLOAD 1 Live
SP_OCT_REPLICATE_MVIEW 1 booleanRestart Process
SP_OCT_REPLICATE_POSTER 0 Restart Process
SP_OCT_REPLICATE_SEQUENCES 1 booleanRestart Process
SP_OCT_REQUIRED_DATA_IS_LOGGED1 Restart Process
SP_OCT_TARGET_COMPATIBILITY 8.6.6 Restart Process
SP_OCT_TRUNC_PARTITION_BY_ID 0 booleanLive
sp_ctrl (node1:2100)>
sp_ctrl (node1:2100)>
sp_ctrl (node1:2100)>
sp_ctrl (node1:2100)> set param SP_OCT_REPLICATE_GRANT 1
sp_ctrl (node1:2100)> set param SP_OCT_REPLICATE_TRIGGER 1
sp_ctrl (node1:2100)> set param SP_OCT_REPLICATE_SYNONYM 1
sp_ctrl (node1:2100)>
sp_ctrl (node1:2100)>
sp_ctrl (node1:2100)>
sp_ctrl (node1:2100)>
sp_ctrl (node1:2100)> list param capture
Capture parameters:
ParameterName Actual Value Units Set At
----------------------------------------------------------------------------------------
SP_OCT_ARCH_LOC Live
SP_OCT_ASM_USE_OCI 0 booleanRestart Process
SP_OCT_AUTOADD_ENABLE 1 booleanRestart Process
SP_OCT_AUTOADD_MVIEW 1 booleanRestart Process
Default Value: 0
SP_OCT_AUTOADD_SEQ 1 booleanRestart Process
Default Value: 0
SP_OCT_BIO_CHECKSUM 0 booleanLive
SP_OCT_CHECKPOINT_LOG 2 logs Live
SP_OCT_DATA_OBJ_CACHE_SIZE 50 values Live
SP_OCT_DATE_MSG 0 Live
SP_OCT_DDL_LOGGING 2 Live
SP_OCT_DEF_DAY 1 Live
SP_OCT_DEF_HOUR 0 Live
SP_OCT_DEF_MIN 0 Live
SP_OCT_DEF_MONTH 1 Live
SP_OCT_DEF_SEC 0 Live
SP_OCT_DEF_YEAR 1999 Live
SP_OCT_DENIED_USERID 0x00000000 number Live
SP_OCT_INCLUDE_UNCHANGED_COL 0 booleanLive
SP_OCT_LOG_MEMBER % Restart Process
SP_OCT_LOGWRAP_RESTART 0 secondsLive
SP_OCT_ONELINE_DEBUG Live
SP_OCT_ONELINE_DEBUG_COLUMNS 0 Live
SP_OCT_OPTIMIZE_ROW_MOVEMENT 0 booleanLive
SP_OCT_PREFER_ARCHIVE 0 booleanRestart Process
SP_OCT_REPLICATE_ALL_DDL 0 Live
SP_OCT_REPLICATE_CTAS 1 Restart Process
SP_OCT_REPLICATE_DDL 3 Live
SP_OCT_REPLICATE_DLOAD 1 Live
SP_OCT_REPLICATE_MVIEW 1 booleanRestart Process
SP_OCT_REPLICATE_POSTER 0 Restart Process
SP_OCT_REPLICATE_SEQUENCES 1 booleanRestart Process
SP_OCT_REQUIRED_DATA_IS_LOGGED1 Restart Process
SP_OCT_TARGET_COMPATIBILITY 8.6.6 Restart Process
SP_OCT_TRUNC_PARTITION_BY_ID 0 booleanLive
sp_ctrl (node1:2100)> status
Brief Status for node1
Process State PID Running Since
-------------------------------------------------------------------------
Cop Running 254307-Apr-17 04:46:09
Capture Running 255107-Apr-17 04:46:39
Read Running 255707-Apr-17 04:46:42
Export Running 256607-Apr-17 04:46:44
Cmd & Ctrl Running 267407-Apr-17 05:05:52
System is used as a source machine
There is 1 active configuration file
sp_ctrl (node1:2100)> stop capture
sp_ctrl (node1:2100)> stop read
sp_ctrl (node1:2100)> stop export
sp_ctrl (node1:2100)> start export
sp_ctrl (node1:2100)> start read
sp_ctrl (node1:2100)> start capture
sp_ctrl (node1:2100)>
sp_ctrl (node1:2100)>
sp_ctrl (node1:2100)> status
Brief Status for node1
Process State PID Running Since
-------------------------------------------------------------------------
Cop Running 254307-Apr-17 04:46:09
Capture Running 268907-Apr-17 05:09:50
Read Running 268807-Apr-17 05:09:47
Export Running 268707-Apr-17 05:09:45
Cmd & Ctrl Running 267407-Apr-17 05:05:52
System is used as a source machine
There is 1 active configuration file
sp_ctrl (node1:2100)> list param
Analyze parameters:
ParameterName Actual Value Units Set At
----------------------------------------------------------------------------------------
SP_ANL_CHECKPOINT_FREQ 20000 messageLive
SP_ANL_CHECKPOINT_TIME 120 secondsLive
SP_ANL_LOG_FILESIZE 50000000 bytes Restart Process
SP_ANL_LOG_NUMFILES 3 number Restart Process
SP_ANL_RUN_TIME 4320 number Live
Command and Control parameters:
ParameterName Actual Value Units Set At
----------------------------------------------------------------------------------------
SP_CNC_COMM_TIMEOUT 0 minutesLive
SP_CNC_LOG 0 number Live
Control Process parameters:
ParameterName Actual Value Units Set At
----------------------------------------------------------------------------------------
SP_COP_IDLETIME 60 secondsLive
SP_COP_SCAN_TIMEOUT 300 secondsLive
SP_COP_SO_RCVBUF 0 bytes Restart Cop
Compare/Repair parameters:
ParameterName Actual Value Units Set At
----------------------------------------------------------------------------------------
SP_DEQ_AUTO_REPAIR1 1 booleanLive
SP_DEQ_COPY_CHECK_ROWS 200000 Live
SP_DEQ_IGNORE_ORACLE_ERROR_NUM0 number Live
SP_DEQ_IP_MAPPING Live
SP_DEQ_IP_MAPPING_OPTION 1 number Live
SP_DEQ_LOCK_WAIT 300 secondsLive
SP_DEQ_LOG_FILESIZE 50 MB Live
SP_DEQ_LOG_NUMFILES 3 number Live
SP_DEQ_MALLOC 500 MB Live
SP_DEQ_PADDER 0 number Live
SP_DEQ_PARALLELISM 2 number Live
SP_DEQ_PART_TABLE_UPDATE 0 number Live
SP_DEQ_PARTIAL_REPAIR_CLR_OOS 0 booleanLive
SP_DEQ_QUICK_COMPARE_DEFAULT 0 booleanLive
SP_DEQ_READ_BUFFER_SIZE 1 mbytes Live
SP_DEQ_ROW_LOCK_THRESHOLD 1000 number Live
SP_DEQ_SKIP_LOB 0 booleanLive
SP_DEQ_SWAP_BYTE 0 number Live
SP_DEQ_THREADS 2 threadsLive
SP_DEQ_TIMEOUT 1800 secondsLive
Import parameters:
ParameterName Actual Value Units Set At
----------------------------------------------------------------------------------------
SP_IMP_QUEUE_PAUSE 0 Kmsgs Live
SP_IMP_QUEUE_RESUME 0 Kmsgs Live
Configuration Management parameters:
ParameterName Actual Value Units Set At
----------------------------------------------------------------------------------------
SP_OCF_FK_ANALYSIS 1 booleanLive
SP_OCF_HEAP_NEWLIST 0 booleanLive
SP_OCF_LOCK_WAIT_TIME 5 minutesLive
SP_OCF_LOG_FILESIZE 50000000 bytes Live
SP_OCF_LOG_NUMFILES 3 number Live
SP_OCF_THREAD_COUNT 3 threadsLive
SP_OCF_USE_TEMPSEG_LIMIT 100 tables Live
Capture parameters:
ParameterName Actual Value Units Set At
----------------------------------------------------------------------------------------
SP_OCT_ARCH_LOC Live
SP_OCT_ASM_USE_OCI 0 booleanRestart Process
SP_OCT_AUTOADD_ENABLE 1 booleanRestart Process
SP_OCT_AUTOADD_MVIEW 1 booleanRestart Process
Default Value: 0
SP_OCT_AUTOADD_SEQ 1 booleanRestart Process
Default Value: 0
SP_OCT_BIO_CHECKSUM 0 booleanLive
SP_OCT_CHECKPOINT_LOG 2 logs Live
SP_OCT_DATA_OBJ_CACHE_SIZE 50 values Live
SP_OCT_DATE_MSG 0 Live
SP_OCT_DDL_LOGGING 2 Live
SP_OCT_DEF_DAY 1 Live
SP_OCT_DEF_HOUR 0 Live
SP_OCT_DEF_MIN 0 Live
SP_OCT_DEF_MONTH 1 Live
SP_OCT_DEF_SEC 0 Live
SP_OCT_DEF_YEAR 1999 Live
SP_OCT_DENIED_USERID 0x00000000 number Live
SP_OCT_INCLUDE_UNCHANGED_COL 0 booleanLive
SP_OCT_LOG_MEMBER % Restart Process
SP_OCT_LOGWRAP_RESTART 0 secondsLive
SP_OCT_ONELINE_DEBUG Live
SP_OCT_ONELINE_DEBUG_COLUMNS 0 Live
SP_OCT_OPTIMIZE_ROW_MOVEMENT 0 booleanLive
SP_OCT_PREFER_ARCHIVE 0 booleanRestart Process
SP_OCT_REPLICATE_ALL_DDL 0 Live
SP_OCT_REPLICATE_CTAS 1 Restart Process
SP_OCT_REPLICATE_DDL 3 Live
SP_OCT_REPLICATE_DLOAD 1 Live
SP_OCT_REPLICATE_MVIEW 1 booleanRestart Process
SP_OCT_REPLICATE_POSTER 0 Restart Process
SP_OCT_REPLICATE_SEQUENCES 1 booleanRestart Process
SP_OCT_REQUIRED_DATA_IS_LOGGED1 Restart Process
SP_OCT_TARGET_COMPATIBILITY 8.6.6 Restart Process
SP_OCT_TRUNC_PARTITION_BY_ID 0 booleanLive
Post parameters:
ParameterName Actual Value Units Set At
----------------------------------------------------------------------------------------
SP_OPO_CHANGE_ID_START_VALUE Restart Process
SP_OPO_CONT_ON_ERR 0 Live
SP_OPO_DISABLE_OBJECT_NUM Live
SP_OPO_HINTS_LIMIT 100 hints Restart Process
SP_OPO_MAX_CDA 50 Restart Process
SP_OPO_ONELINE_DEBUG Live
SP_OPO_ONELINE_DEBUG_COLUMNS 0 Live
SP_OPO_OUT_OF_SYNC_SUSPEND 0 Live
SP_OPO_PARSE_TIMEOUT 100 msec Live
SP_OPO_POSTER_DELAY 0 minutesLive
SP_OPO_PRB_MISMATCH_SUSPEND 0 Live
SP_OPO_QUE_REREAD_INTERVAL 1 secondsLive
SP_OPO_READRELEASE_INTERVAL 100 Live
SP_OPO_RETRIES_MAX 10 retriesLive
SP_OPO_SKIP_BAD_MESSAGE 0 Live
SP_OPO_SKIP_FAIL_DDL_ON_RESTAR1 Restart Process
SP_OPO_SQL_CACHE_DISABLE 0 Restart Process
SP_OPO_STOP_ON_DDL_ERR 1 Live
SP_OPO_SYNC_LOG_FREQUENCY 1 Live
SP_OPO_SYNC_STATUS_TIMEOUT 180 SecondsLive
SP_OPO_TRACK_COMMITS 0 Restart Process
SP_OPO_TRACK_OPERATIONS I/U/D Restart Process
SP_OPO_TRACK_PREIMAGE Restart Process
SP_OPO_TRACK_TIME_AS_CHAR 0 Restart Process
SP_OPO_TRUSTED_SOURCE Restart Process
SP_OPO_WAIT_MSG_DELAY 300 secondsRestart Process
Open Post parameters:
ParameterName Actual Value Units Set At
----------------------------------------------------------------------------------------
SP_OPX_CONT_ON_ERR 0 Live
SP_OPX_DEBUG_FLAG 0x00000000 bitflagLive
SP_OPX_DISABLE_OBJECT_NUM Live
SP_OPX_LOG_FILESIZE 50000000 bytes Restart Process
SP_OPX_LOG_NUMFILES 3 number Restart Process
SP_OPX_MAX_CDA 0 Restart Process
SP_OPX_ONELINE_DEBUG Live
SP_OPX_OUT_OF_SYNC_SUSPEND 0 Live
SP_OPX_READRELEASE_INTERVAL 1000 Restart Process
SP_OPX_SQL_CACHE_DISABLE 0 Restart Process
Read parameters:
ParameterName Actual Value Units Set At
----------------------------------------------------------------------------------------
SP_ORD_DATE_MSG 0 Live
SP_ORD_DELAY_RECORDS 200 recordsLive
SP_ORD_DISABLE_OBJECT_NUM Live
SP_ORD_FILTER_OPEN_TGT_DDL 1 Restart Process
SP_ORD_FIRST_FIND 1 Restart Process
SP_ORD_HP_HASH 16 slots Restart Process
SP_ORD_HP_IN_SYNC 0 Restart Process
SP_ORD_ONELINE_DEBUG Live
SP_ORD_ONELINE_DEBUG_COLUMNS 0 Live
SP_ORD_SEND_DDL_TO_FIRST 1 Live
Sync parameters:
ParameterName Actual Value Units Set At
----------------------------------------------------------------------------------------
SP_OSY_COMPRESSION 6 Live
SP_OSY_LOCK_TIMEOUT 2 SecondsLive
SP_OSY_POST_TIMEOUT 1800 SecondsLive
SP_OSY_THREADS 5 Thread Live
SharePlex Queues parameters:
ParameterName Actual Value Units Set At
----------------------------------------------------------------------------------------
SP_QUE_MAX_QUEUES 25 queues Restart Cop
SP_QUE_POST_SHMSIZE 32 Mbytes Restart Cop
SP_QUE_Q_SHMSIZE 8 Mbytes Restart Cop
SP_QUE_SHMDBUF 32768 bytes Restart Cop
SP_QUE_SYNC 2 Restart Cop
Event Logging parameters:
ParameterName Actual Value Units Set At
----------------------------------------------------------------------------------------
SP_SLG_LOG_MAXSIZE 500 mbytes Restart Cop
SP_SLG_SNMP_ACTIVE 0 Restart Cop
SP_SLG_SNMP_COMMUNITY Restart Cop
SP_SLG_SNMP_ENTERPRISE_OID 1.3.6.1.4.1.3.1.1 Restart Cop
SP_SLG_SNMP_ERROR 0 Restart Cop
SP_SLG_SNMP_EXIT 0 Restart Cop
SP_SLG_SNMP_HOST Restart Cop
SP_SLG_SNMP_INT_ERROR 0 Restart Cop
SP_SLG_SNMP_LAUNCH 0 Restart Cop
SP_SLG_SNMP_MJR_ERRNUM 0 Restart Cop
SP_SLG_SNMP_MNR_ERRNUM 0 Restart Cop
SP_SLG_SNMP_OUT_OF_SYNC 0 Restart Cop
SP_SLG_SNMP_SHUTDOWN 0 Restart Cop
SP_SLG_SNMP_STARTUP 0 Restart Cop
SP_SLG_SNMP_SYS_ERROR 0 Restart Cop
SP_SLG_SNMP_TRAP_OID 1.3.6.1.2.1.1.1.0 Restart Cop
SP_SLG_SNMP_TRAP_PROGRAM iwsnmptrap Restart Cop
System parameters:
ParameterName Actual Value Units Set At
----------------------------------------------------------------------------------------
SP_SYS_API_KEY 300d8d80-1aca-11e7-9129-091566695250 Live
SP_SYS_HOST_NAME Restart Cop
SP_SYS_JOB_HISTORY_RETENTION 90 days Live
SP_SYS_LIC_25614 CN0DW1WAVEJG3NCMC4647K0YMEB0SXBJYW:X Install
SP_SYS_SUSPEND_ON_ERROR 1 Live
SP_SYS_VAR_FULL 30 mbytes Live
SP_SYS_VAR_OK 50 mbytes Live
Export parameters:
ParameterName Actual Value Units Set At
----------------------------------------------------------------------------------------
SP_XPT_AES_KEY_LENGTH 128 Restart Process
SP_XPT_ALTERNATE_HOST Restart Process
SP_XPT_ENABLE_AES 0 Restart Process
SP_XPT_ENABLE_COMPRESSION 0 Restart Process
SP_XPT_PCT_DEVIATION 50 Live
SP_XPT_PORT_OVERRIDE 0 Restart Process
SP_XPT_SO_SNDBUF 0 bytes Restart Process
SP_XPT_USE_LOCALHOST 0 Restart Process
sp_ctrl (node1:2100)>
sp_ctrl (node1:2100)>
sp_ctrl (node1:2100)>
sp_ctrl (node1:2100)>
sp_ctrl (node1:2100)> exit
$ sqlplus source/source
SQL*Plus: Release 11.2.0.4.0 Production on Fri Apr 7 05:10:38 2017
Copyright (c) 1982, 2013, Oracle.All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL>
SQL>
SQL> select tname from tab;
TNAME
------------------------------
MV_CUSTMER
T1
T3
USLOG$_MV_CUSTMER
SQL> create synonym tt1 for t1;
Synonym created.
SQL> CREATE TABLE Emp_log (
Emp_id NUMBER,
Log_date DATE,
New_salary NUMBER,
Action VARCHAR2(20));2 3 4 5
Table created.
SQL> create table employees( emp_id number,log_data date,salary number);
Table created.
SQL>CREATE OR REPLACE TRIGGER log_salary_increase
AFTER UPDATE OF salary ON employees
FOR EACH ROW
BEGIN
INSERT INTO Emp_log (Emp_id, Log_date, New_salary, Action)
VALUES (:NEW.employee_id, SYSDATE, :NEW.salary, 'New Salary');
END;
/ .
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
$ sqlplus /nolog
SQL*Plus: Release 11.2.0.4.0 Production on Fri Apr 7 05:19:01 2017
Copyright (c) 1982, 2013, Oracle.All rights reserved.
SQL> grant select on source.t1 to scott;
Grant succeeded.
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
$ ssh node2
oracle@node2's password:
Last login: Fri Apr7 05:05:41 2017 from node1
$ sp_ctrl
*******************************************************
* SharePlex for Oracle Command Utility
* Copyright 2016 Quest Software Inc.
* ALL RIGHTS RESERVED.
* Protected by U.S. Patents: 7,461,103 and 7,065,538
*******************************************************
sp_ctrl (node2:2100)> status
Brief Status for node2
Process State PID Running Since
-------------------------------------------------------------------------
Cop Running 252307-Apr-17 04:46:21
Post Running 297207-Apr-17 05:27:34
Import Running 267707-Apr-17 05:09:45
Cmd & Ctrl Running 298907-Apr-17 05:28:47
Cmd & Ctrl Running 302507-Apr-17 05:30:18
There are no active configuration files
sp_ctrl (node2:2100)> show sql
Last SQL statement of queue node1 and instance o.orcl-o.orcl on node2
Thread Session
------ -------
0 0
/
Thread is initializing : No SQL available yet.
Thread Session
------ -------
2 3
/
grant delete on "TARGET"."T1" to source
Thread Session
------ -------
3 8
/
grant select on "TARGET"."T1" to scott
$ sqlplus source/source
SQL*Plus: Release 11.2.0.4.0 Production on Fri Apr 7 05:41:15 2017
Copyright (c) 1982, 2013, Oracle.All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> select tname from tab;
TNAME
------------------------------
EMPLOYEES
EMP_LOG
MV_CUSTMER
T1
T3
TT1
USLOG$_MV_CUSTMER
7 rows selected.
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
$ ssh node2
oracle@node2's password:
Last login: Fri Apr7 05:30:16 2017 from node1
$ sqlplus target/target
SQL*Plus: Release 11.2.0.4.0 Production on Fri Apr 7 05:41:43 2017
Copyright (c) 1982, 2013, Oracle.All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> select tname from tab;
TNAME
------------------------------
EMPLOYEES
EMP_LOG
MV_CUSTMER
T1
T3
TT1
6 rows selected.
SQL>
2017/4/7 17:32:19
页:
[1]