Disastar recovery setup

Purpose : DC to DR Instance Change
TASK-1:- Workaround at DC
Shutdown Process:

To Shutdown the ERP at first you have to stop in the following order.
1. Application
2. Listener
3. Database

For Application Shutdown login on 1.1.1.13 server as applmgr user.

login as: applmgr
Password:
Last login: Tue May 12 16:24:09 2009 from 172.16.67.124
(c)Copyright 1983-2003 Hewlett-Packard Development Company, L.P.
(c)Copyright 1979, 1980, 1983, 1985-1993 The Regents of the Univ. of California
(c)Copyright 1980, 1984, 1986 Novell, Inc.
(c)Copyright 1986-2000 Sun Microsystems, Inc.
(c)Copyright 1985, 1986, 1988 Massachusetts Institute of Technology
(c)Copyright 1989-1993 The Open Software Foundation, Inc.
(c)Copyright 1990 Motorola, Inc.
(c)Copyright 1990, 1991, 1992 Cornell University
(c)Copyright 1989-1991 The University of Maryland
(c)Copyright 1988 Carnegie Mellon University
(c)Copyright 1991-2003 Mentat Inc.
(c)Copyright 1996 Morning Star Technologies, Inc.
(c)Copyright 1996 Progressive Systems, Inc.


RESTRICTED RIGHTS LEGEND
Use, duplication, or disclosure by the U.S. Government is subject to
restrictions as set forth in sub-paragraph (c)(1)(ii) of the Rights in
Technical Data and Computer Software clause in DFARS 252.227-7013.


Hewlett-Packard Company
3000 Hanover Street
Palo Alto, CA 94304 U.S.A.

Rights for non-DOD U.S. Government Departments and Agencies are as set
forth in FAR 52.227-19(c)(1,2).
You have mail.
$ cd /u/inst/apps/PROD_erpapps/admin/scripts/
$ ./adstpall.sh USERNAME/PASSWORD

Check that Exiting with status is 0 always to ensure that everything is started Properly.



For Database and Listener shutdown login on 1.1.1.12 server with applmgr user.

login as: applmgr
Password:
Last login: Tue May 12 12:38:56 2009
(c)Copyright 1983-2003 Hewlett-Packard Development Company, L.P.
(c)Copyright 1979, 1980, 1983, 1985-1993 The Regents of the Univ. of California
(c)Copyright 1980, 1984, 1986 Novell, Inc.
(c)Copyright 1986-2000 Sun Microsystems, Inc.
(c)Copyright 1985, 1986, 1988 Massachusetts Institute of Technology
(c)Copyright 1989-1993 The Open Software Foundation, Inc.
(c)Copyright 1990 Motorola, Inc.
(c)Copyright 1990, 1991, 1992 Cornell University
(c)Copyright 1989-1991 The University of Maryland
(c)Copyright 1988 Carnegie Mellon University
(c)Copyright 1991-2003 Mentat Inc.
(c)Copyright 1996 Morning Star Technologies, Inc.
(c)Copyright 1996 Progressive Systems, Inc.


RESTRICTED RIGHTS LEGEND
Use, duplication, or disclosure by the U.S. Government is subject to
restrictions as set forth in sub-paragraph (c)(1)(ii) of the Rights in
Technical Data and Computer Software clause in DFARS 252.227-7013.


Hewlett-Packard Company
3000 Hanover Street
Palo Alto, CA 94304 U.S.A.

Rights for non-DOD U.S. Government Departments and Agencies are as set
forth in FAR 52.227-19(c)(1,2).

$ sqlplus /nolog

SQL*Plus: Release 10.2.0.2.0 - Production on Thu May 14 19:18:25 2009

Copyright (c) 1982, 2005, Oracle. All Rights Reserved.

SQL> conn / as sysdba
Connected.
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
$ lsnrctl stop ABC
LSNRCTL for HPUX: Version 10.2.0.2.0 - Production on 14-MAY-2009 19:19:50

Copyright (c) 1991, 2005, Oracle. All rights reserved.

Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROCABC))
The command completed successfully
$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.2.0 - Production on Thu May 14 19:20:00 2009

Copyright (c) 1982, 2005, Oracle. All Rights Reserved.

Connected to an idle instance.

SQL> startup
ORACLE instance started.

Total System Global Area 1077936128 bytes
Fixed Size 2049464 bytes
Variable Size 427821640 bytes
Database Buffers 633339904 bytes
Redo Buffers 14725120 bytes
Database mounted.
Database opened.
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.2.0 - Production on Thu May 14 19:20:28 2009

Copyright (c) 1982, 2005, Oracle. All Rights Reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options

SQL> shutdown normal
Database closed.
Database dismounted.
ORACLE instance shut down.

TASK 2:- Workaround at DR
Startup Process:
To Start the ERP at first you have to start in the following order.
1. Database
2. Listener
3. Application

For Database and Listener startup login on 1.1.1.36 server with applmgr user.

Screen Output:

