Oracle DataGuard自动启动脚本

来罐百事可乐

于 2023-03-31 11:03:43 发布

阅读量287

点赞数

文章标签： oracle 数据库

本文链接：https://blog.csdn.net/IIOOHHHSSSS/article/details/129875231

版权

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