OraFAQ Forum: Backup & Recovery » Recover Database Error

Home » RDBMS Server » Backup & Recovery » Recover Database Error (Oracle 10.2.0.4.0 on Windows Server 2003 R2)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Recover Database Error [message #544584]

Wed, 22 February 2012 12:44

SPenn
Messages: 6
Registered: February 2012

Junior Member

I searched this website for my current error message but to no avail. Please assist if you can.

D:\DBA>set o
ORACLE_HOME=D:\oracle\product\10.2.0\db
ORACLE_SID=SIRSTEST
oraenv=oraenv
OS=Windows_NT

D:\DBA>sqlplus /nolog

SQL*Plus: Release 10.2.0.4.0 - Production on Wed Feb 22 13:14:41 2012

Copyright (c) 1982, 2007, Oracle. All Rights Reserved.

SQL> exit

D:\DBA>rman

Recovery Manager: Release 10.2.0.4.0 - Production on Wed Feb 22 13:14:50 2012

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

RMAN> connect target /

connected to target database: SIRSTEST (DBID=4173358074, not open)

RMAN> startup mount;

database is already started

RMAN> recover database;

Starting recover at 22-FEB-12
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=154 devtype=DISK

starting media recovery
media recovery failed
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 02/22/2012 13:15:28
ORA-03114: not connected to ORACLE
RMAN-11003: failure during parse/execution of SQL statement: alter database recover if needed
start
ORA-01041: internal error. hostdef extension doesn't exist

Report message to a moderator

Re: Recover Database Error [message #544586 is a reply to message #544584]

Wed, 22 February 2012 12:54

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

what clues exist with alert_SID.log file?

what events happened before attempting to recover the database?

Report message to a moderator

Re: Recover Database Error [message #544594 is a reply to message #544586]

Wed, 22 February 2012 13:37

SPenn
Messages: 6
Registered: February 2012

Junior Member

What happened beforehand?
1. A disk in a mirror pair failed and it was replaced and the server rebooted.
2. I was called that the database wasn't up after the reboot (the Oracle service is set to autostart).
3. I encountered various errors while attempting to open the database and then decided to restore the database (it's test) from an RMAN backup
4. The RMAN restore went went and the above errors came after the "recover database" command was executed.

Here's what I didn't initially realize from the alert.log:

Media Recovery Start
parallel recovery started with 7 processes
Wed Feb 22 13:15:27 2012
Errors in file d:\oracle\product\10.2.0\admin\sirstest\udump\sirstest_ora_4184.trc:
ORA-00314: log 1 of thread 1, expected sequence# 9326 doesn't match 8423
ORA-00312: online log 1 thread 1: 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\SIRSTEST\REDO01B.LOG'

Wed Feb 22 13:15:27 2012
Recovery of Online Redo Log: Thread 1 Group 1 Seq 9326 Reading mem 1
Mem# 0: F:\ORACLE\ORADATA\SIRSTEST\REDO01A.LOG
Mem# 2: F:\ORACLE\ORADATA\SIRSTEST\REDO01B.LOG
Wed Feb 22 13:15:27 2012
Errors in file d:\oracle\product\10.2.0\admin\sirstest\udump\sirstest_ora_4184.trc:
ORA-07445: exception encountered: core dump [ACCESS_VIOLATION] [_ksfd_sort_ioreq+20] [PC:0x810198] [ADDR:0x38] [UNABLE_TO_READ] []

Please advise.

Report message to a moderator

Re: Recover Database Error [message #544596 is a reply to message #544594]

Wed, 22 February 2012 13:42

Michel Cadot
Messages: 68731
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

ORA-00600/ORA-07445/ORA-03113 = Oracle bug => search on Metalink and/or call Oracle support
Have a look at alert.log and trace files.
You can also read this article: Troubleshooting Internal Errors.

Regards
Michel

Report message to a moderator

Re: Recover Database Error [message #544597 is a reply to message #544596]

Wed, 22 February 2012 13:50

SPenn
Messages: 6
Registered: February 2012

Junior Member

I don't have a Metalink account at this point.

Any advise is helpful.

Report message to a moderator

Re: Recover Database Error [message #544598 is a reply to message #544597]

Wed, 22 February 2012 14:34

Michel Cadot
Messages: 68731
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

So your only solution is to search on the web with the error code and parameters.
Maybe the trace will give you a hint.

Regards
Michel

Report message to a moderator

Re: Recover Database Error [message #544914 is a reply to message #544598]

Fri, 24 February 2012 13:34

SPenn
Messages: 6
Registered: February 2012

Junior Member

My control files were out of synchronization and the following resolved it:

1. restore controlfile from 'F:\location of RMAN backup of controfile';
2. alter database mount;
3. catalog start with 'F:\location of archivelogs';
4. run {set until logseq = 9328 thread = 1; recover database};

9328 is the next loqseq after the existing archivelogs

[Updated on: Fri, 24 February 2012 13:53]

Report message to a moderator

Re: Recover Database Error [message #544915 is a reply to message #544914]

Fri, 24 February 2012 13:44

Michel Cadot
Messages: 68731
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Thanks for the feedback.
And you could then open the database?

Regards
Michel

Report message to a moderator

Re: Recover Database Error [message #544916 is a reply to message #544915]

Fri, 24 February 2012 13:51

SPenn
Messages: 6
Registered: February 2012

Junior Member

Correct. Thereafter, I was able to open the database.

Report message to a moderator

Re: Recover Database Error [message #544917 is a reply to message #544916]

Fri, 24 February 2012 14:11

Michel Cadot
Messages: 68731
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Thanks
Michel

Report message to a moderator

Previous Topic:	database session for channel sbt_4 terminated unexpectedly
Next Topic:	RMAN Duplicate set until time using wrong backup piece name to restore.

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jan 22 00:57:43 CST 2025