login as: applmgr
Password:
Last login: Mon May 11 19:53:35 2009 from
(c)Copyright 1983-2003 Hewlett-Packard Development Company, L.P.
(c)Copyright 1979, 1980, 1983, 1985-1993 The Regents of the Univ. of California
(c)Copyright 1980, 1984, 1986 Novell, Inc.
(c)Copyright 1986-2000 Sun Microsystems, Inc.
(c)Copyright 1985, 1986, 1988 Massachusetts Institute of Technology
(c)Copyright 1989-1993 The Open Software Foundation, Inc.
(c)Copyright 1990 Motorola, Inc.
(c)Copyright 1990, 1991, 1992 Cornell University
(c)Copyright 1989-1991 The University of Maryland
(c)Copyright 1988 Carnegie Mellon University
(c)Copyright 1991-2003 Mentat Inc.
(c)Copyright 1996 Morning Star Technologies, Inc.
(c)Copyright 1996 Progressive Systems, Inc.


RESTRICTED RIGHTS LEGEND
Use, duplication, or disclosure by the U.S. Government is subject to
restrictions as set forth in sub-paragraph (c)(1)(ii) of the Rights in
Technical Data and Computer Software clause in DFARS 252.227-7013.


Hewlett-Packard Company
3000 Hanover Street
Palo Alto, CA 94304 U.S.A.

Rights for non-DOD U.S. Government Departments and Agencies are as set
forth in FAR 52.227-19(c)(1,2).

##########################################
Run ORA_NLS10_setup for DB Startup
##########################################
STARTING THE DATABASE

$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.2.0 - Production on Tue May 12 09:52:44 2009

Copyright (c) 1982, 2005, Oracle. All Rights Reserved.

Connected to an idle instance.

SQL> startup
ORACLE instance started.

Total System Global Area 1077936128 bytes
Fixed Size 2049464 bytes
Variable Size 427821640 bytes
Database Buffers 633339904 bytes
Redo Buffers 14725120 bytes
Database mounted.
Database opened.
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options

STARTING THE LISTENER

$ lsnrctl start ABC

LSNRCTL for HPUX: Version 10.2.0.2.0 - Production on 12-MAY-2009 09:53:30

Copyright (c) 1991, 2005, Oracle. All rights reserved.

Starting /ud/db/tech_st/10.2.0/bin/tnslsnr: please wait...

TNSLSNR for HPUX: Version 10.2.0.2.0 - Production
System parameter file is /ud/db/tech_st/10.2.0/network/admin/PROD_erpdb/listener.ora
Log messages written to /ud/db/tech_st/10.2.0/network/admin/prod.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROCABC)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST= 1.1.1.36)(PORT=1521)))

Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROCABC))
STATUS of the LISTENER
------------------------
Alias prod
Version TNSLSNR for HPUX: Version 10.2.0.2.0 - Production
Start Date 12-MAY-2009 09:53:31
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /ud/db/tech_st/10.2.0/network/admin/PROD_erpdb/listener.ora
Listener Log File /ud/db/tech_st/10.2.0/network/admin/prod.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROCABC)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=1.1.1.36)(PORT=1521)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "PROD" has 1 instance(s).
Instance "PROD", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully


For Application Startup login on 1.1.1.1 server as applmgr user.

Screen Output:
login as: applmgr
Password:
Last login: Mon May 11 19:51:29 2009
(c)Copyright 1983-2003 Hewlett-Packard Development Company, L.P.
(c)Copyright 1979, 1980, 1983, 1985-1993 The Regents of the Univ. of California
(c)Copyright 1980, 1984, 1986 Novell, Inc.
(c)Copyright 1986-2000 Sun Microsystems, Inc.
(c)Copyright 1985, 1986, 1988 Massachusetts Institute of Technology
(c)Copyright 1989-1993 The Open Software Foundation, Inc.
(c)Copyright 1990 Motorola, Inc.
(c)Copyright 1990, 1991, 1992 Cornell University
(c)Copyright 1989-1991 The University of Maryland
(c)Copyright 1988 Carnegie Mellon University
(c)Copyright 1991-2003 Mentat Inc.
(c)Copyright 1996 Morning Star Technologies, Inc.
(c)Copyright 1996 Progressive Systems, Inc.


RESTRICTED RIGHTS LEGEND
Use, duplication, or disclosure by the U.S. Government is subject to
restrictions as set forth in sub-paragraph (c)(1)(ii) of the Rights in
Technical Data and Computer Software clause in DFARS 252.227-7013.


Hewlett-Packard Company
3000 Hanover Street
Palo Alto, CA 94304 U.S.A.

Rights for non-DOD U.S. Government Departments and Agencies are as set
forth in FAR 52.227-19(c)(1,2).
You have mail.

STARTING THE APPLICATION



Check that Exiting with status is 0 always to ensure that everything is started Properly.

Now as per metalink DOC-ID, we have to clear the cache in MID TIER:-

$ rm ?rf $INST_TOP/ora/10.1.3/j2ee/forms/persistence/*
$ rm ?rf $INST_TOP/ora/10.1.3/j2ee/oacore/persistence/*
$ rm ?rf $INST_TOP/ora/10.1.3/j2ee/oafm/persistence/*

$ cd $TNS_ADMIN/
$ cp tnsmanes.ora tnsnames.ora_bkp
$ cd $INST_TOP/admin/scripts
$ ./adautocinfig.sh
$ cp tnsnames.ora_bkp tnasnames.ora

$ ./adstrtal.sh

You are running adstrtal.sh version 120.13.12000000.3


Enter the APPS username/ password: