| Scripts to abort if parent database is not available. [message #400369] |
Mon, 27 April 2009 22:28  |
imkaushik
Messages: 1
Registered: April 2009
|
Junior Member |
|
|
Hi Oracle Gurus.
I have below script, here i want to add a piece of code which actually check and abort script if parent database (TEST) is not available.
Can you please guide me or modified below script.
# Log into "TEST" database and run the scripts to refresh from the
# standby database which now should be open in read only mode -
echo "`date` : Starting refresh of user_rep schema...."
export ORACLE_SID=TEST
sqlplus /nolog <<EOF
connect user_rep/password
set echo on
spool $SPOOL_FILE append
@user_rep.refresh.sql
spool off
EOF
Thanks in advanced.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
