RE: can't open database after restore

Hi Drake,

If it was a hot (inconsistent) backup, you will need at least the archived logs taken during and/or immediately after the completion of the backup so it can recover through hot backup period to bring the database to a consistent state before opening. I think there may be unsupported methods of forcing it open without first recovering to a consistent state, but I'm not familiar with them. Regarding the failed restore of your archived logs, it may be because you're trying to restore them to a different machine and the media manager hasn't associated those backup images with the new server. You may be able to spoof the server by setting a variable such as NB_ORA_CLIENT and/or some other config options, or alternatively you could try restoring the archive logs onto the original server and then copying them over from there to the test server and pointing RMAN to them.

Regards,
Brandon

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Drake Emko Sent: Wednesday, December 14, 2005 8:29 AM To: oracle-l_at_freelists.org
Subject: can't open database after restore

Hi everyone,

I have a large database that is used by our online learning software. At some point a couple classes were deleted by an application administrator. I have been trying to recover the classes by restoring the entire database onto our test database server (different machine) via RMAN, but have not been able to open the database once the restore/recover is complete.

Privileged/Confidential Information may be contained in this message or attachments hereto. Please advise immediately if you or your employer do not consent to Internet email for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of this company shall be understood as neither given nor endorsed by it.

--
http://www.freelists.org/webpage/oracle-l