ITPub博客
首页 博客 专栏 学院 社区 IT新媒体评选
发博

首页 > 数据库 > Oracle > 恢复测试 空间不足导致 ORA-19870 ORA-19502

恢复测试 空间不足导致 ORA-19870 ORA-19502

原创 Oracle 作者：哎呀我的天呐 时间：2015-05-05 11:38:45 0 删除 编辑

点击( 此处 )折叠或打开

  1. RMAN > run{

  2. 2 > set newname for datafile 1   to '/data1/datafile10g/zheng/system01.dbf' ;

  3. 3 > set newname for datafile 2   to '/data1/datafile10g/zheng/undotbs01.dbf' ;

  4. 4 > set newname for datafile 3   to '/data1/datafile10g/zheng/sysaux01.dbf' ;

  5. 5 > set newname for datafile 4   to '/data1/datafile10g/zheng/users01.dbf' ;

  6. 6 > set newname for datafile 5   to '/data1/datafile10g/zheng/trswcm01.dbf' ;

  7. 7 > set newname for datafile 6   to '/data1/datafile10g/zheng/wmly01.dbf' ;

  8. 8 > set newname for datafile 7   to '/data1/datafile10g/zheng/exam01.dbf' ;

  9. 9 > set newname for datafile 8   to '/data1/datafile10g/zheng/bjzj01.dbf' ;

  10. 10 > set newname for datafile 9   to '/data1/datafile10g/zheng/pjuserdb01.dbf' ;

  11. 11 > set newname for datafile 10  to '/data1/datafile10g/zheng/dcl01.dbf' ;

  12. 12 > set newname for datafile 11  to '/data1/datafile10g/zheng/outer01.dbf' ;

  13. 13 > set newname for datafile 12  to '/data1/datafile10g/zheng/data01.dbf' ;

  14. 14 > set newname for datafile 13  to '/data1/datafile10g/zheng/trsmas01.dbf' ;

  15. 15 > set newname for datafile 14  to '/data1/datafile10g/zheng/trswcmplugins01.dbf' ;

  16. 16 > set newname for datafile 15  to '/data1/datafile10g/zheng/trswcm50.dbf' ;

  17. 17 > set newname for datafile 16  to '/data1/datafile10g/zheng/trswcm65.dbf' ;

  18. 18 > set newname for datafile 17  to '/data1/datafile10g/zheng/trswcmz1.dbf' ;

  19. 19 > set newname for datafile 18  to '/data1/datafile10g/zheng/data02.dbf' ;

  20. 20 > set newname for datafile 19  to '/data1/datafile10g/zheng/system02.dbf' ;

  21. 21 > set newname for datafile 20  to '/data1/datafile10g/zheng/users02.dbf' ;

  22. 22 > set newname for datafile 21  to '/data1/datafile10g/zheng/apmon01.dbf' ;

  23. 23 > restore database ;

  24. 24 > switch datafile all ;

  25. 25 > }


  27. executing command : SET NEWNAME

  28. executing command : SET NEWNAME

  29. executing command : SET NEWNAME

  30. executing command : SET NEWNAME

  31. executing command : SET NEWNAME

  32. executing command : SET NEWNAME

  33. executing command : SET NEWNAME

  34. executing command : SET NEWNAME

  35. executing command : SET NEWNAME

  36. executing command : SET NEWNAME

  37. executing command : SET NEWNAME

  38. executing command : SET NEWNAME

  39. executing command : SET NEWNAME

  40. executing command : SET NEWNAME

  41. executing command : SET NEWNAME

  42. executing command : SET NEWNAME

  43. executing command : SET NEWNAME

  44. executing command : SET NEWNAME

  45. executing command : SET NEWNAME

  46. executing command : SET NEWNAME

  47. executing command : SET NEWNAME

  48. Starting restore at 07 - MAY - 15

  49. allocated channel : ORA_DISK_1

  50. channel ORA_DISK_1 : sid = 1972 devtype = DISK



  53. channel ORA_DISK_1 : starting datafile backupset restore

  54. channel ORA_DISK_1 : specifying datafile ( s ) to restore from backup set

  55. restoring datafile 00003 to /data1/datafile10g/zheng/sysaux01 . dbf

  56. restoring datafile 00007 to /data1/datafile10g/zheng/exam01 . dbf

  57. restoring datafile 00008 to /data1/datafile10g/zheng/bjzj01 . dbf

  58. restoring datafile 00009 to /data1/datafile10g/zheng/pjuserdb01 . dbf

  59. restoring datafile 00011 to /data1/datafile10g/zheng/outer01 . dbf

  60. restoring datafile 00012 to /data1/datafile10g/zheng/data01 . dbf

  61. restoring datafile 00014 to /data1/datafile10g/zheng/trswcmplugins01 . dbf

  62. restoring datafile 00015 to /data1/datafile10g/zheng/trswcm50 . dbf

  63. restoring datafile 00016 to /data1/datafile10g/zheng/trswcm65 . dbf

  64. restoring datafile 00019 to /data1/datafile10g/zheng/system02 . dbf

  65. restoring datafile 00021 to /data1/datafile10g/zheng/apmon01 . dbf

  66. channel ORA_DISK_1 : reading from backup piece /data/rmanbak/full_db_9kpgn22e_1_1_20140823

  67. channel ORA_DISK_1 : restored backup piece 1

  68. failover to piece handle = / data1/rmanbak/zheng/full_db_9kpgn22e_1_1_20140823 tag = TAG20140823T231005

  69. channel ORA_DISK_1 : restore complete , elapsed time : 01 : 30 : 37

  70. channel ORA_DISK_1 : starting datafile backupset restore

  71. channel ORA_DISK_1 : specifying datafile ( s ) to restore from backup set

  72. restoring datafile 00001 to /data1/datafile10g/zheng/system01 . dbf

  73. restoring datafile 00002 to /data1/datafile10g/zheng/undotbs01 . dbf

  74. restoring datafile 00004 to /data1/datafile10g/zheng/users01 . dbf

  75. restoring datafile 00005 to /data1/datafile10g/zheng/trswcm01 . dbf

  76. restoring datafile 00006 to /data1/datafile10g/zheng/wmly01 . dbf

  77. restoring datafile 00010 to /data1/datafile10g/zheng/dcl01 . dbf

  78. restoring datafile 00013 to /data1/datafile10g/zheng/trsmas01 . dbf

  79. restoring datafile 00017 to /data1/datafile10g/zheng/trswcmz1 . dbf

  80. restoring datafile 00018 to /data1/datafile10g/zheng/data02 . dbf

  81. restoring datafile 00020 to /data1/datafile10g/zheng/users02 . dbf

  82. channel ORA_DISK_1 : reading from backup piece /data/rmanbak/full_db_9lpgn22e_1_1_20140823

  83. ORA - 19870 : error reading backup piece /data1/rmanbak/zheng/full_db_9lpgn22e_1_1_20140823

  84. ORA - 19502 : write error on file "/data1/datafile10g/zheng/trsmas01.dbf" , blockno 994753 ( blocksize = 8192 )

  85. ORA - 27072 : File I/O error

  86. Linux - x86_64 Error : 9 : Bad file descriptor

  87. Additional information : 4

  88. Additional information : 994753

  89. Additional information : 94208

  90. failover to previous backup



  93. channel ORA_DISK_1 : starting datafile backupset restore

  94. channel ORA_DISK_1 : specifying datafile ( s ) to restore from backup set

  95. restoring datafile 00001 to /data1/datafile10g/zheng/system01 . dbf

  96. restoring datafile 00002 to /data1/datafile10g/zheng/undotbs01 . dbf

  97. restoring datafile 00004 to /data1/datafile10g/zheng/users01 . dbf

  98. restoring datafile 00005 to /data1/datafile10g/zheng/trswcm01 . dbf

  99. restoring datafile 00013 to /data1/datafile10g/zheng/trsmas01 . dbf

  100. restoring datafile 00017 to /data1/datafile10g/zheng/trswcmz1 . dbf

  101. restoring datafile 00018 to /data1/datafile10g/zheng/data02 . dbf

  102. channel ORA_DISK_1 : reading from backup piece /data/rmanbak/full_db_9gpgkdmf_1_1_20140822

  103. ORA - 19870 : error reading backup piece /data/rmanbak/full_db_9gpgkdmf_1_1_20140822

  104. ORA - 19505 : failed to identify file "/data/rmanbak/full_db_9gpgkdmf_1_1_20140822"

  105. ORA - 27037 : unable to obtain file status

  106. Linux - x86_64 Error : 2 : No such file or directory

  107. Additional information : 3

  108. failover to previous backup



  111. RMAN - 00571 : = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =

  112. RMAN - 00569 : = = = = = = = = = = = = = = = ERROR MESSAGE STACK FOLLOWS = = = = = = = = = = = = = = =

  113. RMAN - 00571 : = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =

  114. RMAN - 03002 : failure of restore command at 05/07/2015 04 : 57 : 34

  115. RMAN - 06026 : some targets not found - aborting restore

  116. RMAN - 06023 : no backup or copy of datafile 4 found to restore

  117. RMAN - 06023 : no backup or copy of datafile 2 found to restore

  118. RMAN - 06023 : no backup or copy of datafile 1 found to restore


  120. RMAN > restore database from '/data1/rmanbak/zheng/full_db_9lpgn22e_1_1_20140823' ;


  122. Starting restore at 08 - MAY - 15

  123. using channel ORA_DISK_1


  125. RMAN - 00571 : = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =

  126. RMAN - 00569 : = = = = = = = = = = = = = = = ERROR MESSAGE STACK FOLLOWS = = = = = = = = = = = = = = =

  127. RMAN - 00571 : = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =

  128. RMAN - 03002 : failure of restore command at 05/08/2015 02 : 06 : 37

  129. RMAN - 06509 : only SPFILE or control file can be restored from autobackup

