[oracle] Add the SCHEMA_ONLY_RECOVERY snapshot mode

I think the oracle connector needs the SCHEMA_ONLY_RECOVERY snapshot mode, just like mysql-connector.

In the case of a debezium migration or other failure, it is necessary to allow a specific location to recover and read the redo log.

In fact, I have completed the basic code development, but there is a lack of unit tests that conform to the community style.