Deleted Data Files and media recovery test

The experiment is as follows:

Restore media when user data files are deleted

1. First, back up the user data file alter tablespace user begin backup; copy the user data file

2. Alter tablespace user end backup;

3. Delete user shutdown abort

4. Startup error ORA-01157 or ORA-01110

5. Select File #, change # from V $ recover_file;

6. Check the low-position SCN of the non-inactive online log; select Min (first_change #) from V $ log where status! = 'Inactivity ';

7. Select min (first_change #) from V $ archived_log; check whether the SCN number is smaller than userscn

8. Recover automatic datafile 3 (User );

9. Alter database open;

Deleted Data Files and media recovery test