|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 |
###########################정지하는 쉘 stop_db.sh ## ORACLE Listener STOP ## su - oracle -c ""<오라클 홈 기술>/bin/lsnrctl stop listener"" ## ORACLE Connection Kill ## ps -ef |grep LOCAL|grep oracle|grep -v grep |awk '{print $2}'|xargs kill -9 ## ORACLE Shutdown ## su - oracle -c "/oracle/product/11.2.0/bin/sqlplus '/as sysdba' < /oracle/shutdown_abort.sql" ###########################기동하는 쉘 (VIP 가 올라온 상태 + disk mount 상태에서 기동되어야 함) start_db.sh ## ORACLE Startup ## su - oracle -c "/oracle/product/11.2.0/bin/sqlplus '/as sysdba' < /oracle/recover_startup.sql" ## ORACLE Listener START ## su - oracle -c ""<오라클홈>/bin/lsnrctl start listener"" ## recover_startup.sql startup mount ; ALTER DATABASE RECOVER AUTOMATIC DATABASE ; alter database open ; ## shutdown_abort.sql alter system checkpoint ; alter system checkpoint ; alter system checkpoint ; shutdown abort ; |