Online backups while drop / create tablespace (datafiles) DDL occurs
I am running an online database backup (in archivelog mode), using rman and a recovery catalog when I get the following errors:
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ch01 channel at 05/31/2009 05:58:15
ORA-01157: cannot identify/lock data file 94 - see DBWR trace file
ORA-01110: data file 94: 'No file with this number, file does not exist'
As you can see from the above ORA-01110, when rman tried to backup this datafile - it seems it did not exist. It doesn't even list the filename in the error message.
But when I run sql - I find that the file does exist, but on further investigation - it seems that when the actual backup was busy running - tablespaces were created and tablespaces were dropped (including their datafiles).