Oracle archive mode supports backup and recovery of lost data files

1. Create full database backup

2. Construct test data under the test2 user

3. Simulate file loss: log on to and close the database as sysdba, and try to restart the database.

4. Execute recovery: Enter the RMAN command line Environment

You can see from the above: Restore data file 7 (you can also specify the file name) is read from the backup set db_bak_15p31koh_1_1

5. Repair data files

6. Open the database and check that the recovery is successful!

Additional:

Query table spaces and their associated data files

Select ts. tablespace_name, df. file_name, df. file_id, df. statusfrom dba_tablespaces ts, (select tablespace_name, file_id, file_name, statusfrom dba_data_filesunion allselect tablespace_name, file_id, file_name, statusfrom dba_temp_files) dfwhere ts. tablespace_name = df. tablespace_name;