ora-01113 after incorrect order of moving datafiles

ASM datafiles get moved to zfs storage for long term storage. DB is in noarchivelog mode. The datafile is part of a tablespace and contains only the one datafile. The data is partitioned tables about two months old and would no longer have inserts/updates/deletes.

A colleague has done the following.

alter tablespace my_tbs offline;

moved datafile using rman to zfs

alter database rename file .... -- at this stage they made a mistake with naming so the command failed as it should

alter tablespace my_tbs online
alter tablespace my_tbs read write

here they realized they forgot to rename the file so they issued

alter tablespace my_tbs offline -- i believe at this point they should have redid the whole copy but they didn't alter database rename file 'my_asm_file' to 'my_zfs_file'

asm happily deleted the file and did the rename.

alter tablespace my_tbs online
then ora-01113 was returned.

they waited a few days to ask me what to do. I don't think there's much to do except offline drop the datafiles and get rid of the partitions that were in the tablespace. Online redologs would have cycled by now.

Just thought I would ask to make sure.

yes I know this is a terrible process but it's the process they have to live with.

Thanks

Mike

--
http://www.freelists.org/webpage/oracle-l