请看错误信息。SQL> startup mount ORACLE 例程已经启动。Total System Global Area 162489612 bytes Fixed Size 70924 bytes Variable Size 44130304 bytes Database Buffers 118210560 bytes Redo Buffers 77824 bytes 数据库装载完毕。 SQL> recover database; ORA-00283: ?????????? ORA-00264: ????? SQL>
我找了找错误信息: ORA-00283 recovery session canceled due to errorsCause: An error during recovery was determined to be fatal enough to end the current recovery session.Action: More specific messages will accompany this message. Refer to the other messages for the appropriate action. ORA-00264 no recovery requiredCause: An attempt was made to perform media recovery on files that do not need any type of recovery. Action: Do not attempt to perform media recovery on the selected files. Check to see that the file names were entered properly. If not, retry the command with the proper file names. 原来是不必恢复。这让我如何恢复?
你说的数据库完全备份是冷备份? 你恢复的时候使用这条命令: recover database using backup controlfile;
回拷相关的数据库文件和该数据文件备份以来所有生成的所有逻辑日志文件 并执行如下命令: svrmgrl > startup mount svrmgrl > alter database recover automatic 如果控制文件被破坏,则: svrmgrl > alter database recover using backup controfile; 按照提示输入log文件名和redolog文件名 svrmgrl > alter database open resetlogs;
'D:\ORACLE\ORADATA\HYZH\ARCHIVE\HYZHT001S00194.ARC'这个文件在吗? recover database using backup controlfile until cancel; 出现提示的时候输入auto 然后再做一遍 recover database using backup controlfile until cancel; 出现提示的时候输入cancel 然后再alter database open resetlogs;
ORACLE 例程已经启动。Total System Global Area 162489612 bytes
Fixed Size 70924 bytes
Variable Size 44130304 bytes
Database Buffers 118210560 bytes
Redo Buffers 77824 bytes
数据库装载完毕。
SQL> recover database;
ORA-00283: ??????????
ORA-00264: ?????
SQL>
ORA-00283 recovery session canceled due to errorsCause: An error during recovery was determined to be fatal enough to end the current recovery session.Action: More specific messages will accompany this message. Refer to the other messages for the appropriate action.
ORA-00264 no recovery requiredCause: An attempt was made to perform media recovery on files that do not need any type of recovery. Action: Do not attempt to perform media recovery on the selected files. Check to see that the file names were entered properly. If not, retry the command with the proper file names. 原来是不必恢复。这让我如何恢复?
你恢复的时候使用这条命令:
recover database using backup controlfile;
数据库备份是冷备份,使用
recover database using backup controlfile;
就可以了!
另外,如果是热备份,是不是recover database就可以了?
并执行如下命令: svrmgrl > startup mount
svrmgrl > alter database recover automatic
如果控制文件被破坏,则:
svrmgrl > alter database recover using backup controfile;
按照提示输入log文件名和redolog文件名
svrmgrl > alter database open resetlogs;
好像还是不行,请看:
SQL> startup mount
ORACLE 例程已经启动。Total System Global Area 162489612 bytes
Fixed Size 70924 bytes
Variable Size 44130304 bytes
Database Buffers 118210560 bytes
Redo Buffers 77824 bytes
数据库装载完毕。
SQL> recover database using backup controlfile;
ORA-00279: ?? 29184 (? 05/13/2004 15:31:10 ??) ???? 1 ????
ORA-00289: ??: D:\ORACLE\ORADATA\HYZH\ARCHIVE\HYZHT001S00191.ARC
ORA-00280: ?? 29184 ???? 1 ???? # 191 ???
指定日志: {<RET>=suggested | filename | AUTO | CANCEL}
auto
ORA-00279: ?? 30963 (? 05/13/2004 15:34:25 ??) ???? 1 ????
ORA-00289: ??: D:\ORACLE\ORADATA\HYZH\ARCHIVE\HYZHT001S00192.ARC
ORA-00280: ?? 30963 ???? 1 ???? # 192 ???
ORA-00278: ??????????? 'D:\ORACLE\ORADATA\HYZH\ARCHIVE\HYZHT001S00191.ARC'
ORA-00279: ?? 33011 (? 05/13/2004 15:36:18 ??) ???? 1 ????
ORA-00289: ??: D:\ORACLE\ORADATA\HYZH\ARCHIVE\HYZHT001S00193.ARC
ORA-00280: ?? 33011 ???? 1 ???? # 193 ???
ORA-00278: ??????????? 'D:\ORACLE\ORADATA\HYZH\ARCHIVE\HYZHT001S00192.ARC'
ORA-00279: ?? 35058 (? 05/13/2004 15:38:11 ??) ???? 1 ????
ORA-00289: ??: D:\ORACLE\ORADATA\HYZH\ARCHIVE\HYZHT001S00194.ARC
ORA-00280: ?? 35058 ???? 1 ???? # 194 ???
ORA-00278: ??????????? 'D:\ORACLE\ORADATA\HYZH\ARCHIVE\HYZHT001S00193.ARC'
ORA-00308: ???????? 'D:\ORACLE\ORADATA\HYZH\ARCHIVE\HYZHT001S00194.ARC'
ORA-27041: ??????
OSD-04002: 无法打开文件
O/S-Error: (OS 2) 系统找不到指定的文件。
SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR 位于第 1 行:
ORA-01113: ?? 1 ??????
ORA-01110: ???? 1: 'D:\ORACLE\ORADATA\HYZH\SYSTEM01.DBF'
SQL> shutdown
ORA-01109: ??????
已经卸载数据库。
ORACLE 例程已经关闭。
请问在提示“OSD-04002: 无法打开文件
O/S-Error: (OS 2) 系统找不到指定的文件。”是什么意思?我就这几个归档文件。另外:to czrain(蝴蝶剑) :
svrmgrl > startup mount
svrmgrl > alter database recover automatic
会提示:
ORA-00283: ??????????
ORA-00264: ?????
recover database using backup controlfile until cancel;
出现提示的时候输入auto
然后再做一遍
recover database using backup controlfile until cancel;
出现提示的时候输入cancel
然后再alter database open resetlogs;
非常感谢你!