Oracle 11g DataGuard自動啟動服務

Oracle 11g DataGuard自動啟動服務

Oracle 11g DataGuard自動啟動服務

只為了做的更好
Just to do better

 script name:oracledg

 #!/bin/bash
 #chkconfig: 2345 98 01
 #description: Oracle database dataguard server
 #Starts the oracle database dataguard server
 #If more than four archive no application will be under the mout synchronization
 #make SHEEL :MUXINQNG
 case $1 in

 'start')
 if [ ! -f /var/lock/subsys/oracle ]; then
 prog="listener"
 echo -n $"Starting $prog: "
 su - oracle -c "lsnrctl start" >> /var/log/oracle.log
 RETVAL=$?
 [ $RETVAL -eq 0 ] && echo "success" || echo "failed"

 prog="oracle dataguard"
 echo -n $"Starting $prog: "
 su - oracle -c "sqlplus /nolog" << EOF >> /var/log/oracle.log
 connect / as sysdba
 startup mount
 ! sleep 30
 select name,open_mode,PROTECTION_MODE,DATABASE_ROLE from v\$database;
 select thread#,min(sequence#) no_applied_min,max(sequence#) no_applied_max,count(1) no_applied_all from v\$archived_log where applied='NO' and STANDBY_DEST='NO' and deleted<>'YES' group by thread# order by thread#;
 declare wyyn number;
 begin
  select count(1) into wyyn from v\$archived_log where applied='NO' and standby_dest='NO';
  if wyyn < 5 then
    EXECUTE IMMEDIATE 'alter database open';
 
  EXECUTE IMMEDIATE 'alter database recover managed standby database using current logfile disconnect';
  else

  EXECUTE IMMEDIATE 'alter database recover managed standby database using current logfile disconnect';
 end if;
 end;
 /
 select name,open_mode,PROTECTION_MODE,DATABASE_ROLE from v\$database;
 select applied,count(1) from v\$archived_log where applied='NO'  group by applied;
 exit
 EOF

 RETVAL=$?
 [ $RETVAL -eq 0 ] && echo "success" || echo "failed"
 echo
 [ $RETVAL -eq 0 ] && touch /var/lock/subsys/oracle || RETVAL=1
 fi
 ;;
 'stop')
 prog="listener"
 echo -n $"Stopping $prog: "
 su - oracle -c "lsnrctl stop" >> /var/log/oracle.log
 RETVAL=$?
 [ $RETVAL -eq 0 ] && echo "success" || echo "failed"
 echo
 prog="oracle dataguard"
 echo -n $"Stopping $prog: "
 su - oracle -c "sqlplus /nolog" << EOF >> /var/log/oracle.log
 connect / as sysdba
 alter database recover managed standby database cancel;
 shutdown immediate
 exit
 EOF
 RETVAL=$?
 [ $RETVAL -eq 0 ] && echo "success" || echo "failed"
 echo
 [ $RETVAL -eq 0 ] && rm -f /var/lock/subsys/oracle
 ;;
 'restart')

 prog="oracle dataguard"
 echo -n $"Stopping $prog: "
 $0 stop

 prog="oracle dataguard"
 echo -n $"Starting $prog: "
 $0 start
 ;;
 'status')

 su - oracle -c "lsnrctl status"
 su - oracle -c "sqlplus /nolog" << EOF
 connect / as sysdba
 select name,open_mode,PROTECTION_MODE,DATABASE_ROLE from v\$database;
 select process,status from v\$managed_standby;
 exit
 EOF
 ;;
 *)
 echo $"Usage: $0 {start|stop|restart|status}"
 ;;
 esac