Hi!!
I am using Oracle 10g on windows in archive mode. I was performing scenario of recovering a data file for which backup doesn't exist. So, first i took full backup of database and then added one data file (users.dbf) into existing tablespace USERS and then i performed some DML operations in users tablespace. Then i deleted that users2.dbf data file by using OS delete utility. To recover lost data file i took tablespace users offline and then performed
RMAN> restore tablespace users; Recover tablespace users .
The oracle creates that newly added data file by using info from control file even though it was not present in backup. All DML operations were also in effect after successful recovery.
Then i took fresh backup again. But whenever i try to restore operation oracle tries to create data file "users2.dbf" even though it exist. As it exist, it returns error mention above and operation is cancelled. So i want to know why it is happening? Why it is trying to create again even though data file exist in backup and at database as well. I know the solution, if i delete existing data file "usres02.dbf " then it will allow me to do restore because oracle will create it again.
Thanks & Regards
Tushar