Ask Your Question

online catalogue SCN number

asked 2020-08-13 07:26:12 -0500

AC gravatar image

Hello, It is not linked directly Streamsets, but I need to find oldest SCN number exists in archieve log in ORACLE. In my company, data is backup at nights then whole scn numbers are not existed in archieve log anymore. After backup new scn numbers are stored. I need that SCN number stored in archieve log in order to start CDC pipeline from when I got error . I hope I defined my concern. Regards.

edit retag flag offensive close merge delete

1 Answer

Sort by ยป oldest newest most voted

answered 2020-08-14 08:30:21 -0500

KateF gravatar image

Here is a link to an Oracle community post about finding SCN numbers in different circumstances, and you can also read the Oracle documentation for your version.

edit flag offensive delete link more



Thank you for your help.

AC gravatar imageAC ( 2020-08-17 01:09:31 -0500 )edit
Login/Signup to Answer

Question Tools



Asked: 2020-08-13 07:26:12 -0500

Seen: 175 times

Last updated: Aug 14