Oracle数据库数据恢复、性能优化

找回密码
注册
搜索
热搜: 活动 交友 discuz
发新帖

999

积分

1

好友

942

主题
1#
发表于 2017-4-16 00:03:54 | 查看: 1865| 回复: 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]

下载专业ORACLE数据库恢复工具PRM-DUL  For Oracle http://www.parnassusdata.com/

如果自己搞不定可以找诗檀软件专业ORACLE数据库修复团队成员帮您恢复!

诗檀软件专业数据库修复团队

服务热线 : 13764045638  QQ: 47079569     邮箱:service@parnassusdata.com
您需要登录后才可以回帖 登录 | 注册

QQ|手机版|Archiver|Oracle数据库数据恢复、性能优化

GMT+8, 2024-12-23 15:34 , Processed in 0.045888 second(s), 21 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

回顶部
TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569