q请教各位高手关于10g数据库恢复的问题

显示全部楼层 · 2014-2-19 11:55:14

我是一名ORACLE的初学者,现请教关于数据库冷备份和恢复的问题,请各位高手指点。
今天给10g数据库做了个冷备份，SHUTDOWN IMMEDIATE以后，备份了所有的数据文件，控制文件和日志文件。由于是测试环境，想进一步测试，就将原有的数据文件，控制文件和日志文件全部删除，再将已经备份好的文件拷贝回原来的位置，STARTUP的时候，出现以下错误，请高手指点，如何解决问题？
bash-2.05# su - oracle
Sun Microsystems Inc. SunOS 5.9 Generic May 2002
$ sqlplus /nolog
SQL*Plus: Release 9.0.1.4.0 - Production on Wed Mar 23 18:53:17 2005
(c) Copyright 2001 Oracle Corporation.All rights reserved.
SQL> connect / as sysdba
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area143427356 bytes
Fixed Size
280348 bytes
Variable Size
92274688 bytes
Database Buffers 50331648 bytes
Redo Buffers
540672 bytes
ORA-00205: error in identifying controlfile, check alert log for more info

SQL>

千问 · 2014-2-19 11:55:14

控制文件没有做冷备份或者没有copy回去吧?
建议先看看piner的大作:
http://www.itpub.net/125099.html

千问 · 2014-2-19 11:55:14

文件应该没备粉齐
看看ALERT到底有什么提示

千问 · 2014-2-19 11:55:14

备份齐了，能告诉我如何恢复吗？

千问 · 2014-2-19 11:55:14

冷备粉齐的话直接拷贝到原先位置就行了啊

千问 · 2014-2-19 11:55:14

就是原封不动拷贝回去的,但是就出现了上述错误,请问能恢复吗?我该如何恢复?

千问 · 2014-2-19 11:55:14

最初由 qhxnzq1 发布
[B]就是原封不动拷贝回去的,但是就出现了上述错误,请问能恢复吗?我该如何恢复? [/B]
ORA-00205
ORA-00205message in identifying control file 'name'
Cause:The system could not find a control file of the specified name and size.
Action:Either:
1) Ensure the proper control file name is referenced in the CONTROL_FILES initialization parameter in the initialization parameter file and try again.
2) When using mirrored control files (that is, more than one control file is referenced in the initialization parameter file), remove the control file name listed in the message from the initialization parameter file, and restart the instance. If the message does not recur, remove the problem control file from the initialization parameter file and create another copy of the control file using a new file name in the initialization parameter file.
alert.log中的错误信息?
如果是完全拷贝/完全覆盖回去的话是不会出现上述错误的.

千问 · 2014-2-19 11:55:14

最初由 husthxd 发布
[B]
ORA-00205
ORA-00205message in identifying control file 'name'
Cause:The system could not find a control file of the specified name and size.
Action:Either:
1) Ensure the proper control file name is referenced in the CONTROL_FILES initialization parameter in the initialization parameter file and try again.
2) When using mirrored control files (that is, more than one control file is referenced in the initialization parameter file), remove the control file name listed in the message from the initialization parameter file, and restart the instance. If the message does not recur, remove the problem control file from the initialization parameter file and create another copy of the control file using a new file name in the initialization parameter file.
alert.log中的错误信息?
如果是完全拷贝/完全覆盖回去的话是不会出现上述错误的. [/B]
哇
你小子太狠了
可以煮2锅了哦