I have 2 asm disk groups, +DATA and +FRA. I want to do a fast recovery, so I am going to 'switch database to copy'.
My question is after that is done, what are the steps to move the database back to +DATA. The database is large and there is not enough space in the
disk groups to store a backup and database. Which means after I switch to the copy, I have to delete the old db in +DATA.
1. I have to remove the old db in +DATA. How will rman know to delete whats in +DATA and not +FRA?
delete backup;
2. 'restore' from +FRA to +DATAM
RMAN> backup as copy database format '+DATA';
RMAN> backup as copy current controlfile format '+DATA';
RMAN> switch database to copy
RMAN> startup nomount;
RMAN> alter database mount;
RMAN> recover database;
RMAN> alter database open;
Is this right? Am I missing a step?