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

最新推荐文章于 2023-09-11 16:26:09 发布
最新推荐文章于 2023-09-11 16:26:09 发布
阅读量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
    评论
ORA-01654处理表空间不足问题.pdf
06-12
使用过程Oracle 表空间不足时，详细处理办法
数据恢复：被注入的软件及 ORA-600 16703 灾难的恢复.docx
01-22
数据恢复：被注入的软件及 ORA-600 16703 灾难的恢复
Oracle从磁带恢复备份集,从磁带恢复归档出现ORA-19870错误
weixin_36289292的博客
04-07 1210
从磁带中直接恢复归档日志时，出现了这个错误信息。归档日志前后备份了两次，一次是在备份数据库后做的，另一次是凌晨7点左右进行的，其中第二次备份包含的归档日志比第一次多，最近的归档日志文件备份信息如下：BS KeySizeDevice Type Elapsed Time Completion Time------- ---------- ----------- -----------...
ORA-19870: 还原备份片段...ORA-19573: 无法获得 exclusive 入队
zhou920786312的博客
06-05 8042
1环境：用户在开启数据库，但是没有打开数据库 2连接目标数据异常 还没有找到原因，希望有人可以帮到我
ORA-19870、ORA-19573
DolphinHat的专栏
12-11 2535
还原数据库时出现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
rman还原时报错ora-19870，ora-19573
nj198624的专栏
11-07 6394
通道 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-19870、ORA-19573错误处理
weixin_34293141的博客
11-22 865
现象： RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: ==================...
Oracle异机恢复时报错ora-19870 ora-19507
weixin_30686845的博客
02-07 1437
Oracle数据库使用NBU备份到带库中，在做异机恢复时报错如下： channel ch00: restoring control file released channel: ch00 RMAN-00571: =========================================================== RMAN-00...
linux ora-27072,RMAN转储数据文件报错“ORA-19870 ORA-19502 ORA-27072”
weixin_29775951的博客
05-25 408
在用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...
oracle恢复工具-FY_Recover_Data
05-08
否则会导致服务器RMAN备份失败ORA-19566 超出损坏块限制（切记） truncate原理： ? ? ? ?TRUNCATE不会逐个清除用户数据块上的数据，而仅仅重置数据字典和元数据块上的元数据（如存储段头和扩展段...
Oracle9i的init.ora参数中文说明
11-07
Oracle9i初始化参数中文说明 Blank_trimming: 说明: 如果值为TRUE, 即使源长度比目标长度 (SQL92 兼容) 更长, 也允许分配数据。 值范围: TRUE | FALSE 默认值: FALSE serializable: 说明: 确定查询是否获取表级...
oracle rman 恢复攻略
02-11
Oracle RMAN（Recovery Manager）是Oracle数据库管理系统中用于备份和恢复的重要工具。它提供了全面的数据保护策略，包括完整数据库备份...在实际操作中，一定要对生产环境进行充分的测试，避免因误操作导致数据丢失。
ORACLE_维护手册
10-23
1. **备份与恢复策略**：确保有计划的数据备份，包括全备和增量备份，并进行恢复测试，验证备份的有效性。 2. **性能调优**：分析AWR报告，识别性能瓶颈，调整初始化参数，优化内存分配和I/O平衡。 3. **更新补丁*...
oracle 数据库由Linux平台向Ｗindows平台迁移
05-10
- 如果遇到控制文件的问题，可能需要使用`ALTER DATABASE CREATE CONTROLFILE`语句重新创建控制文件，确保所有表空间都被正确引用。 4. **注意事项**： - 平台间的硬件差异可能会影响数据库的性能和兼容性。确保...
RMAN恢复到ASM报ORA-19870、ORA-19504、ORA-15012、ORA-17502等错误处理
文档搬运工
02-10 1972
使用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
[重庆思庄每日技术分享]-rac expdp导出时报错：ORA-31693、ORA-31617、ORA-19505、ORA-27037
XIANHUAFANG的博客
04-07 1002
rac expdp导出时报错： ORA-31693: Table data object "testuser"."test" failed to load/unload and is being skipped due to error: ORA-31617: unable to open dump file "/home/oracle/exp_dir/full05.dmp" for write ORA-19505: failed to identify file "/home/oracle/exp_
ORACLE STANDBY 修复ORA-19505问题记录
热门推荐
csdn's blog
08-02 1万+
备库down了，经过检查，坏块无法做增量修复，所以需要重新搭建的方式来修复standby库，oracle11g里面有duplicate的方式远程在线修复命令： run { allocate auxiliary channel c1 device type disk; allocate auxiliary channel c2 device type disk; duplicate target ...
Oracle集群管理数据泵-数据泵导数据时报错ora-39126 ora-39155 ora-48128 ora-19505 ora-27037
oradbm的博客
09-11 511
导出语句：expdp \'/ as sysdba\' directory=empdp_dir dumpfile=expdp.dmp full=y parallel=8 logfile=expdp.log。说明：在执行导出语句前切换到需要全库导出的实例环境变量下，且创建directory.经确认在rac模式下，进行数据泵并发导出或导入时，需添加参数cluster=n。环境：rac + non cdb +多实例。数据库：oracle 19.12 64位。系统：oel 7.9 64位。此后，成功全库导出.
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、付费专栏及课程。

余额充值