This content has been marked as final. Show 2 replies
although it is beyound my imagination what kind of real world scenario you are trying to simulate with your test, I can tell you why no error gets returned:
You create a new tablespace t1 after you dropped the old one. That gets stored in the current controlfile. The previous backup of the datafile of the old tablespace that incidentally has the same name is now useless for the new tablespace.
You then restore that controlfile and create the datafile manually as it looked after you created the new tablespace (empty) and then recover that. RMAN does that (without complaining even about the uselessness of your doing). If you look into that tablespace, you will see that it is empty as it was after you created it - unless you have put any objects into it after the second creation of that tablespace t1.
In step T4:
"T4: I move the objects in tablespace test1 to some other tablespace"
So this step should be stored in archivelogs.
In the standby database, I first cleared the datafile with "alter database create datafile as ..", so there will be no objects in the datafile.
Then I started media recovery;
How come oracle apply the archivelogs of T4 without any error ( I have already cleared the datafile)???