e
drwxrwxr-x 2 oracle oinstall 4096 Sep 2 21:02 status
drwxrwxr-x 2 oracle oinstall 4096 Sep 2 21:02 report
drwxrwxr-x 2 oracle oinstall 4096 Sep 2 21:02 params
drwxrwxr-x 2 oracle oinstall 4096 Sep 2 21:02 oosxml
drwxrwxr-x 2 oracle oinstall 4096 Sep 2 21:02 oos
drwxrwxr-x 2 oracle oinstall 4096 Sep 2 21:02 lock
二、源库配置OGG所需环境[源端，目标端]
9、开启归档和附加信息到redo logfile
SQL> alter database add supplemental log data; ----开启附加信息到redo logfile
Database altered.
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount;
ORACLE instance started.
Total System Global Area 2505338880 bytes
Fixed Size 2255832 bytes
Variable Size 620758056 bytes
Database Buffers 1862270976 bytes
Redo Buffers 20054016 bytes
Database mounted.
SQL> alter database archivelog;
Database altered.
SQL> alter database open;
Database altered.
SQL> alter system switch logfile;
System altered.
SQL> /
System altered.
SQL> select SUPPLEMENTAL_LOG_DATA_MIN from v$database;
SUPPLEME
--------
YES
10、创建OGG测试所需表空间及用户
SQL> select tablespace_name,contents from dba_tablespaces;
TABLESPACE_NAME CONTENTS
------------------------------ ---------
SYSTEM PERMANENT
SYSAUX PERMANENT
UNDOTBS1 UNDO
TEMP TEMPORARY
USERS PERMANENT
SQL> select file_name from dba_data_files;
FILE_NAME
--------------------------------------------------------------------------------
/DBData/woo/users01.dbf
/DBData/woo/undotbs01.dbf
/DBData/woo/sysaux01.dbf
/DBData/woo/system01.dbf
SQL> create tablespace ggs datafile \
三、通过刚才创建的用户创建ogg所需的demo
[oracle@source ogg]$ ll /DBSoft/ogg/demo*
-r--r--r-- 1 oracle oinstall 1217 Mar 13 2010 /DBSoft/ogg/demo_more_ora_create.sql
-r--r--r-- 1 oracle oinstall 967 Mar 13 2010 /DBSoft/ogg/demo_more_ora_insert.sql
-r--r--r-- 1 oracle oinstall 883 Mar 13 2010 /DBSoft/ogg/demo_ora_create.sql
-r--r--r-- 1 oracle oinstall 821 Mar 13 2010 /DBSoft/ogg/demo_ora_insert.sql
-r--r--r-- 1 oracle oinstall 4015 Mar 13 2010 /DBSoft/ogg/demo_ora_lob_create.sql
-r--r--r-- 1 oracle oinstall 2275 Mar 13 2010 /DBSoft/ogg/demo_ora_misc.sql
-r--r--r-- 1 oracle oinstall 1269 Mar 13 2010 /DBSoft/ogg/demo_ora_pk_befores_create.sql
-r--r--r-- 1 oracle oinstall 1227 Mar 13 2010 /DBSoft/ogg/demo_ora_pk_befores_insert.sql
-r--r--r-- 1 oracle oinstall 2520 Mar 13 2010 /DBSoft/ogg/demo_ora_pk_befores_updates.sql
SQL> @/DBSoft/ogg/demo_ora_create.sql
Table created.
Table created.
SQL> @/DBSoft/ogg/demo_ora_insert.sql ###target端不需要执行
1 row created.
1 row created.
1 row created.
1 row created.
Commit complete.
11、在源端和目标端查询刚才创建的表
SQL> col object_name format a15
SQL> select object_name,object_type from user_objects;
OBJECT_NAME OBJECT_TYPE
--------------- -------------------
SYS_C0011106 INDEX
TCUSTMER TABLE
TCUSTORD TABLE
SYS_C0011107 INDEX
SQL>
12、仅在源端查询表中所插入的数据，目标端应为空表
SQL> select * from tcustord;
CUST ORDER_DAT PRODUCT_ ORDER_ID PRODUCT_PRICE PRODUCT_AMOUNT TRANSACTION_ID
---- --------- -------- ---------- ------------- -------------- --------------
WILL 30-SEP-94 CAR 144 17520 3 100
JANE 11-NOV-95 PLANE 256 133300 1 100
SQL> select * from tcustmer;
CUST NAME CITY ST
---- ------------------------------ -------------------- --
WILL BG SOFTWARE CO. SEATTLE WA
JANE ROCKY FLYER INC. DENVER CO
SQL>
###Prepare