sap starting probelm

[Former Member]

hi all

iam startsap i got following problem with r3trans.the error is

cat startdb.log | less

-

---

Wed Dec 3 17:13:46 IST 2008

LOGFILE FOR STARTING ORACLE

Trying to start KDV database ...

-

---

Wed Dec 3 17:13:46 IST 2008

checking required environment variables

ORACLE_HOME is >/oracle/KDV/102_64<

ORACLE_SID is >KDV<

-

---

Wed Dec 3 17:13:46 IST 2008

check initora

-

---

Wed Dec 3 17:13:46 IST 2008

check initora

-

---

Wed Dec 3 17:13:46 IST 2008

checking V2 connect

TNS Ping Utility for Linux: Version 10.2.0.1.0 - Production on 03-DEC-2008 17:13:46

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

Used parameter files:

/usr/sap/KDV/SYS/profile/oracle/sqlnet.ora

Used TNSNAMES adapter to resolve the alias

Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (COMMUNITY = SAP.WORLD) (PROTOCOL = TCP) (HOST = KARVY-DEV) (

PORT = 1527))) (CONNECT_DATA = (SID = KDV) (GLOBAL_NAME = KDV.WORLD)))

OK (10 msec)

tnsping: V2 connect to KDV

-

---

Wed Dec 3 17:13:46 IST 2008

Connect to the database to check the database state:

R3trans: connect check finished with return code: 12

Database not available

-

---

Wed Dec 3 17:13:46 IST 2008

Shutdown database

First trying to shutdown the database - May be,

the database is in the nomount or mount state

-

---

Wed Dec 3 17:13:46 IST 2008

Starting database

SQL*Plus: Release 10.2.0.1.0 - Production on Wed Dec 3 17:13:46 2008

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

Connected to an idle instance.

ORACLE instance started.

Total System Global Area 2332033024 bytes

Fixed Size 2022504 bytes

Variable Size 1174406040 bytes

Database Buffers 1140850688 bytes

Redo Buffers 14753792 bytes

Database mounted.

Database opened.

Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production

With the Partitioning and Data Mining options

-

---

Wed Dec 3 17:13:56 IST 2008

Connect to the database to verify, that the database is now open

R3trans check finished with return code: 12

• ERROR: Startup of database failed

Notify Database Administrator.

/usr/sap/KDV/SYS/exe/run/startdb: Terminating with error code 12

[Former Member · Accepted solution]

but i typed in OSvelel r3trans -d it shows following error

kdvadm 1> R3trans -d

This is R3trans version 6.14 (release 700 - 15.06.07 - 15:50:00).

unicode enabled version

2EETW000 sap_dext called with msgnr "1":

2EETW000 -

---

db call info -

---

2EETW000 function: db_ntab

2EETW000 fcode: NT_RDTDESCR

2EETW000 tabname: TADIR

2EETW000 len (char): 5

2EETW000 key: TADIR

2EETW000 retcode: 1

2EETW125 SQL error "376" during "" access: "ORA-00376: file 12 cannot be read at this time

ORA-01110: data file 12: '/oracle/KDV/sapdata2/sr3_9/sr3.data9'"

R3trans finished (0012).

problem the above datafile '/oracle/KDV/sapdata2/sr3_9/sr3.data9' is in Recovery mode.(not in online status) but i didn"t take backup of this system until now.what i do for this.can u tell me solution for this

[former_member204746 · Accepted solution]

try this:

stop SAP

sqlplus / as sysdba

shutdown immediate;

start mount

recover;

alter database open;

good luck.

[Former Member · Accepted solution]

hi markus,eric

thanks for answer.i solved the answer.solution is i recover that data file in database level.then i started sap

by

vasu

[markus_doehr2]

> SQL*Plus: Release 10.2.0.1.0 - Production on Wed Dec 3 17:13:46 2008

Your database version is unsupported (Read the installation guide!)

Please update to the latest major patchlevel (10.2.0.2 or 10.2.0.4), install the latest interim patches and then try again.

Markus