oracle dba 精通dataguard,goldengate,mview等技术,擅长于数据库管理,备份恢复,性能调优,熟悉mysql,sqlserver的数据库,了解存储,善于shell编程
分类: Oracle
2013-05-18 21:04:06
L_DIR_NAME=`dirname $0`
LOG=$PWD/startup.$(date +%Y%m%d%H%M%S).log
export ORACLE_BASE=/oracle
export ORACLE_HOME=$ORACLE_BASE/product/ods/10.2.0/Db_1
export PATH=$ORACLE_HOME/bin:/bin:/usr/bin:/etc
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
$ORACLE_HOME/bin/lsnrctl start >> $LOG 2>&1
export ORACLE_SID=orcl
echo "Start Oracle DataBase $ORACLE_SID Begin" >>$LOG
$ORACLE_HOME/bin/sqlplus /nolog <
connect / as sysdba
startup
alter database recover managed standby database disconnect;
quit
EOF
export ORACLE_SID=orcl2
echo "Start Oracle DataBase $ORACLE_SID Begin" >>$LOG
$ORACLE_HOME/bin/sqlplus /nolog <
connect / as sysdba
startup
alter database recover managed standby database disconnect;
quit
EOF
echo "Start Oracle DataBase $ORACLE_SID End" >>$LOG