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

最新推荐文章于 2022-02-10 10:48:12 发布
最新推荐文章于 2022-02-10 10:48:12 发布
阅读量305 收藏
点赞数
文章标签： 数据库 5g

点击( 此处 )折叠或打开

  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博客 ” ，链接：http://blog.itpub.net/29990276/viewspace-1623540/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/29990276/viewspace-1623540/

cmbpr28628
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
RMAN转储数据文件报错"ORA-19870 ORA-19502 ORA-27072"
ZXY之路
12-12 3028
在用rman走restore的时候遇到了，如下的错误： channel c1: ORA-19870: error while restoring backup piece /u01/dbfull_03orat5q_1_1.bak ORA-19502: write error on file "/u01/app/oracle/oradata/aux/system01.dbf", block nu
Oracle从磁带恢复备份集,从磁带恢复归档出现ORA-19870错误
weixin_36289292的博客
04-07 1209
从磁带中直接恢复归档日志时，出现了这个错误信息。归档日志前后备份了两次，一次是在备份数据库后做的，另一次是凌晨7点左右进行的，其中第二次备份包含的归档日志比第一次多，最近的归档日志文件备份信息如下：BS KeySizeDevice Type Elapsed Time Completion Time------- ---------- ----------- -----------...
over oracle 不足补零,恢复测试 空间不足导致 ORA-19870 ORA-19502
weixin_35275189的博客
04-13 103
FilesystemSizeUsed Avail Use% Mounted on/dev/hda3 18G 6.8G 10G 41% /udev 4.0G 156K 4.0G 1% /dev/dev/hda1 99M 27M 67M 29% /boottmpfs ...
ORA-19870: 还原备份片段...ORA-19573: 无法获得 exclusive 入队
zhou920786312的博客
06-05 8041
1环境：用户在开启数据库，但是没有打开数据库 2连接目标数据异常 还没有找到原因，希望有人可以帮到我
ORA-19870、ORA-19573
DolphinHat的专栏
12-11 2534
还原数据库时出现ORA-19870和ORA-19573错误，如： RMAN> restore database; Starting restore at 11-DEC-12 using channel ORA_DISK_1 channel ORA_DISK_1: starting datafile backupset restore channel ORA_DISK_1: s
ORA-01654处理表空间不足问题.pdf
06-12
使用过程Oracle 表空间不足时，详细处理办法
数据恢复：被注入的软件及 ORA-600 16703 灾难的恢复.docx
01-22
数据恢复：被注入的软件及 ORA-600 16703 灾难的恢复
Oracle 11gr2连Oracle 19c 报ORA-28040 ORA-01017解决方法.pdf
07-16
Oracle 11gr2连Oracle 19c 报ORA-28040 ORA-01017解决方法
oracle重启报错ORA-00702解决办法
12-24
oracle启动失败，ORA-00702报错，windows，linux系统下解决办法
ORA-702_Recovery使用说明
07-21
该软件修复bootstrap$故障，最常见的错误ORA-00702，使用该工具能够一键修复,实现数据0丢失. 不同.NET Framework对应exe版本说明 ORA-702_Recovery.Net2.exe 为.NET Framework 2.0,3.0,3.5版本支持(比如2008及其...
linux ora-27072,RMAN转储数据文件报错“ORA-19870 ORA-19502 ORA-27072”
weixin_29775951的博客
05-25 407
在用rman走restore的时候遇到了，如下的错误：channel c1: ORA-19870: error while restoring backup piece /u01/dbfull_03orat5q_1_1.bakORA-19502: write error on file "/u01/app/Oracle/oradata/aux/system01.dbf", block number...
ORA-19870 ORA-19504 ORA-17502 ORA-15001 ORA-15040
cpj46358的博客
04-02 1422
RAC+DG环境恢复控制文件报错： RMAN> restore standby controlfile from '/home/oracle/rman_bk/standby_07r1qi38_1_1.ctl'; ...
ORA-19870、ORA-19573错误处理
weixin_33727510的博客
01-12 88
现象： RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =====================================...
oracle中的duplicate,oracle duplicate 的ORA-19870 问题求解
weixin_36038435的博客
04-12 397
我的服务器是linux 数据库版本上10.2.0.1.0,两台机器都一样的,我想从server 1上的database duplicate 到=>server 2 上先是server 1上用backupset 备份了 控制文件,归档日志,数据文件等然后,将备份的文件拷到server 2的相同的文件目录下然后到server 2 上 rman nocatalog target[email=sys...
RMAN ORA-19502&ORA-27072
lwei_998的专栏
03-27 7907
测试库上用rman做恢复的时候遇到了ORA-19502和ORA-27072的错误。 RMAN> restore database; ...... channel ORA_DISK_2: ORA-19870: error while restoring backup piece ORA-19502: write error on file "/app/ora10/oradata/orcl/TD_C
RMAN恢复到ASM报ORA-19870、ORA-19504、ORA-15012、ORA-17502等错误处理
文档搬运工
02-10 1970
使用RMAN恢复数据文件到RAC，报如下错误： RMAN> restore standby controlfile from '/tmp/stdby_ctl' 2> ; Starting restore at 2022:02:0913:37:38 using target database control file instead of recovery catalog allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=1749 i
rman还原时报错ora-19870，ora-19573
nj198624的专栏
11-07 6389
通道 ORA_DISK_1: 正在开始恢复数据文件备份集 通道 ORA_DISK_1: 正在指定从备份集恢复的数据文件 正将数据文件00001恢复到C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\SYSTEM01.DBF 正将数据文件00002恢复到C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\UNDOTBS01.DBF 正将数据文
ora-39097,ora-39065,ora-31644,ora-19502,ora-29701
最新发布
12-19
ORA-19502：这个错误代码表示在备份或恢复过程中出现了错误。可能是由于备份目标不可用或者备份设备出现故障导致的。 ORA-29701：这个错误代码表示在使用Oracle Real Application Clusters（RAC）时，没有足够的...

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值