Archive for February 13th, 2008
今天碰到ORA-600错误
Wednesday, February 13th, 2008
今天在standby上碰到ORA-600错误。在陈栋的帮助下，顺利饶过错误。事情过程大致如下：
当时STANDBY的空间是满的，且standby_file_management为AUTO
Primary:
我给UNDO TBS加了几个数据文件。
Standby:
发现日志无法恢复，提示ORA-600。
@>recover standby database;
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
auto
ORA-00283: recovery session canceled due to errors
ORA-01670: new datafile 25 needed for standby database recoveryORA-01157: cannot identify/lock data file 25 - see DBWR trace fileORA-01110: data file 25: ‘/disk2/oradata/crmcn/undotbs06.dbf’
@>alter database create datafile ‘/disk2/oradata/crmcn/undotbs06.dbf’ as ‘/backup/crmcn_wt/undotbs06.dbf’;Database altered.
此时undotbs06.dbf文件是过了，可以继续恢复。
@>recover standby database;Specify log: {<RET>=suggested | filename | AUTO [...]
