When Oracle moves data files, the system reports that file n requires medium recovery errors.

Procedure:

1. Sqlplus/nolog
2. Connect/As sysdba;
3. Shutdown immediate;
4. Startup Mount;
5. Alter database rename file 'C: \ ora92 \ oradata \ trans \ Trans. dbf' to 'd: \ ora92 \ oradata \ trans \ Trans. dbf ';
6. Alter database open;

 
Note:
 

• The data file in the temp tablespace cannot be moved.

when you use alter database to move data files, after executing the alter database rename to command, try to open {< br> tagshow (event, '% Ca % fd % be % DD % BF % e2');
} "href =" http: // W Ww.cnblogs.com/wuhenke/admin/javascript:; "target =" _ Self "> database : Alter database open. Error:

ORA-01113: file 7 media recovery required

ORA-01110: data files 7 : 'e: oracle \ product \ 10.2.0 \ oradata \ orcl \ test01. Dbf '.

This is because the database considers this data file to be damaged and needs to be usedRecoverCommand{
Tagshow (event, '% B1 % B8 % B7 % dd ');
} "Href =" http://www.cnblogs.com/wuhenke/admin/javascript:; "target =" _ Self ">Backup And log information. Database Backup Recovery is a complex problem, but the solution for this instance is relatively simple.

Run the following command:

Recover datafile 'e: oracle \ product \ 10.2.0 \ oradata \ orcl \ test01.dbf'

Prompt for media recovery, and then open the database: Alter database open. Everything works.

Run the alter database open command to check whether other data files are damaged and restore them until all files are normal.