Oracle DataGuard自动启动脚本

最新推荐文章于 2024-12-06 23:25:55 发布

原创最新推荐文章于 2024-12-06 23:25:55 发布 · 411 阅读

CC 4.0 BY-SA版权

文章标签：

DG备端开机自启动
[root@dg ~]# cat /etc/init.d/oracle_dataguard.sh 
#!/bin/bash
#
# chkconfig: 345 99 10
# description: Oracle Database and DataGuard startup script
#
# processname: oracle_dataguard
# pidfile: /var/run/oracle_dataguard.pid
#
# Set ORACLE_HOME to be equivalent to the $ORACLE_HOME
# from which you wish to execute dbstart and dbshut;
#
ORACLE_HOME=/u01/app/oracle/product/11.2.0.3/dbhome_1
ORACLE_USER=oracle      # 修改此处，将hjj替换为适当的Oracle用户名
PATH=$PATH:$ORACLE_HOME/bin
export ORACLE_HOME PATH

case "$1" in
   start)
      echo "Starting Oracle Database and DataGuard services..."
      su $ORACLE_USER -c "$ORACLE_HOME/bin/dbstart $ORACLE_HOME"
      su $ORACLE_USER -c "$ORACLE_HOME/bin/lsnrctl start"
      su $ORACLE_USER -c "$ORACLE_HOME/bin/sqlplus sys/pagedown@dg as sysdba <<EOF
      startup;
      alter database recover managed standby database using current logfile disconnect from session;
      exit;
EOF"
      ;;
esac

exit 0

[root@dg init.d]# chmod +x /etc/init.d/oracle_dataguard.sh
[root@dg init.d]# chkconfig --add oracle_dataguard.sh
[root@dg init.d]# chkconfig --level 345 oracle_dataguard.sh on
[root@dg ~]# cat  /etc/rc.local    
#!/bin/sh
#
# This script will be executed *after* all the other init scripts.
# You can put your own initialization stuff in here if you don't
# want to do the full Sys V style init stuff.

touch /var/lock/subsys/local
/etc/init.d/oracle_dataguard.sh start
[root@dg ~]# 
[root@dg ~]# chmod +x /etc/rc.local