Home » RDBMS Server » Backup & Recovery » Recover Database Error (Oracle 10.2.0.4.0 on Windows Server 2003 R2)
Recover Database Error [message #544584] Wed, 22 February 2012 12:44 Go to next message
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
Re: Recover Database Error [message #544586 is a reply to message #544584] Wed, 22 February 2012 12:54 Go to previous messageGo to next message
BlackSwan
Messages: 26193
Registered: January 2009
Location: SoCal
Senior Member
what clues exist with alert_SID.log file?

what events happened before attempting to recover the database?
Re: Recover Database Error [message #544594 is a reply to message #544586] Wed, 22 February 2012 13:37 Go to previous messageGo to next message
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.
Re: Recover Database Error [message #544596 is a reply to message #544594] Wed, 22 February 2012 13:42 Go to previous messageGo to next message
Michel Cadot
Messages: 65844
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: Recover Database Error [message #544597 is a reply to message #544596] Wed, 22 February 2012 13:50 Go to previous messageGo to next message
SPenn
Messages: 6
Registered: February 2012
Junior Member
I don't have a Metalink account at this point.

Any advise is helpful.
Re: Recover Database Error [message #544598 is a reply to message #544597] Wed, 22 February 2012 14:34 Go to previous messageGo to next message
Michel Cadot
Messages: 65844
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: Recover Database Error [message #544914 is a reply to message #544598] Fri, 24 February 2012 13:34 Go to previous messageGo to next message
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 Go to previous messageGo to next message
Michel Cadot
Messages: 65844
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Thanks for the feedback.
And you could then open the database?

Regards
Michel
Re: Recover Database Error [message #544916 is a reply to message #544915] Fri, 24 February 2012 13:51 Go to previous messageGo to next message
SPenn
Messages: 6
Registered: February 2012
Junior Member
Correct. Thereafter, I was able to open the database.
Re: Recover Database Error [message #544917 is a reply to message #544916] Fri, 24 February 2012 14:11 Go to previous message
Michel Cadot
Messages: 65844
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Thanks
Michel
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:
  


Current Time: Thu Oct 18 16:58:49 CDT 2018