1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!
samm_777

How stop oracle apps and take cold backup 2010-11-02

How stop oracle apps and take cold backup

  1. samm_777
    Stop Application
    ============
    1) Open putty
    2) Login to server using application user e.g. applmgr
    Login as : applmgr
    password : applmgr
    3) Set the production enviornment
    $ cd /u01/apps/apps_st/appl
    $ ../PROD_prod.env

    4) Stop the application
    $ cd $INST_TOP/admin/scripts
    $ sh adstrtal.sh apps/apps
    5) verify the TNS listner, Concurrent Manager & Oracle HTTP Server is down sucessfully.
    To check :
    a) TNS listner
    $ ps -ef|grep tns
    b) Concurrent Manager
    $ ps -ef|grep FNDLIBR
    c) Oracle HTTP Server
    $ sh adapcctl.sh status
    6) exit

    Stop Database
    ============

    1) Open putty

    2) Login to server using application user e.g. oramgr
    Login as : oramgr
    password : oramgr

    3) Set the production enviornment
    $ cd /u03/db/tech_st/10.2.0
    $ ../PROD_prod.env

    4) Stop the DB Listner
    $ cd $ORACLE_HOME/appsutil/scripts/PROD_prod
    $ sh addlnctl.sh stop PROD

    5) $ sqlplus "/as sysdba"
    SQL> shutdown immediate

    6) verify the TNS listner, DB is down sucessfully.
    To check :
    a) TNS listner
    $ ps -ef|grep tns
    b) Database
    $ ps -ef|grep ora_
    5) exit


    Cold Backup (tape drive)
    ================
    tar cvf /dev/rmt/0m /u01/apps /u02/inst /u03/db