‘Archivelog-name’ FOR ‘Capture-name’;
sqlplus /nolog
connect / as sysdba
alter system set events ‘26700 trace name context forever, level 6’;
alter system set events ‘1349 trace name context forever , level 1024’;
exit
sqlplus strmadmin/passwd (streams admin)
exec dbms_capture_adm.set_parameter(‘yourcapturename’,’trace_level’,’127′);
exec dbms_capture_adm.start_capture(‘yourcapturename’);
sqlplus strmadmin/passwd (streams admin)
Stop the capture(DBMS_CAPTURE_ADM.STOP_CAPTURE)
exec dbms_capture_adm.set_parameter(‘yourcapturename’,’trace_level’,null);
exit
sqlplus /nolog
connect / as sysdba
alter system set events ‘26700 trace name context off’;
alter system set events ‘1349 trace name context off’;
exit
1. Stop the capture(DBMS_CAPTURE_ADM.STOP_CAPTURE)
“set trace off after 10-15 mins”:
exec dbms_capture_adm.set_parameter(‘yourcapturename‘,’trace_level’,null);
COLUMN SOURCE_DATABASE HEADING ‘Source|Database’ FORMAT A10
COLUMN SEQUENCE# HEADING ‘Sequence|Number’ FORMAT 99999
COLUMN NAME HEADING ‘Required|Archived Redo Log|File Name’ FORMAT A40
SELECT r.CONSUMER_NAME,
r.SOURCE_DATABASE,
r.SEQUENCE#,
r.NAME
FROM DBA_REGISTERED_ARCHIVED_LOG r, DBA_CAPTURE c
WHERE r.CONSUMER_NAME = c.CAPTURE_NAME AND
r.NEXT_SCN >= c.REQUIRED_CHECKPOINT_SCN
order by 3;
APPLY_FROM_MARKA 4.23.369085 5600212761449 17-OCT-11 1 18-OCT-11
APPLY_FROM_MARKA 56.17.156892 5600242177417 18-OCT-11 1 18-OCT-11
APPLY_FROM_MARKA 4.40.369226 5600243099471 18-OCT-11 1 18-OCT-11
APPLY_FROM_MARKA 24.21.419884 5600247380679 18-OCT-11 15 19-OCT-11
APPLY_FROM_MARKA 14.20.166840 5600278453686 19-OCT-11 1 19-OCT-11
2-exec dbms_apply_adm.set_parameter(‘Apply-process-name’,’_ignore_transaction’,’TXN-Number’);
3-exec sys.purge_spill_txn(‘Apply-process-name’,’TXN-Number’);
4-exec dbms_apply_adm.start_apply(‘Apply-process-name’);
5-exec dbms_apply_adm.set_parameter(‘Apply-process-name’,’_ignore_transaction’,null);
Capture Site:
1-execute dbms_capture_adm.stop_capture(‘capture-Process-name’);
2-execute dbms_capture_adm.set_parameter(‘capture-Process-name’,’_ignore_transaction’,’TXN-Number’);
3-execute dbms_capture_adm.start_capture(‘capture-Process-name’);
exec dbms_capture_adm.set_parameter(‘Capture-procees-name’,’_SGA_SIZE’,’50’);
exec dbms_capture_adm.start_capture(‘Capture-procees-name’);
The above changes space for named capture process : ‘STRMADMIN_CAPTURE’ from 10M -> 50M