Steps to take Cold Bakup on tape drive

1 - Stop Application
============
1) Open putty

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

3) Set the production enviornment
$ cd /d03/oracle/DEV_NEW/apps/apps_st/appl
$ . APPS_testerp.env

4) Stop the application
$ cd $INST_TOP/admin/scripts
$ sh adstpall.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


2 - Stop Database
============
1) Open putty

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

3) Set the production enviornment
$ cd /d03/oracle/DEV_NEW/db/tech_st/10.2.0
$ . DEV_NEW_testerp.env

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

5) Stop the Database Instance
$ 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_

7) exit


3 - Cold Backup (tape drive)
================
tar cvf /dev/rmt/0m /d03/oracle/DEV_NEW/apps /d03/oracle/DEV_NEW/inst /d03/oracle/DEV_NEW/db 

Regards,

Sukhwinder Singh