oracle 10g （10.2.0）我备份了备份了二进制和文本类型的控制文件，然后新建了一个表空间app3，之后把所有的控制文件删除，关闭数据库。启动数据库为mount状态，把备份的二进制控制文件拷贝到数据库相应的目录，执行recover database using backup controlfile ；出现了

SQL> recover database using backup controlfile;
ORA-00283: recovery session canceled due to errors
ORA-01111: name for data file 7 is unknown - rename to correct file
ORA-01110: data file 7: '/u01/app/oracle/product/10.2.0/db_1/dbs/UNNAMED00007'
ORA-01157: cannot identify/lock data file 7 - see DBWR trace file
ORA-01111: name for data file 7 is unknown - rename to correct file
ORA-01110: data file 7: '/u01/app/oracle/product/10.2.0/db_1/dbs/UNNAMED00007'
错误信息  然后我执行

SQL> alter database rename file '/u01/app/oracle/product/10.2.0/db_1/dbs/UNNAMED00007' to '/u01/app/oracle/oradata/shujuku/app3_01.dbf';
alter database rename file '/u01/app/oracle/product/10.2.0/db_1/dbs/UNNAMED00007' to '/u01/app/oracle/oradata/shujuku/app3_01.dbf'
*
ERROR at line 1:
ORA-01511: error in renaming log/data files
ORA-01141: error renaming data file 7 - new file
'/u01/app/oracle/oradata/shujuku/app3_01.dbf' not found
ORA-01111: name for data file 7 is unknown - rename to correct file
ORA-01110: data file 7: '/u01/app/oracle/product/10.2.0/db_1/dbs/UNNAMED00007'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
重名名不了。。。为啥子？
我又利用备份的文本控制文件做成脚本执行@。。三个控制文件是恢复了但是数据库还是打不开，同样的问题

@/backup/controlfile/c1.sql
ORACLE instance started.

Total System Global Area  285212672 bytes
Fixed Size                  1218992 bytes
Variable Size             104859216 bytes
Database Buffers          176160768 bytes
Redo Buffers                2973696 bytes

Control file created.


PL/SQL procedure successfully completed.


PL/SQL procedure successfully completed.


PL/SQL procedure successfully completed.


PL/SQL procedure successfully completed.

ORA-00283: recovery session canceled due to errors
ORA-01244: unnamed datafile(s) added to control file by media recovery
ORA-01110: data file 7: '/u01/app/oracle/oradata/shujuku/
app3_01.dbf'



System altered.

ALTER DATABASE OPEN
*
ERROR at line 1:
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: '/u01/app/oracle/oradata/shujuku/system01.dbf'


ALTER TABLESPACE TEMP ADD TEMPFILE '/u01/app/oracle/oradata/shujuku/temp01.dbf'
*
ERROR at line 1:
ORA-01109: database not open


ALTER TABLESPACE MYTEMP ADD TEMPFILE '/u01/app/oracle/oradata/shujuku/mytemp01.dbf'
*
ERROR at line 1:
ORA-01109: database not open

oracle 10g （10.2.0）我备份了备份了二进制和文本类型的控制文件，然后新建了一个表空间app3，之后把所有的控制文件删除，关闭数据库。启动数据库为mount状态，把备份的二进制控制文件拷贝到数据库相应的目录，执行recover database using backup controlfile ；出现了

SQL> recover database using backup controlfile;
ORA-00283: recovery session canceled due to errors
ORA-01111: name for data file 7 is unknown - rename to correct file
ORA-01110: data file 7: '/u01/app/oracle/product/10.2.0/db_1/dbs/UNNAMED00007'
ORA-01157: cannot identify/lock data file 7 - see DBWR trace file
ORA-01111: name for data file 7 is unknown - rename to correct file
ORA-01110: data file 7: '/u01/app/oracle/product/10.2.0/db_1/dbs/UNNAMED00007'
错误信息  然后我执行

SQL> alter database rename file '/u01/app/oracle/product/10.2.0/db_1/dbs/UNNAMED00007' to '/u01/app/oracle/oradata/shujuku/app3_01.dbf';
alter database rename file '/u01/app/oracle/product/10.2.0/db_1/dbs/UNNAMED00007' to '/u01/app/oracle/oradata/shujuku/app3_01.dbf'
*
ERROR at line 1:
ORA-01511: error in renaming log/data files
ORA-01141: error renaming data file 7 - new file
'/u01/app/oracle/oradata/shujuku/app3_01.dbf' not found
ORA-01111: name for data file 7 is unknown - rename to correct file
ORA-01110: data file 7: '/u01/app/oracle/product/10.2.0/db_1/dbs/UNNAMED00007'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
重名名不了。。。为啥子？
我又利用备份的文本控制文件做成脚本执行@。。三个控制文件是恢复了但是数据库还是打不开，同样的问题

@/backup/controlfile/c1.sql
ORACLE instance started.

Total System Global Area  285212672 bytes
Fixed Size                  1218992 bytes
Variable Size             104859216 bytes
Database Buffers          176160768 bytes
Redo Buffers                2973696 bytes

Control file created.


PL/SQL procedure successfully completed.


PL/SQL procedure successfully completed.


PL/SQL procedure successfully completed.


PL/SQL procedure successfully completed.

ORA-00283: recovery session canceled due to errors
ORA-01244: unnamed datafile(s) added to control file by media recovery
ORA-01110: data file 7: '/u01/app/oracle/oradata/shujuku/
app3_01.dbf'



System altered.

ALTER DATABASE OPEN
*
ERROR at line 1:
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: '/u01/app/oracle/oradata/shujuku/system01.dbf'


ALTER TABLESPACE TEMP ADD TEMPFILE '/u01/app/oracle/oradata/shujuku/temp01.dbf'
*
ERROR at line 1:
ORA-01109: database not open


ALTER TABLESPACE MYTEMP ADD TEMPFILE '/u01/app/oracle/oradata/shujuku/mytemp01.dbf'
*
ERROR at line 1:
ORA-01109: database not open