SAP not coming up after Refresh

[Former Member]

Hi - We have done a production refresh in to our test system today and database is up after the activity. SAP is not coming up and when I check I can see;

SAP version - ECC 6.0 /Oracle 10.2/Solaris 10

1. R3trans is able to connect to DB.

2. DB is in open stage

3. Message server is up.

On cheching the logs I can see the below error in the dev_w0 file;

C SELECT COUNT(*) FROM DDNTT WHERE TABFORM <> 'J' AND TABFORM <> 'V';

B ***LOG BYL=> DBQ action required because of database error [dbsh#3 @ 1104] [dbsh 1104 ]

B SQL code: 376, SQL text: ORA-00376: file 419 cannot be read at this time

B ORA-01111: name for data file 419 is unknown - rename to correct file

B ORA-01110: data file 419: '/oracle/ET1/102_64/dbs/MISSING00419'

B ***LOG BY4=> sql error 376 performing SEL on table DDNTT [dbstat#5 @ 849] [dbstat 0849 ]

B ***LOG BY0=> ORA-00376: file 419 cannot be read at this time

ORA-01111: name for data file 419 is unknown - rename to correct file

ORA-01110: data file 419: '/oracle/ET1/102_64/dbs/MISSING00419' [dbstat#5 @ 849] [dbstat 0849 ]

B db_stinit failed

M *** ERROR => ThCallHooks: event handler db_init for event CREATE_SHM failed [thxxtool3.c 261]

M *** ERROR => ThIPCInit: hook failed [thxxhead.c 2158]

M ***LOG R19=> ThInit, ThIPCInit ( TSKH-IPC-000001) [thxxhead.c 1585]

M in_ThErrHandle: 1

M *** ERROR => ThInit: ThIPCInit (step 1, th_errno 17, action 3, level 1) [thxxhead.c 10631]

Can someone please help as this is very critical for the business.

Thanks

Anil

[Former Member]

Hi - Thanks for the quick response, I have found out the data file which is in 'REPAIR' mode;

========================================================

SQL> select name,FILE#,STATUS from v$datafile where name like '%116%';

NAME

-

---

FILE# STATUS

-

---

-

---

/oracle/ET1/102_64/dbs/MISSING00116

116 RECOVER

/oracle/PRD/sapdata1/prd_116/prd.data116

145 ONLINE

SQL> select name,FILE#,STATUS from v$datafile where name like '%419%';

NAME

-

---

FILE# STATUS

-

---

-

---

/oracle/PRD/sapdata4/prd_419/prd.data419

115 ONLINE

/oracle/ET1/102_64/dbs/MISSING00419

419 RECOVER

========================================================

A bit confused here as how and what file will I recover, since the RECOVER file is showing as MISSING'xyz', can you please let me know this?

Thanks

Anil

[Former Member]

Hi,

Please check which one is your data file and do accordingly.

Regards

[Former Member]

Hi - We have identified the file, there were two, and asked the DBA's to check. Thanks for the help.

Thanks

Anil

[Former Member]

Welcome.

[Former Member]

Hi,

The message " B ORA-01111: name for data file 419 is unknown - rename to correct file " is because the datafile was missing from a CREATE CONTROLFILE command or BACKUP CONTROLFILE RECOVERY was done with a control file.

You can Just rename the Missing file to the name of the real file

The message " ORA-00376: file 419 cannot be read at this time " due to an attempt was made to read from a file that is not readable. Most likely the file is offline.

Please check the state of the file. Bring it online.

Maybe the above solution will solve your problem .

Regards