由集成模式转换为普通模式就是由普通模式转换成集成模式的逆过程。直接上代码,不解释
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT ABENDED DPEMO 00:00:00 2494:48:53
EXTRACT ABENDED DPETS 00:00:00 2494:48:54
EXTRACT RUNNING EXTMO 00:00:24 00:00:02
EXTRACT RUNNING EXTTS 00:00:03 00:00:02
GGSCI (og1) 64> alter extract extts ,downgrade tranlog
ERROR: EXTRACT EXTTS is running and cannot be altered (1,11,Resource temporarily unavailable).
GGSCI (og1) 65> stop extts
Sending STOP request to EXTRACT EXTTS ...
Request processed.
GGSCI (og1) 66> alter extract extts ,downgrade tranlog
Extract EXTTS successfully downgraded from integrated capture.
GGSCI (og1) 67> unregister extract extts database
2017-07-19 07:42:22 INFO OGG-01750 Successfully unregistered EXTRACT EXTTS from database.
GGSCI (og1) 68> start extts
Sending START request to MANAGER ...
EXTRACT EXTTS starting
GGSCI (og1) 69> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT ABENDED DPEMO 00:00:00 2494:59:26
EXTRACT ABENDED DPETS 00:00:00 2494:59:27
EXTRACT RUNNING EXTMO 00:00:10 00:00:03
EXTRACT RUNNING EXTTS 00:00:00 00:00:00