NOt able to bring up DB after TSPITR
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