- 最后登录
- 2017-5-4
- 在线时间
- 81 小时
- 威望
- 999
- 金钱
- 2391
- 注册时间
- 2013-9-11
- 阅读权限
- 150
- 帖子
- 1124
- 精华
- 5
- 积分
- 999
- UID
- 1220
|
1#
发表于 2017-4-16 00:03:54
|
查看: 1862 |
回复: 0
迁移数据文件步骤:
alter tablespace test offline;
cp /oradataa/test.dbf /oradatab/test.dbf
alter tablespace test rename datafile '/oradataa/test.dbf' to '/oradatab/test.dbf'
alter tablespace test online;
online时出错
ora-600
日志文件:
alter tablespace test offline
Fri Mar 30 14:09:28 2012
Completed: alter tablespace test offline
Fri Mar 30 17:49:59 2012
alter tablespace test rename datafile '/oradataa/test.dbf' to '/oradatab/test.dbf'
Fri Mar 30 17:50:03 2012
Completed: alter tablespace test rename datafile '/oradataa/test.dbf' to '/oradatab/test.dbf'
Fri Mar 30 17:50:03 2012
alter tablespace test online
Fri Mar 30 17:53:08 2012
Errors in file /oracle/ora10/admin/ora10g/udump/ora10g_ora_21275.trc:
ORA-00600: internal error code, arguments: [kcbz_check_objd_typ], [0], [0], [1], [], [], [], []
Fri Mar 30 17:54:11 2012
ORA-600 signalled during: alter tablespace test online...
Fri Mar 30 23:51:59 2012
Errors in file /oracle/ora10/admin/ora10g/bdump/ora10g_j002_10517.trc:
ORA-12012: error on auto execute of job 8952
ORA-00376: file ORA-00376: file 9 cannot be read at this time
ORA-01110: data file 9: '/oradatab/test.dbf'
ORA-06512: at "SYS.PRVT_ADVISOR", line 1624
ORA-06512: at "SYS.DBMS_ADVISOR", line 186
ORA-06512: at "SYS.DBMS_SPACE", line 1500
ORA-06512: at "SYS.DBMS_SPACE", line 1566
cannot be read at this time
做回退操作:
alter tablespace test rename datafile '/oradatab/test.dbf' to '/oradataa/test.dbf'
需要介质恢复
recovery datafile 9;
恢复成功
alter tablespace test online;
还是报ora-600
什么备份也没有,只有数据文件;做得操作就是上面那些,要是我在offline表空间是再offlien数据文件就不会出错了
Errors in file /oracle/ora10/admin/ora10g/bdump/ora10g_j000_672.trc:
ORA-12012: error on auto execute of job 212382
ORA-00936: missing expression
Wed Mar 21 01:00:31 2012
Errors in file /oracle/ora10/admin/ora10g/bdump/ora10g_j000_26910.trc:
ORA-12012: error on auto execute of job 212382
ORA-00936: missing expression
Thu Mar 22 01:00:25 2012
Errors in file /oracle/ora10/admin/ora10g/bdump/ora10g_j000_19208.trc:
ORA-12012: error on auto execute of job 212382
ORA-00936: missing expression
Thu Mar 22 13:09:44 2012
Thread 1 advanced to log sequence 1329 (LGWR switch)
Current log# 3 seq# 1329 mem# 0: /oraredo/redo03.log
Fri Mar 23 01:00:26 2012
Errors in file /oracle/ora10/admin/ora10g/bdump/ora10g_j000_11240.trc:
ORA-12012: error on auto execute of job 212382
ORA-00936: missing expression
Fri Mar 23 09:14:09 2012
WARNING: inbound connection timed out (ORA-3136)
Sat Mar 24 01:00:27 2012
Errors in file /oracle/ora10/admin/ora10g/bdump/ora10g_j000_32182.trc:
ORA-12012: error on auto execute of job 212382
ORA-00936: missing expression
Sun Mar 25 01:00:25 2012
Errors in file /oracle/ora10/admin/ora10g/bdump/ora10g_j000_3553.trc:
ORA-12012: error on auto execute of job 212382
ORA-00936: missing expression
Mon Mar 26 00:00:08 2012
Errors in file /oracle/ora10/admin/ora10g/bdump/ora10g_j000_24564.trc:
ORA-12012: error on auto execute of job 119586
ORA-01846: not a valid day of the week
Mon Mar 26 00:00:16 2012
Errors in file /oracle/ora10/admin/ora10g/bdump/ora10g_j000_24564.trc:
ORA-12012: error on auto execute of job 119013
ORA-01846: not a valid day of the week
Mon Mar 26 01:00:28 2012
Errors in file /oracle/ora10/admin/ora10g/bdump/ora10g_j000_29762.trc:
ORA-12012: error on auto execute of job 212382
ORA-00936: missing expression
Mon Mar 26 02:01:31 2012
Thread 1 advanced to log sequence 1330 (LGWR switch)
Current log# 1 seq# 1330 mem# 0: /oraredo/redo01.log
Tue Mar 27 01:00:31 2012
Errors in file /oracle/ora10/admin/ora10g/bdump/ora10g_j000_7280.trc:
ORA-12012: error on auto execute of job 212382
ORA-00936: missing expression
Wed Mar 28 01:00:28 2012
Errors in file /oracle/ora10/admin/ora10g/bdump/ora10g_j000_20806.trc:
ORA-12012: error on auto execute of job 212382
在迁移表空间之前报好多 job执行错误
采用2、3方法,再online表空间时还是 ORA-600 [KCBZ_CHECK_OBJD_TYP]
|
|