When you use alter database to move a data file, after you run the alter database rename <source file path> to <des file path> command, try to open{
Tagshow (event, '% Ca % fd % be % DD % BF % e2 ');
} "Href =" http://www.cnblogs.com/wuhenke/admin/javascript:; "target =" _ Self ">Database: Alter database open. Error:
ORA-01113: file 7 media recovery required
ORA-01110: data file 7 : 'e: oracle \ product \ 10.2.0 \ oradata \ orcl \ test01.dbf '.
This is because the database considers this data file to be damaged and requires recover command {
tagshow (event, '% B1 % B8 % B7 % dd ');
} "href =" http://www.cnblogs.com/wuhenke/admin/javascript:; "target =" _ Self "> Backup , log information to restore. 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.
(Reproduced from: http://blog.csdn.net/libingquan008/archive/2010/11/19/6021441.aspx)
Run the alter database open command to check whether other data files are damaged and restore them until all files are normal.