Activating Standby DB and standby SAP – Howto

SQL> SELECT name,value FROM v$parameter WHERE name='parallel_server';

NAME VALUE

-----------------------------------------------------------------

parallel_server FALSE

1 row selected.

If the value is TRUE, then the database is not mounted exclusively; if the value is FALSE, then the database is mounted exclusively.

Activate the standby database; (Note that this command resets the online redo logs)

SQL> ALTER DATABASE ACTIVATE STANDBY DATABASE;

Shut down the standby instances:

SQL> SHUTDOWN IMMEDIATE

As soon as possible, back up your new production database. At this point, the former standby database is now your production database. This task, while not required, is a recommended safety measure because you cannot recover changes made after activation without a backup.

Start the new production instance in read/write or read-only mode:

SQL> STARTUP

Note:
After you activate the standby database, you lose all transactions from unarchived logs at your original production database. Because the standby redo logs are reset at activation, you cannot apply logs archived before activation.

Starting SAP at DRS

Ensure that Primary Database Down and/or is not available & Standby database is open/running
status; Followings are the instances of Primary & Stanby Databases;

SID of Primary DB

SID of Standby DB

Database Name

DEV

DEV

Database Instance

DEV

DRS

SAP Instance

DEV

DEV

Modifying Environment/Parameter file

Before start SAP instance, following parameter file are to be modified;

.dbenv_prddrs.csh,
.sapenv_prddrs.csh for user sid & ora
initDRS.ora
START_DVEBMGS00_prddrs
DEV_DEVBMGS00_prddrs
DEFAULT.PFL
startsap_prddrs_00
stopsap_prddrs_00

.dbenv_prddrs.csh

DBSID = DEV to be replaced by DBSID = DRS

.sapenv_prddrs.csh

SAPSYSTEMNAME DEV to be replaced by SAPSYSTEMNAME DRS

following parameters to be confirmed in initDRS.ora

log_archive_start = true
log_archive_dest = /oracle/DEV/saparch
log_archive_format = DEVarch%t_%s

START_DVEBMGS00_prddrs

Host name should be replaced by standby database’s hostname
SAPSYSTEMNAME = DEV

DEV_DEVBMGS00_prddrs
DEFAULT.PFL

SAPSYSTEMNAME = DEV
Host name should be replaced by standby database’s hostname

startsap_prddrs_00/ stopsap_prddrs_00

Host name should be replaced by standby database’s hostname & ensure that following value is exists