- 博客(3)
- 收藏
- 关注
原创 repair failure修复坏块
刚刚逛论坛,看到一个网友说他dd破坏的块用repair failure修复不了,我这里也实验一把试试测试之前先做一个备份RMAN> backup database;Starting backup at 12-MAR-14using target database control file instead of recovery catalogallocated channe
2014-03-12 14:38:12 1418
原创 corrupt block导致rman备份失败
用rman备份测试库的时候报错,信息如下:RMAN> backup database;Starting backup at 12-MAR-14allocated channel: ORA_DISK_1channel ORA_DISK_1: SID=5 device type=DISKchannel ORA_DISK_1: starting full datafile backu
2014-03-12 14:16:15 1227
原创 ORA-38104: Columns referenced in the ON Clause cannot be updated: "U"."USER_ID"
在用merge语句更新一个表的时候报错:SQL> merge into OUTSITE_USERINFO u 2 using tmp_update_newlib ut 3 on (u.user_id = ut.NEWCOURSE_ID) 4 when matched then 5 update set u.user_id = ut
2014-03-08 12:12:31 6356
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人