I have an oracle database that does daily backups with RMAN, but I also run dpm backups of the full vm. When I do a restore using dpm, the oracle database is in active backup state, so I have to change the backup state before I can open the database.
Can someone confirm that this is a supported backup method? Also why when I do a restore of the full vm, why is the database in an active backup state.?
How can I verify that the database after I get it open is in a good state and has the latest backed up data?