#!/bin/bash
#get archived log name and create reg_arc.sql
#ftp upload archived log to standby
#will create get_arc_name.tmp reg_name.sql reg_arc.sql three file

#get the latest sequence number from standby database
echo standby_arc.sh start time is `date` running......
values=`sqlplus -silent "sys/linyuyang@standby as sysdba"<< END
set pagesize 0 feedback off verify off heading off echo off
select max(sequence#) from v\\\$archived_log  where stamp=(select max(stamp) from v\\\$archived_log);
exit;
end`
length=`echo $values | awk '{printf("%d",length($1))}'`
echo sequence length is $length
if [ $length -gt 3 ]
then
echo ORA-02 unable to connect to standby oracle please check standby database isok
exit;
else
#get need register archivelog name and create reg_arc.sql script
sqlplus / as sysdba</dev/null
set pagesize 0 feedback off verify off heading off echo off
spool get_arc_name.tmp
select name from v\$archived_log where DEST_ID=1 AND completion_time>=sysdate-1 and sequence#>$values;
spool off

spool reg_name.sql
set pages 0
set feedback off
set linesize 83
select 'alter database register physical logfile '''||name||''';' from v\$archived_log where DEST_ID=1 AND completion_time>=sysdate-1 and sequence#>$values;
spool off
exit
EOF
#modify reg_name.sql to the propery sql script
sed '/SQL/d' reg_name.sql>reg_arc.sql

# ftp upload archivelog
ftp -i -n <open 192.168.1.148
user oracle oracle

cd /home/oracle/archive
bin
$(sed '/SQL/d' get_arc_name.tmp|sed 's/^/mput /')
mput reg_arc.sql
bye
EOF
fi
echo standby_arc.sh stop time is `date` end