@set SCNFILE=e:\dump\%ORACLE_SID%.scn

@(
@echo connect %TARGET_CONNECT_STR%  as sysdba;         
@echo set echo off feed off serveroutput on pages 0     
@echo spool %SCNFILE%               
@echo whenever sqlerror exit sql.sqlcode  
@echo exec strmadmin.streams_admin.required_backup_scn;
@echo spool off
@echo exit;                             
) | %SQLPLUS_EXE% -s /nolog > NUL:

if {%ERRORLEVEL%} == {0} (
   @echo   Database    :   %ORACLE_SID% is available        >> %RMAN_LOG_FILE%
   @SET STREAMS_CONNECT=TRUE
) else (
   @echo   Database    :   %ORACLE_SID% is NOT available    >> %RMAN_LOG_FILE%
   @SET STREAMS_CONNECT=FALSE
)

@if exist %SCNFILE% (
@if %STREAMS_CONNECT%==TRUE (
@for /F "tokens=1 " %%a in ('type %SCNFILE%') do set REQUIRED_SCN=%%a
) else (
@set /a REQUIRED_SCN=0)
)

exec strmadmin.streams_admin.required_backup_scn