streams capture issue after cloning database
edited Jun 21, 2013 8:06AM in GoldenGate, Streams and Distributed Database (MOSC) 3 commentsAnswered
hello,
i have 2 databases with oracle streams, and to create a training environment i stopped both, made a cold backup and moved it to new server.
but now , streams is not working anymore due to path : see example bellow :
SELECT r.CONSUMER_NAME,
r.NAME,
r.FIRST_SCN,
r.NEXT_SCN,
r.PURGEABLE
FROM DBA_REGISTERED_ARCHIVED_LOG r, DBA_CAPTURE c
WHERE r.CONSUMER_NAME = c.CAPTURE_NAME;
MY_CAPTURE
/oradata/instance/archlogs/1_147311_722876427.dbf
8.0829E+10 8.0829E+10 NO
MY_CAPTURE
/oradata/instance/archlogs/1_147312_722876427.dbf
8.0829E+10 8.0829E+10 NO
but in this new server. i moved the archives to /oradata/new_instance/archlogs/
i have 2 databases with oracle streams, and to create a training environment i stopped both, made a cold backup and moved it to new server.
but now , streams is not working anymore due to path : see example bellow :
SELECT r.CONSUMER_NAME,
r.NAME,
r.FIRST_SCN,
r.NEXT_SCN,
r.PURGEABLE
FROM DBA_REGISTERED_ARCHIVED_LOG r, DBA_CAPTURE c
WHERE r.CONSUMER_NAME = c.CAPTURE_NAME;
MY_CAPTURE
/oradata/instance/archlogs/1_147311_722876427.dbf
8.0829E+10 8.0829E+10 NO
MY_CAPTURE
/oradata/instance/archlogs/1_147312_722876427.dbf
8.0829E+10 8.0829E+10 NO
but in this new server. i moved the archives to /oradata/new_instance/archlogs/
0