online 表空间报ora600
迁移数据文件步骤：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: , , , , [], [], [], []
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
页:
[1]