淘宝数据库技术团队

事件经过
we preform a successful backup and tried to restore on another server,seq 35333 is the first archive log when we perform backup,and 35334 is the last archivelog. after the backup successful,I runed “alter system archivelog current” from plsql and shutdown the datbase,so it comes an archive log 35335.we successful run ” restore database” with no error,then it occres the errors below when run “recover database”

Oracle Error:
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01152: file 1 was not restored from a sufficiently old backup
ORA-01110: data file 1: '/u01/oracle/oradata/dbc/data1/system01.dbf'

RMAN-00571: ===============================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS
RMAN-00571: =================================================
RMAN-03002: failure of recover command at 04/02/2009 06:18:16
RMAN-06053: unable to perform media recovery because of missing log
RMAN-03002: failure of recover command at 04/02/2009 06:18:16
RMAN-06053: unable to perform media recovery because of missing log
RMAN-06025: no backup of log thread 1 seq 35332 lowscn 6103122088730 found to restore
RMAN-06025: no backup of log thread 1 seq 35331 lowscn 6103119560491 found to restore
.....many more old logs required

Read more…

下午同时做两个备库，一个9206，一个10203的，都是通过NFS直接将主库的RMAN备份挂到备库相同路径。然后通过rman来restore。

9206的一切正常，10203报错：

ORA-19870: error reading backup piece /bak/rmanbak/test/0ija94hs_1_1_18.bak
ORA-19505: failed to identify file “/bak/rmanbak/test/0ija94hs_1_1_18.bak”
ORA-27054: NFS file system where the file is created or resides is not mounted with correct options
Additional information: 6

Metalink上一查，又碰到bug了。10g的bug真的不是一般的多，随便做个什么操作都可能碰到，晕死。昨天晚上RAC又出了点小毛病，一个节点down掉后无法mount，在其他节点测试，发现控制文件和某些数据文件都无法读取，trace出来一直在做gc domain validation等待，估计由于节点异常宕掉导致某些资源锁无法释放了，没办法只有重启所有节点，而且由于控制文件无法读写，还只能shutdown abort，剩最后一个节点的时候shutdown immediate成功。

10gR2通过NFS执行rman备份恢复都可能碰到这个Bug 5146667，描述详见Note:424785.1，临时解决方法，可以修改nfs的mount参数(不同的平台参数可能不一样)，或者设置10298事件，或者打相关patch。查了下patch好像只有Solaris平台的…

event=’10298 trace name context forever, level 32′