Restoring Oracle Applications Backup

You have a backup and something happened to your Oracle Applications so you need to restore the backup. This restore process assumes that your Oracle Application instance is still exist, including Oracle services.
To restore the applications, make sure no Oracle services is running, including the database.
Use this script to shutdown entire applications (copy and run it on command window):

CALL e:\oracle\itb2comn\admin\scripts\ITB2\adstpall.cmd

(remember to change all itb2 or ITB2 to your instance name).



Then use this sql script to shutdown the database (save it as c:\shutdown.sql):

connect internal
shutdown immediate
exit

Run this script on windows command:

CALL e:\oracle\itb2db\8.1.7\ITB2.cmd
SET ORACLE_SID=ITB2
svrmgrl @c:\shutdown.sql
net stop "OracleServiceITB2"

(please change itb2 or ITB2 to your instance name).

Copy the backup to the existing Oracle Applications directory. There may be some overwrite errors during this copy process, just ignore them.

After the copy process completed, start up your database using this command on windows command:

net start "OracleServiceITB2"

Then start all Oracle Services using this command:

CALL e:\oracle\itb2comn\admin\scripts\ITB2\adstrtal.cmd