SAP Instance not start after database restore

[Former Member]

Hi all.

I have problem to start the SAP application.

We had a disk problem and we need to restore the SAP database. But after restore the SAP application is not starting.

Can someone help me?

Follow the logs analised by me:

ENVIRONMENT VARIABLES

SAPSYSTEMNAME=ED0

DIR_LIBRARY=/usr/sap/ED0/SYS/exe/run

LD_LIBRARY_PATH=/usr/sap/ED0/SYS/exe/run:/oracle/client/10x_64/instantclient

JAVA_HOME=/opt/IBMJava2-ppc64-142

THREAD=NOPS

dbms_type=ORA

dbs_ora_tnsname=ED0

dbs_ora_schema=SAPSR3

ORACLE_SID=ED0

DB_SID=ED0

ORACLE_BASE=/oracle

TNS_ADMIN=/usr/sap/ED0/SYS/profile/oracle

ORACLE_HOME=/oracle/ED0/102_64

NLS_LANG=AMERICAN_AMERICA.UTF8

SAPDATA_HOME=/oracle/ED0

START DATABASE

SQL> startup

ORACLE instance started.

Total System Global Area 2365587456 bytes

Fixed Size                  2147184 bytes

Variable Size            1191197840 bytes

Database Buffers         1157627904 bytes

Redo Buffers               14614528 bytes

Database mounted.

Database opened.

SQL>

CHECK DATABASE STATUS

SQL> select open_mode from v$database;

OPEN_MODE

----------

READ WRITE

SQL>

CHECK OPS$ USERS ON DATABASE

SQL> select username, account_status from dba_users;

USERNAME                       ACCOUNT_STATUS

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

SAPSR3                            OPEN

DBSNMP                           EXPIRED

OUTLN                              OPEN

OPS$ORAED0                   OPEN

OPS$ED0ADM                   OPEN

OPS$SAPSERVICEED0     OPEN

SYS                                   OPEN

SYSTEM                            OPEN

TSMSYS                            EXPIRED & LOCKED

DIP                                    EXPIRED & LOCKED

ORACLE_OCM                  EXPIRED & LOCKED

11 rows selected.

LISTENER STATUS

hades:oraed0 52> lsnrctl status

LSNRCTL for Linux: Version 10.2.0.4.0 - Production on 14-JUL-2015 12:19:00

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

Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=ED0.WORLD))

STATUS of the LISTENER

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

Alias                     LISTENER

Version                   TNSLSNR for Linux: Version 10.2.0.4.0 - Production

Start Date                14-JUL-2015 09:56:21

Uptime                    0 days 2 hr. 22 min. 38 sec

Trace Level               off

Security                  ON: Local OS Authentication

SNMP                      OFF

Listener Parameter File   /oracle/ED0/102_64/network/admin/listener.ora

Listener Log File         /oracle/ED0/102_64/network/log/listener.log

Listening Endpoints Summary...

  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=ED0.WORLD)))

  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=ED0)))

  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=hades.drogaraia.com.br)(PORT=1527)))

Services Summary...

Service "ED0" has 1 instance(s).

  Instance "ED0", status UNKNOWN, has 1 handler(s) for this service...

The command completed successfully

R3trans -x

hades:ed0adm 40> R3trans -x

This is R3trans version 6.14 (release 701 - 26.01.09 - 12:46:00).

unicode enabled version

R3trans finished (0000).

hades:ed0adm 41>

R3trans -d

hades:ed0adm 41> R3trans -d

This is R3trans version 6.14 (release 701 - 26.01.09 - 12:46:00).

unicode enabled version

2EETW000 sap_dext called with msgnr "2":

2EETW000 ---- db call info ----

2EETW000 function:   db_ntab

2EETW000 fcode:      NT_RDTDESCR

2EETW000 tabname:    TADIR

2EETW000 len (char): 5

2EETW000 key:        TADIR

2EETW000 retcode:    2

R3trans finished (0012).

hades:ed0adm 42>

trans.log

hades:ed0adm 42> tail trans.log

2EETW000 sap_dext called with msgnr "2":

2EETW000 ---- db call info ----

2EETW000 function:   db_ntab

2EETW000 fcode:      NT_RDTDESCR

2EETW000 tabname:    TADIR

2EETW000 len (char): 5

2EETW000 key:        TADIR

2EETW000 retcode:    2

4 ETW000  [dev trc     ,00000]  db_con_rollback (con_da={R/3,0,0},th_rollback=1,tx=0)

4 ETW000                                                                             125  0.164155

hades:ed0adm 43>

Regards,

Fábio Belli

[Former Member · Accepted solution]

Everything you have posted looks ok. However what about some SAP logs?

Do you have a sapstartsrv running? If not shutdown Oracle and reboot the server.

What do your SAP trave files show in your directory /usr/sap/ED0/DVEBMGS00/work?

Look in the files dev_w0, stderr1, dev_ms. Check in the directory for files with the latest datae stamp (ls -ltr).

What SAP processes are running (ps -ef | grep sap)?

[Former Member · Accepted solution]

Hello,

The problem was in the database restore. Some datafiles were corrupted.

After our database administrator remake database restore the application is working fine.

Thank you very much.

Regards,

Fábio Belli