Moderators / Advisors - I would greatly appreciate it if you will please throw some light on this tablespace recovery issue.

Thanks, Anand

Steve, to answer your qns :
1) 'alter system checkpoint;' is the 'manual' way to issue a checkpoing (versus doing it automatically by setting the log_checkpoint_interval parm..or the checkpoint thats automatically issued when the log switches)

2) No, I didn't sync the catalogs after adding the new tablespace. But if you notice the RMAN recovery automatically resynced the catalogs as the first step.

3) Am using 9.2.0.4