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

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

26

积分

0

好友

5

主题
1#
发表于 2013-7-5 16:14:55 | 查看: 3485| 回复: 0
本帖最后由 Jer0n 于 2013-7-5 16:17 编辑

环境:AIX 6.1 + Oracle 11.2.2
问题:每天往磁带库备份后errpt中总会产生系统日志错误,其中数据库备份为正常。

刘总,有时间的话,请帮忙诊断一下,有可能出现问题的点,谢谢!
  1. # cat full_back.cmd
  2. su - oracle << EOF
  3. cd /home/oracle/rman/
  4. echo "***************************" >> /home/oracle/rman/backup.log
  5. echo " full backup begin " >> /home/oracle/rman/backup.log
  6. date  >> /home/oracle/rman/backup.log
  7. rman target /  log=/home/oracle/rman/backup.log<<EOF1
  8. @full_backup.rma
  9. exit
  10. EOF1
  11. date  >> /home/oracle/rman/backup.log
  12. EOF
复制代码
  1. # cat full_backup.rma
  2. run{allocate channel ch00 type 'sbt_tape' parms 'ENV=(tdpo_optfile=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';backup format 'winddb_full_%T_%t_%U' database;backup format 'winddb_arc_%s_%p_%t' archivelog all delete input;backup format 'winddb_control_%s_%p_%t' current controlfile;release channel ch00;}
复制代码
  1. # errpt
  2. IDENTIFIER TIMESTAMP  T C RESOURCE_NAME  DESCRIPTION
  3. A924A5FC   0704191713 P S SYSPROC        SOFTWARE PROGRAM ABNORMALLY TERMINATED
  4. A924A5FC   0703192113 P S SYSPROC        SOFTWARE PROGRAM ABNORMALLY TERMINATED
  5. A924A5FC   0702192013 P S SYSPROC        SOFTWARE PROGRAM ABNORMALLY TERMINATED
  6. A924A5FC   0701192113 P S SYSPROC        SOFTWARE PROGRAM ABNORMALLY TERMINATED
  7. A924A5FC   0630191513 P S SYSPROC        SOFTWARE PROGRAM ABNORMALLY TERMINATED
  8. A924A5FC   0629192013 P S SYSPROC        SOFTWARE PROGRAM ABNORMALLY TERMINATED
  9. A924A5FC   0628191913 P S SYSPROC        SOFTWARE PROGRAM ABNORMALLY TERMINATED
  10. A924A5FC   0627192313 P S SYSPROC        SOFTWARE PROGRAM ABNORMALLY TERMINATED
  11. A924A5FC   0626191913 P S SYSPROC        SOFTWARE PROGRAM ABNORMALLY TERMINATED
  12. A924A5FC   0625192713 P S SYSPROC        SOFTWARE PROGRAM ABNORMALLY TERMINATED
  13. A924A5FC   0624191513 P S SYSPROC        SOFTWARE PROGRAM ABNORMALLY TERMINATED
  14. A924A5FC   0623191513 P S SYSPROC        SOFTWARE PROGRAM ABNORMALLY TERMINATED
  15. A924A5FC   0622192013 P S SYSPROC        SOFTWARE PROGRAM ABNORMALLY TERMINATED
  16. A924A5FC   0621191613 P S SYSPROC        SOFTWARE PROGRAM ABNORMALLY TERMINATED
  17. A924A5FC   0620192613 P S SYSPROC        SOFTWARE PROGRAM ABNORMALLY TERMINATED
  18. A924A5FC   0619192513 P S SYSPROC        SOFTWARE PROGRAM ABNORMALLY TERMINATED
  19. A924A5FC   0618192513 P S SYSPROC        SOFTWARE PROGRAM ABNORMALLY TERMINATED
  20. A924A5FC   0617192813 P S SYSPROC        SOFTWARE PROGRAM ABNORMALLY TERMINATED
  21. A924A5FC   0616192413 P S SYSPROC        SOFTWARE PROGRAM ABNORMALLY TERMINATED
  22. A924A5FC   0615192213 P S SYSPROC        SOFTWARE PROGRAM ABNORMALLY TERMINATED
  23. A924A5FC   0614192713 P S SYSPROC        SOFTWARE PROGRAM ABNORMALLY TERMINATED
  24. A924A5FC   0613192113 P S SYSPROC        SOFTWARE PROGRAM ABNORMALLY TERMINATED
  25. A924A5FC   0612192213 P S SYSPROC        SOFTWARE PROGRAM ABNORMALLY TERMINATED
  26. A924A5FC   0611192413 P S SYSPROC        SOFTWARE PROGRAM ABNORMALLY TERMINATED
  27. A924A5FC   0610192513 P S SYSPROC        SOFTWARE PROGRAM ABNORMALLY TERMINATED
  28. A924A5FC   0609192013 P S SYSPROC        SOFTWARE PROGRAM ABNORMALLY TERMINATED
  29. A924A5FC   0608191913 P S SYSPROC        SOFTWARE PROGRAM ABNORMALLY TERMINATED
  30. A924A5FC   0607192713 P S SYSPROC        SOFTWARE PROGRAM ABNORMALLY TERMINATED
  31. A924A5FC   0606192713 P S SYSPROC        SOFTWARE PROGRAM ABNORMALLY TERMINATED
  32. A924A5FC   0605192813 P S SYSPROC        SOFTWARE PROGRAM ABNORMALLY TERMINATED
