FROM primary server
. /etc/profile.d/oracle.sh
ssh STANTBY_SSH 'printf "%s\nexit" "select * from V\$ARCHIVE_GAP;"|sqlplus / as sysdba' | grep -P "\s+\d+\s+\d+\s+\d+" | awk '{print "restore archivelog from sequence "$2" until sequence "$3"
thread "$1";\nexit"}' | /opt/grid/bin/rman target /
. /etc/profile.d/oracle.sh
ssh STANTBY_SSH 'printf "%s\nexit" "select * from V\$ARCHIVE_GAP;"|sqlplus / as sysdba' | grep -P "\s+\d+\s+\d+\s+\d+" | awk '{print "restore archivelog from sequence "$2" until sequence "$3"
thread "$1";\nexit"}' | /opt/grid/bin/rman target /
Комментариев нет:
Отправить комментарий