Restore Oracle data files that have not been backed up accidentally deleted by the user

Delete USERS02.DBF, a newly added data file in table space USERS, and USERS03.DBF by mistake. No valid backup is found for both files during restoration. Ask data

Delete USERS02.DBF, a newly added data file in table space USERS, and USERS03.DBF by mistake. No valid backup is found for both files during restoration. Ask data

The customer said earlier that it deleted the newly added data file USERS02.DBF and USERS03.DBF in table space USERS by mistake. No valid backup is found for both files during restoration. Ask if the data can be recovered.

1. Simulation Scenario:

SQL> select file_id, file_name, tablespace_name, online_status from dba_data_files;

1.1 take the data file users02.dbf offline

SQL> alter database datafile 5 offline;

1.2 Delete offline data files

$ Rm/oracle/oradata/orcl/users02.dbf

2. Data Recovery

2.1 directly restore data files to online

The system prompts that the data file datafile5 cannot be found.

2.2 create a data file and restore it

2.3 view recovered data files

SQL> select file_id, file_name, tablespace_name, online_status from dba_data_files;

The data file has been successfully restored.