Replicate between objects on the same system 强制创建export import 测试
Xshell 5 (Build 1124)Copyright (c) 2002-2017 NetSarang Computer, Inc. All rights reserved.
Type `help' to learn how to use Xshell prompt.
$
Connecting to 192.168.1.55:22...
Connection established.
To escape to local shell, press 'Ctrl+Alt+]'.
Last login: Wed Apr5 21:03:23 2017 from 192.168.1.1
# su- oracle
$ sqlplus /nolog
SQL*Plus: Release 10.2.0.5.0 - Production on Sat Apr 8 04:08:34 2017
Copyright (c) 1982, 2010, Oracle.All Rights Reserved.
SQL> connect /as sysdba
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area599785472 bytes
Fixed Size 2098112 bytes
Variable Size 163580992 bytes
Database Buffers 427819008 bytes
Redo Buffers 6287360 bytes
Database mounted.
Database opened.
SQL> !lsnrctl start
LSNRCTL for Linux: Version 10.2.0.5.0 - Production on 08-APR-2017 04:08:52
Copyright (c) 1991, 2010, Oracle.All rights reserved.
Starting /u01/app/oracle/product/10.2.0/db_1/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 10.2.0.5.0 - Production
System parameter file is /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
Log messages written to /u01/app/oracle/product/10.2.0/db_1/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=middle)(PORT=1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC0)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=middle)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 10.2.0.5.0 - Production
Start Date 08-APR-2017 04:08:53
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
Listener Log File /u01/app/oracle/product/10.2.0/db_1/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=middle)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC0)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "orcl" has 1 instance(s).
Instance "orcl", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
SQL> alter system register;
System altered.
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
$ sp_cop &
4259
$
*******************************************************
* SharePlex for Oracle Startup
* Copyright 2016 Quest Software Inc.
* ALL RIGHTS RESERVED.
* Protected by U.S. Patents: 7,461,103 and 7,065,538
* Version: 8.6.6.64-m64-oracle100
* VarDir : /u01/app/oracle/vardir2100
* Port : 2100
*******************************************************
$ 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 (middle:2100)>
sp_ctrl (middle:2100)> status
Brief Status for middle
Process State PID Running Since
-------------------------------------------------------------------------
Cop Running 425908-Apr-17 04:09:08
Capture Stopped by user
Read Stopped by user
Post Stopped by user
Cmd & Ctrl Running 426208-Apr-17 04:09:16
System is used as a source machine
There is 1 active configuration file
sp_ctrl (middle:2100)> start capture
sp_ctrl (middle:2100)> start read
sp_ctrl (middle:2100)> start post
sp_ctrl (middle:2100)> status
Brief Status for middle
Process State PID Running Since
-------------------------------------------------------------------------
Cop Running 425908-Apr-17 04:09:08
Capture Running 426308-Apr-17 04:09:21
Read Running 427508-Apr-17 04:09:26
Post Running 429608-Apr-17 04:09:29
Cmd & Ctrl Running 426208-Apr-17 04:09:16
System is used as a source machine
There is 1 active configuration file
sp_ctrl (middle:2100)>
sp_ctrl (middle:2100)>
sp_ctrl (middle:2100)> list config
File Name State Datasource
---------------------------------------------------------------------------
ORA_config Inactive o.SOURCE_SID
Last Modified At: 05-Apr-17 21:22 Size: 151
test Active o.orcl
Last Modified At: 05-Apr-17 21:37 Size: 206 Internal Name: .conf.1
sp_ctrl (middle:2100)> view config test
datasource:o.orcl
#source tables target tables routing map
splex.demo_src splex.demo_dest [email protected]_sid
source.t1 target.t1 [email protected]
sp_ctrl (middle:2100)>
sp_ctrl (middle:2100)>
sp_ctrl (middle:2100)>
sp_ctrl (middle:2100)>
sp_ctrl (middle:2100)> stop capture
sp_ctrl (middle:2100)> stop read
sp_ctrl (middle:2100)> stop post
sp_ctrl (middle:2100)> shutdown
$ cd /u01/app/oracle/vardir2100/config/
+Done sp_cop(wd: ~)
(wd now: /u01/app/oracle/vardir2100/config)
$ ls
ORA_configtest
$ vi test
$ cat test
datasource:o.orcl
#source tables target tables routing map
splex.demo_src splex.demo_dest [email protected]_sid
expand source.% target.% middle*[email protected]
$ 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 (middle:2100)> status
Brief Status for middle
Process State PID Running Since
-------------------------------------------------------------------------
Cop Running 444108-Apr-17 04:15:16
Capture Stopped by user
Read Stopped by user
Post Stopped by user
Cmd & Ctrl Running 444308-Apr-17 04:15:19
System is used as a source machine
There is 1 active configuration file
sp_ctrl (middle:2100)> list config
File Name State Datasource
---------------------------------------------------------------------------
ORA_config Inactive o.SOURCE_SID
Last Modified At: 05-Apr-17 21:22 Size: 151
test Active o.orcl
Last Modified At: 05-Apr-17 21:37 Size: 212 Internal Name: .conf.1
sp_ctrl (middle:2100)> deactivate config test
sp_ctrl (middle:2100)> activate config test
Not all tables activated successfully
sp_ctrl (middle:2100)> status
Brief Status for middle
Process State PID Running Since
-------------------------------------------------------------------------
Cop Running 444108-Apr-17 04:15:16
Capture Stopped by user
Read Stopped by user
Post Stopped by user
Cmd & Ctrl Running 444308-Apr-17 04:15:19
System is used as a source machine
There is 1 active configuration file
sp_ctrl (middle:2100)> start capture
sp_ctrl (middle:2100)> start read
sp_ctrl (middle:2100)> start post
sp_ctrl (middle:2100)> status
Brief Status for middle
Process State PID Running Since
-------------------------------------------------------------------------
Cop Running 444108-Apr-17 04:15:16
Capture Running 446608-Apr-17 04:16:40
Read Running 447408-Apr-17 04:16:43
Post Running 449408-Apr-17 04:16:46
Cmd & Ctrl Running 444308-Apr-17 04:15:19
Export Running 449908-Apr-17 04:16:47
Import Running 450008-Apr-17 04:16:47
System is used as a source machine
There is 1 active configuration file
sp_ctrl (middle:2100)> view config test
datasource:o.orcl
#source tables target tables routing map
splex.demo_src splex.demo_dest [email protected]_sid
expandsource.% target.% middle*[email protected]
页:
[1]