Flashback script under Linux

A customer is concerned about the recovery of logical errors. The solution we recommend to him is to use flashback technology on the disaster recovery library. The following is a simple Linux script.

#!/bin/bash

export LOGIN_USER=test

export LOGIN_PWD=test

############ ############################################################################################# )

{

echo -e "enter scn:\\c"

read SCNNUM

STR1="flashback table $OWNER.$TABLE_NAME To scn $SCNNUM;"

echo $STR1

T1=`sqlplus -silent $LOGIN_USER/$LOGIN_USER "EOF

set pagesize 0 feedback off verify off heading off Echo off

alter table $OWNER.$TABLE_NAME enable row movement;

$STR1

alter table $OWNER.$TABLE_NAME disable row movement;

EOF`

if [ -z "$T1" ];then

echo "######"

echo "flashback table $TABLE_NAME OK!"

else

echo "######"

echo "flashback tabel $TABLE_NAME error:"

echo $T1 | Awk -F "ORA-" '{print "ORA-" $NF}'

fi

}

flashtime()

{

echo -e "enter time (example 2014-05-18 20:34:21):\\c"

read STIME

STR2=" Flashback table $OWNER.$TABLE_NAME to timestamp to_timestamp('$STIME','yyyy-mm-dd hh24:mi:ss');"

echo $STR2

T2=` Sqlplus -silent $LOGIN_USER/$LOGIN_USER "EOF

set pagesize 0 feedback off verify off heading off echo off

alter table $OWNER.$TABLE_NAME enable row movement;

$STR2

alter table $OWNER.$TABLE_NAME disable row movement;

EOF`

if [ -z "$T2" ];then

echo "######"

echo "flashback table $TABLE_NAME OK!"

else

echo "##### #"

echo "flashback tabel $TABLE_NAME error:"

echo $T2 | Awk -F "ORA-" '{print "ORA-" $NF}'

fi

}

######## ####################################################################################### ################################################################################################### \\c"

read OWNER

echo -e "enter flashbackup table name:\\c"

read TABLE_NAME

echo -e "chose Flashback type 1)time 2)scn 1\\2 :\\c"

read STYPE

case $STYPE in

1)

flashtime

;;

2)

flashscn

;;

*)

echo "your enter is error ,please enter 1 or 2 !!!"

exit

;;

esac