Database Backup and Recovery (MOSC)

MOSC Banner

NOt able to bring up DB after TSPITR

edited Aug 26, 2012 1:22AM in Database Backup and Recovery (MOSC) 8 commentsAnswered
Hi

  We were trying to perform TSPITR on new server. We restored SYSTEM, SYSAUX and UNDO tablespaces alongwith the required tablespace. We created a new controlfile with the datafiles of these 4 tablespaces. While trying to bring up the DB, it was looking for one of the datafile of some other tablespace which we do not require. We performed lot of permutation & combinations, but did not suceed. First of all, we could not be able to  understand why it was looking for the dataifle which is not at all required.

  Then we seached on google and found at one place to set the following parameter

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center