Home » Infrastructure » Linux » Scripts to abort if parent database is not available. (Oracle 11 g, ubuntu)
Scripts to abort if parent database is not available. [message #400369] Mon, 27 April 2009 22:28 Go to next message
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.
Re: Scripts to abort if parent database is not available. [message #400392 is a reply to message #400369] Tue, 28 April 2009 00:44 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Do not cross/multi-post
Previous Topic: Free linux download
Next Topic: How to install Oracle 9i on RHEL 4.0
Goto Forum:
  


Current Time: Thu Mar 28 12:09:51 CDT 2024