复制代码
  1. # errpt -a|more
  2. ---------------------------------------------------------------------------
  3. LABEL:          CORE_DUMP
  4. IDENTIFIER:     A924A5FC

  5. Date/Time:       Thu Jul  4 19:17:41 GMT+08:00 2013
  6. Sequence Number: 43723
  7. Machine Id:      00F752144C00
  8. Node Id:         P1WCSDB01
  9. Class:           S
  10. Type:            PERM
  11. WPAR:            Global
  12. Resource Name:   SYSPROC         

  13. Description
  14. SOFTWARE PROGRAM ABNORMALLY TERMINATED

  15. Probable Causes
  16. SOFTWARE PROGRAM

  17. User Causes
  18. USER GENERATED SIGNAL

  19.         Recommended Actions
  20.         CORRECT THEN RETRY

  21. Failure Causes
  22. SOFTWARE PROGRAM

  23.         Recommended Actions
  24.         RERUN THE APPLICATION PROGRAM
  25.         IF PROBLEM PERSISTS THEN DO THE FOLLOWING
  26.         CONTACT APPROPRIATE SERVICE REPRESENTATIVE

  27. Detail Data
  28. SIGNAL NUMBER
  29.            4
  30. USER'S PROCESS ID:
  31.               19988804
  32. FILE SYSTEM SERIAL NUMBER
  33.           14
  34. INODE NUMBER
  35.            0         480
  36. CORE FILE NAME
  37. /oracle/product/11.2/dbs/core
  38. PROGRAM NAME
  39. oracle
  40. STACK EXECUTION DISABLED
  41.            0
  42. COME FROM ADDRESS REGISTER
  43. exit 104

  44. PROCESSOR ID
  45.   hw_fru_id: 1
  46.   hw_cpu_id: 10

  47. ADDITIONAL INFORMATION
  48. ??
  49. exit 108
  50. skgpexit 40
  51. ssthrdmai 244
  52. main DC
  53. __start 74

  54. Symptom Data
  55. REPORTABLE
  56. 1
  57. INTERNAL ERROR
  58. 0
  59. SYMPTOM CODE
  60. PCSS/SPI2 FLDS/oracle SIG/4 FLDS/exit VALU/108
  61. ---------------------------------------------------------------------------
  62. LABEL:          CORE_DUMP
  63. IDENTIFIER:     A924A5FC
复制代码
您需要登录后才可以回帖 登录 | 注册

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

GMT+8, 2024-11-16 21:56 , Processed in 0.047988 second(s), 21 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

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