Urgent database not coming up

[Former Member]

Since sourse database was in noarchivelog mode which i have restored i am giving current online redologfile during recovery as per suggession made by SAP.

Below are the details

SQL> recover database using backup controlfile until cancel;

ORA-00279: change 12814181 generated at 04/17/2007 20:16:05 needed for thre

ORA-00289: suggestion : E:\ORACLE\PRD\SAPARCH\PRDARCH\ARC00001.001

ORA-00280: change 12814181 for thread 1 is in sequence #1

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

F:\ORACLE\PRD\ORIGLOGB\LOG_G14M1.DBF

Log applied.

Media recovery complete.

SQL> alter database open resetlogs;

alter database open resetlogs

*

ERROR at line 1:

ORA-01092: ORACLE instance terminated. Disconnection forced

-

---

And below are some alertlog entries found ,

Fri Apr 20 07:30:30 2007

ALTER DATABASE RECOVER LOGFILE 'F:\ORACLE\PRD\ORIGLOGB\LOG_G14M1.DBF'

Fri Apr 20 07:30:30 2007

Media Recovery Log F:\ORACLE\PRD\ORIGLOGB\LOG_G14M1.DBF

Incomplete recovery applied all redo ever generated.

Recovery completed through change %s12814242

Media Recovery Complete

Completed: ALTER DATABASE RECOVER LOGFILE 'F:\ORACLE\PRD\O

Fri Apr 20 07:31:23 2007

alter database open resetlogs

Fri Apr 20 07:31:23 2007

RESETLOGS after complete recovery through change 12814242

Online log 11 of thread 1 was previously cleared

Online log 12 of thread 1 was previously cleared

Online log 13 of thread 1 was previously cleared

Fri Apr 20 07:31:24 2007

Thread 1 opened at log sequence 1

Current log# 14 seq# 1 mem# 0: F:\ORACLE\PRD\ORIGLOGB\LOG_G14M1.DBF

Current log# 14 seq# 1 mem# 1: E:\ORACLE\PRD\MIRRLOGB\LOG_G14M2.DBF

Successful open of redo thread 1.

Fri Apr 20 07:31:24 2007

SMON: enabling cache recovery

Fri Apr 20 07:31:24 2007

ARC0: media recovery disabled

Fri Apr 20 07:31:24 2007

Errors in file E:\oracle\PRD\saptrace\usertrace\ORA01656.TRC:

ORA-01534: rollback segment 'PRS_15' doesn't exist

Fri Apr 20 07:31:24 2007

Error 1534 happened during db open, shutting down database

USER: terminating instance due to error 1534

Instance terminated by USER, pid = 1656

ORA-1092 signalled during: alter database open resetlogs

-

---

I have checked source database also this PRS_15 segment does not exist.

Pleasehelp urgently.

Best Regards,

AjitR

[Former Member]

cheers friends problem solved after consulting with SAP

[Former Member]

HI ajju,

Please share the information so that others can gain knowledge based on your solution.

regards,

Vinodh.