查看文件系统空间不足

点击( 此处 )折叠或打开

  1. yun - recv : / data1 # df - h

  2. Filesystem Size Used Avail Use% Mounted on

  3. /dev/hda3              18G  6 . 7G   11G  41% /

  4. udev                  4 . 0G  156K  4 . 0G   1% /dev

  5. /dev/hda1              99M   27M   67M  29% /boot

  6. tmpfs                 3 . 0G   32K  3 . 0G   1% /dev/shm

  7. /dev/hda6              22G   16G  4 . 8G  77% /data

  8. /dev/mapper/datavg1 - datalv1

  9.                       197G  183G 4 . 4G 98% /data1

这些空间肯定不够剩下数据文件转储的
重新转储，监控下文件系统

点击( 此处 )折叠或打开

  1. # ! / bin/sh

  2. while true

  3. do

  4. df - h > > /home/oracle/ df . log

  5. sleep 5

  6. done


点击( 此处 )折叠或打开

  1. Filesystem Size Used Avail Use% Mounted on

  2. /dev/hda3              18G  6 . 8G   10G  41% /

  3. udev                  4 . 0G  156K  4 . 0G   1% /dev

  4. /dev/hda1              99M   27M   67M  29% /boot

  5. tmpfs                 3 . 0G   32K  3 . 0G   1% /dev/shm

  6. /dev/hda6              22G   16G  4 . 8G  77% /data

  7. /dev/mapper/datavg1 - datalv1

  8.                        197G  187G 29M 100% /data1

  9. /dev/hdb5              99G   66G   28G  71% /rman_file


  11. Filesystem Size Used Avail Use% Mounted on

  12. /dev/hda3              18G  6 . 8G   10G  41% /

  13. udev                  4 . 0G  156K  4 . 0G   1% /dev

  14. /dev/hda1              99M   27M   67M  29% /boot

  15. tmpfs                 3 . 0G   32K  3 . 0G   1% /dev/shm

  16. /dev/hda6              22G   16G  4 . 8G  77% /data

  17. /dev/mapper/datavg1 - datalv1

  18.                       197G  187G 27M 100% /data1

  19. /dev/hdb5              99G   66G   28G  71% /rman_file


  21. Filesystem Size Used Avail Use% Mounted on

  22. /dev/hda3              18G  6 . 8G   10G  41% /

  23. udev                  4 . 0G  156K  4 . 0G   1% /dev

  24. /dev/hda1              99M   27M   67M  29% /boot

  25. tmpfs                 3 . 0G   32K  3 . 0G   1% /dev/shm

  26. /dev/hda6              22G   16G  4 . 8G  77% /data

  27. /dev/mapper/datavg1 - datalv1

  28.                       197G  187G   24M 100% /data1

  29. /dev/hdb5              99G   66G   28G  71% /rman_file


  31. Filesystem Size Used Avail Use% Mounted on

  32. /dev/hda3              18G  6 . 8G   10G  41% /

  33. udev                  4 . 0G  156K  4 . 0G   1% /dev

  34. /dev/hda1              99M   27M   67M  29% /boot

  35. tmpfs                 3 . 0G   32K  3 . 0G   1% /dev/shm

  36. /dev/hda6              22G   16G  4 . 8G  77% /data

  37. /dev/mapper/datavg1 - datalv1

  38.                       197G  187G   19M 100% /data1

  39. /dev/hdb5              99G   66G   28G  71% /rman_file


  41. Filesystem Size Used Avail Use% Mounted on

  42. /dev/hda3              18G  6 . 8G   10G  41% /

  43. udev                  4 . 0G  156K  4 . 0G   1% /dev

  44. /dev/hda1              99M   27M   67M  29% /boot

  45. tmpfs                 3 . 0G   32K  3 . 0G   1% /dev/shm

  46. /dev/hda6              22G   16G  4 . 8G  77% /data

  47. /dev/mapper/datavg1 - datalv1

  48.                       197G  187G   13M 100% /data1

  49. /dev/hdb5              99G   66G   28G  71% /rman_file


  51. Filesystem Size Used Avail Use% Mounted on

  52. /dev/hda3              18G  6 . 8G   10G  41% /

  53. udev                  4 . 0G  156K  4 . 0G   1% /dev

  54. /dev/hda1              99M   27M   67M  29% /boot

  55. tmpfs                 3 . 0G   32K  3 . 0G   1% /dev/shm

  56. /dev/hda6              22G   16G  4 . 8G  77% /data

  57. /dev/mapper/datavg1 - datalv1

  58.                       197G  187G  6 . 4M 100% /data1

  59. /dev/hdb5              99G   66G   28G  71% /rman_file


  61. Filesystem Size Used Avail Use% Mounted on

  62. /dev/hda3              18G  6 . 8G   10G  41% /

  63. udev                  4 . 0G  156K  4 . 0G   1% /dev

  64. /dev/hda1              99M   27M   67M  29% /boot

  65. tmpfs                 3 . 0G   32K  3 . 0G   1% /dev/shm

  66. /dev/hda6              22G   16G  4 . 8G  77% /data

  67. /dev/mapper/datavg1 - datalv1

  68.                       197G  187G     0 100% /data1

  69. /dev/hdb5              99G   66G   28G  71% /rman_file


  71. Filesystem Size Used Avail Use% Mounted on

  72. /dev/hda3              18G  6 . 8G   10G  41% /

  73. udev                  4 . 0G  156K  4 . 0G   1% /dev

  74. /dev/hda1              99M   27M   67M  29% /boot

  75. tmpfs                 3 . 0G   32K  3 . 0G   1% /dev/shm

  76. /dev/hda6              22G   16G  4 . 8G  77% /data

  77. /dev/mapper/datavg1 - datalv1

  78.                       197G  187G     0 100% /data1

  79. /dev/hdb5              99G   66G   28G  71% /rman_file


  81. Filesystem Size Used Avail Use% Mounted on

  82. /dev/hda3              18G  6 . 8G   10G  41% /

  83. udev                  4 . 0G  156K  4 . 0G   1% /dev

  84. /dev/hda1              99M   27M   67M  29% /boot

  85. tmpfs                 3 . 0G   32K  3 . 0G   1% /dev/shm

  86. /dev/hda6              22G   16G  4 . 8G  77% /data

  87. /dev/mapper/datavg1 - datalv1

  88.                       197G  187G     0 100% /data1

  89. /dev/hdb5              99G   66G   28G  71% /rman_file


  91. Filesystem Size Used Avail Use% Mounted on

  92. /dev/hda3              18G  6 . 8G   10G  41% /

  93. udev                  4 . 0G  156K  4 . 0G   1% /dev

  94. /dev/hda1              99M   27M   67M  29% /boot

  95. tmpfs                 3 . 0G   32K  3 . 0G   1% /dev/shm

  96. /dev/hda6              22G   16G  4 . 8G  77% /data

  97. /dev/mapper/datavg1 - datalv1

  98.                       197G  187G     0 100% /data1

  99. /dev/hdb5              99G   66G   28G  71% /rman_file


  101. Filesystem Size Used Avail Use% Mounted on

  102. /dev/hda3              18G  6 . 9G  9 . 9G  41% /

  103. udev                  4 . 0G  156K  4 . 0G   1% /dev

  104. /dev/hda1              99M   27M   67M  29% /boot

  105. tmpfs                 3 . 0G   32K  3 . 0G   1% /dev/shm

  106. /dev/hda6              22G   16G  4 . 8G  77% /data

  107. /dev/mapper/datavg1 - datalv1

  108.                       197G  187G     0 100% /data1

  109. /dev/hdb5              99G   66G   28G  71% /rman_file


  111. Filesystem Size Used Avail Use% Mounted on

  112. /dev/hda3              18G  6 . 9G  9 . 9G  41% /

  113. udev                  4 . 0G  156K  4 . 0G   1% /dev

  114. /dev/hda1              99M   27M   67M  29% /boot

  115. tmpfs                 3 . 0G   32K  3 . 0G   1% /dev/shm

  116. /dev/hda6              22G   16G  4 . 8G  77% /data

  117. /dev/mapper/datavg1 - datalv1

  118.                       197G  185G  2 . 6G  99% /data1

  119. /dev/hdb5              99G   66G   28G  71% /rman_file


  121. Filesystem Size Used Avail Use% Mounted on

  122. /dev/hda3              18G  6 . 9G  9 . 9G  41% /

  123. udev                  4 . 0G  156K  4 . 0G   1% /dev

  124. /dev/hda1              99M   27M   67M  29% /boot

  125. tmpfs                 3 . 0G   32K  3 . 0G   1% /dev/shm

  126. /dev/hda6              22G   16G  4 . 8G  77% /data

  127. /dev/mapper/datavg1 - datalv1

  128.                       197G  184G  2 . 9G  99% /data1

  129. /dev/hdb5              99G   66G   28G  71% /rman_file


  131. Filesystem Size Used Avail Use% Mounted on

  132. /dev/hda3              18G  6 . 9G  9 . 9G  41% /

  133. udev                  4 . 0G  156K  4 . 0G   1% /dev

  134. /dev/hda1              99M   27M   67M  29% /boot

  135. tmpfs                 3 . 0G   32K  3 . 0G   1% /dev/shm

  136. /dev/hda6              22G   16G  4 . 8G  77% /data

  137. /dev/mapper/datavg1 - datalv1

  138.                       197G  184G  3 . 0G  99% /data1

  139. /dev/hdb5              99G   66G   28G  71% /rman_file


  141. Filesystem Size Used Avail Use% Mounted on

  142. /dev/hda3              18G  6 . 9G  9 . 9G  42% /

  143. udev                  4 . 0G  156K  4 . 0G   1% /dev

  144. /dev/hda1              99M   27M   67M  29% /boot

  145. tmpfs                 3 . 0G   32K  3 . 0G   1% /dev/shm

  146. /dev/hda6              22G   16G  4 . 8G  77% /data

  147. /dev/mapper/datavg1 - datalv1

  148.                       197G  184G  3 . 1G  99% /data1

  149. /dev/hdb5              99G   66G   28G  71% /rman_file


  151. Filesystem Size Used Avail Use% Mounted on

  152. /dev/hda3              18G  6 . 9G  9 . 9G  42% /

  153. udev                  4 . 0G  156K  4 . 0G   1% /dev

  154. /dev/hda1              99M   27M   67M  29% /boot

  155. tmpfs                 3 . 0G   32K  3 . 0G   1% /dev/shm

  156. /dev/hda6              22G   16G  4 . 8G  77% /data

  157. /dev/mapper/datavg1 - datalv1

  158.                       197G  184G  3 . 2G  99% /data1

  159. /dev/hdb5              99G   66G   28G  71% /rman_file


  161. Filesystem Size Used Avail Use% Mounted on

  162. /dev/hda3              18G  6 . 9G  9 . 9G  42% /

  163. udev                  4 . 0G  156K  4 . 0G   1% /dev

  164. /dev/hda1              99M   27M   67M  29% /boot

  165. tmpfs                 3 . 0G   32K  3 . 0G   1% /dev/shm

  166. /dev/hda6              22G   16G  4 . 8G  77% /data

  167. /dev/mapper/datavg1 - datalv1

  168.                       197G  184G  3 . 4G  99% /data1

  169. /dev/hdb5              99G   66G   28G  71% /rman_file


  171. Filesystem Size Used Avail Use% Mounted on

  172. /dev/hda3              18G  6 . 9G  9 . 9G  42% /

  173. udev                  4 . 0G  156K  4 . 0G   1% /dev

  174. /dev/hda1              99M   27M   67M  29% /boot

  175. tmpfs                 3 . 0G   32K  3 . 0G   1% /dev/shm

  176. /dev/hda6              22G   16G  4 . 8G  77% /data

  177. /dev/mapper/datavg1 - datalv1

  178.                       197G  184G  3 . 5G  99% /data1

  179. /dev/hdb5              99G   66G   28G  71% /rman_file

当报错之后，文件会倒退，空间释放， 致此确定原因
重新搞喽~嘿嘿                    

来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/29990276/viewspace-1623540/ ，如需转载，请注明出处，否则将追究法律责任。

0
0
上一篇： enq: RO fast object reuse 和 enq: KO fast object checkpoint
下一篇： ASH报告解读
请登录后发表评论 登录
全部评论
哎呀我的天呐
专家姓名：姚崇
https://cloud.tencent.com/developer/inventory/14362

注册时间：2014-10-30

  • 博文量
    403
  • 访问量
    2528746

最新文章

支持我们 作者招募 用户协议 FAQ Contact Us

北京盛拓优讯信息技术有限公司. 版权所有  京ICP备16024965号-8 北京市公安局海淀分局网监中心备案编号：11010802021510 niuxiaotong@pcpop.com 17352615567 未成年人举报专区

广播电视节目制作经营许可证(京) 字第1234号 中国互联网协会会员

违法和不良信息举报电话:18101376593