Ok so here is the scenario..
- Have database1 in db2inst1
- Took a offline (cold) backup of database1
- did redirected restore to clone database1 in to database2 in same instance
- set tablespace containers, worked just fine , no errors.
- roll forward database to end of logs and complete , worked fine no errors
Now problem starts. When app folks told me they are missing some data, which was simply not visible to me because I did cold backup and then… Continue