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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Drake Emko
Sent: Wednesday, December 14, 2005 8:29 AM
To: oracle-l@xxxxxxxxxxxxx
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

Other related posts: