Rman restore 报错 ORA-19502 ORA-15081

Cyrill

飞总，我在rman下restore后，出现以下问题: channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00001 to +DATA/gzpb/datafile/system.263.799607887
channel ORA_DISK_1: restoring datafile 00002 to +DATA/gzpb/datafile/sysaux.404.843647025
channel ORA_DISK_1: restoring datafile 00003 to +DATA/gzpb/datafile/undotbs1.396.843651109
channel ORA_DISK_1: restoring datafile 00004 to +DATA/gzpb/datafile/users.414.843648155
channel ORA_DISK_1: restoring datafile 00005 to +DATA/gzpb/datafile/undotbs2.397.843651383
channel ORA_DISK_1: restoring datafile 00006 to +DATA/gzpb/datafile/epointbid_pb2011.dbf
channel ORA_DISK_1: restoring datafile 00007 to +DATA/gzpb/datafile/epointbid_zs.dbf
channel ORA_DISK_1: restoring datafile 00008 to +DATA/gzpb/datafile/epointbid_bzb5.dbf
channel ORA_DISK_1: restoring datafile 00009 to +DATA/gzpb/datafile/f2011.dbf
channel ORA_DISK_1: restoring datafile 00010 to +DATA/gzpb/datafile/epointbid_pb2011_his.dbf
channel ORA_DISK_1: restoring datafile 00011 to +DATA/gzpb/datafile/epointbid_pwqd.dbf
channel ORA_DISK_1: restoring datafile 00012 to +DATA/gzpb/datafile/epointbid_pb2011_his02.dbf
channel ORA_DISK_1: restoring datafile 00013 to +DATA/gzpb/datafile/epointbid_pb2011_02.dbf
channel ORA_DISK_1: restoring datafile 00014 to +DATA/gzpb/datafile/epointbid_pb2011_his_2.dbf
channel ORA_DISK_1: restoring datafile 00015 to +DATA/gzpb/datafile/f2011_02.dbf
channel ORA_DISK_1: restoring datafile 00016 to +DATA/gzpb/datafile/epointbid_pb2011.398.843650553
channel ORA_DISK_1: restoring datafile 00017 to +DATA/gzpb/datafile/epointbid_pwqd02.dbf
channel ORA_DISK_1: restoring datafile 00018 to +DATA/gzpb/datafile/epointbid_pb2011_his_2_02.dbf
channel ORA_DISK_1: reading from backup piece /ora_bak/bak_inc0_GZPB_20140303_qfp2816v_1_1
channel ORA_DISK_1: piece handle=/ora_bak/bak_inc0_GZPB_20140303_qfp2816v_1_1 tag=BAK_INC0
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: reading from backup piece /ora_bak/bak_inc0_GZPB_20140303_qfp2816v_2_1
channel ORA_DISK_1: piece handle=/ora_bak/bak_inc0_GZPB_20140303_qfp2816v_2_1 tag=BAK_INC0
channel ORA_DISK_1: restored backup piece 2
channel ORA_DISK_1: reading from backup piece /ora_bak/bak_inc0_GZPB_20140303_qfp2816v_3_1
channel ORA_DISK_1: ORA-19870: error while restoring backup piece /ora_bak/bak_inc0_GZPB_20140303_qfp2816v_3_1
ORA-19502: write error on file "+DATA/gzpb/datafile/f2011_02.dbf", block number 136960 (block size=8192)
ORA-15081: failed to submit an I/O operation to a disk
ORA-15081: failed to submit an I/O operation to a disk

c. dbms_backup_restore.restoreCancel() failed
failover to previous backup

ORACLE error from target database:
ORA-00204: error in reading (block 1, # blocks 1) of control file
ORA-00202: control file: '+DATA/gzpb/controlfile/current.425.831638825'
ORA-15078: ASM diskgroup was forcibly dismounted

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 03/31/2014 13:13:53
RMAN-06026: some targets not found - aborting restore
RMAN-06023: no backup or copy of datafile 4 found to restore
RMAN-06023: no backup or copy of datafile 3 found to restore
RMAN-06023: no backup or copy of datafile 2 found to restore
RMAN-06023: no backup or copy of datafile 1 found to restore


是什么问题 ，如何解决？

travel.liu

1. ORACLE error from target database:
   
2. ORA-00204: error in reading (block 1, # blocks 1) of control file
   
3. ORA-00202: control file: '+DATA/gzpb/controlfile/current.425.831638825'
   
4. ORA-15078: ASM diskgroup was forcibly dismounted

复制代码

磁盘组dismounted，看下asm的日志

xifenfei

ORA-00204: error in reading (block 1, # blocks 1) of control file
ORA-00202: control file: '+DATA/gzpb/controlfile/current.425.831638825'
ORA-15078: ASM diskgroup was forcibly dismounted

asm 磁盘组被dismount了，看看asm的日志

Cyrill

xifenfei 发表于 2014-3-31 19:11
ORA-00204: error in reading (block 1, # blocks 1) of control file
ORA-00202: control file: '+DATA/gz ...

Mon Mar 31 15:34:10 2014
SQL> ALTER DISKGROUP OCR DISMOUNT  /* asm agent *//* {1:49542:268} */
Mon Mar 31 15:34:10 2014
SQL> ALTER DISKGROUP DATA DISMOUNT  /* asm agent *//* {1:49542:268} */
Mon Mar 31 15:34:20 2014
GMON querying group 3 at 12 for pid 18, osid 5790
Mon Mar 31 15:34:20 2014
NOTE: Instance updated compatible.asm to 11.2.0.0.0 for grp 3
Mon Mar 31 15:34:20 2014
ORA-15032: not all alterations performed
ORA-15027: active use of diskgroup "OCR" precludes its dismount
ERROR: ALTER DISKGROUP OCR DISMOUNT  /* asm agent *//* {1:49542:268} */
Mon Mar 31 15:34:20 2014
NOTE: cache dismounting (clean) group 2/0xB458591F (DATA)
SQL> ALTER DISKGROUP OCR DISMOUNT  /* asm agent *//* {1:49542:268} */
Mon Mar 31 15:34:20 2014
NOTE: LGWR doing clean dismount of group 2 (DATA)
NOTE: LGWR closing thread 1 of diskgroup 2 (DATA) at ABA 65.9760
NOTE: LGWR released thread recovery enqueue
Mon Mar 31 15:34:20 2014
kjbdomdet send to inst 2
detach from dom 2, sending detach message to inst 2
freeing rdom 2
Mon Mar 31 15:34:20 2014
NOTE: detached from domain 2
NOTE: cache dismounted group 2/0xB458591F (DATA)
GMON dismounting group 2 at 13 for pid 30, osid 6017
NOTE: Disk  in mode 0x8 marked for de-assignment
NOTE: Disk  in mode 0x8 marked for de-assignment
SUCCESS: diskgroup DATA was dismounted
NOTE: cache deleting context for group DATA 2/0xb458591f
SUCCESS: ALTER DISKGROUP DATA DISMOUNT  /* asm agent *//* {1:49542:268} */
Mon Mar 31 15:34:30 2014
GMON querying group 3 at 14 for pid 18, osid 5790
Mon Mar 31 15:34:30 2014
NOTE: Instance updated compatible.asm to 11.2.0.0.0 for grp 3
Mon Mar 31 15:34:30 2014
ORA-15032: not all alterations performed
ORA-15027: active use of diskgroup "OCR" precludes its dismount
ERROR: ALTER DISKGROUP OCR DISMOUNT  /* asm agent *//* {1:49542:268} */
Mon Mar 31 15:34:30 2014
SQL> ALTER DISKGROUP OCR DISMOUNT  /* asm agent *//* {1:49542:268} */
Mon Mar 31 15:34:40 2014
GMON querying group 3 at 15 for pid 18, osid 5790
Mon Mar 31 15:34:40 2014
NOTE: Instance updated compatible.asm to 11.2.0.0.0 for grp 3
Mon Mar 31 15:34:40 2014
ORA-15032: not all alterations performed
ORA-15027: active use of diskgroup "OCR" precludes its dismount
ERROR: ALTER DISKGROUP OCR DISMOUNT  /* asm agent *//* {1:49542:268} */
Mon Mar 31 15:34:40 2014
SQL> ALTER DISKGROUP OCR DISMOUNT  /* asm agent *//* {1:49542:268} */
Mon Mar 31 15:34:50 2014
GMON querying group 3 at 16 for pid 18, osid 5790
Mon Mar 31 15:34:50 2014
NOTE: Instance updated compatible.asm to 11.2.0.0.0 for grp 3
Mon Mar 31 15:34:50 2014
ORA-15032: not all alterations performed
ORA-15027: active use of diskgroup "OCR" precludes its dismount
ERROR: ALTER DISKGROUP OCR DISMOUNT  /* asm agent *//* {1:49542:268} */
Mon Mar 31 15:34:50 2014
SQL> ALTER DISKGROUP OCR DISMOUNT  /* asm agent *//* {1:49542:268} */
Mon Mar 31 15:35:00 2014
GMON querying group 3 at 17 for pid 18, osid 5790
Mon Mar 31 15:35:00 2014
NOTE: Instance updated compatible.asm to 11.2.0.0.0 for grp 3
Mon Mar 31 15:35:00 2014
ORA-15032: not all alterations performed
ORA-15027: active use of diskgroup "OCR" precludes its dismount
ERROR: ALTER DISKGROUP OCR DISMOUNT  /* asm agent *//* {1:49542:268} */
Mon Mar 31 15:35:01 2014
NOTE: client exited [5828]
Mon Mar 31 15:35:02 2014
Shutting down instance (abort)
License high water mark = 9
USER (ospid: 5823): terminating the instance
Instance terminated by USER, pid = 5823
Mon Mar 31 15:35:04 2014
Instance shutdown complete
Mon Mar 31 15:37:56 2014
* instance_number obtained from CSS = 1, checking for the existence of node 0...
* node 0 does not exist. instance_number = 1
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Private Interface 'eth1:1' configured from GPnP for use as a private interconnect.
  [name='eth1:1', type=1, ip=169.254.118.221, mac=00-50-56-9f-42-24, net=169.254.0.0/17, mask=255.255.128.0, use=haip:cluster_interconnect/62]
Private Interface 'eth2:1' configured from GPnP for use as a private interconnect.
  [name='eth2:1', type=1, ip=169.254.169.59, mac=00-50-56-9f-42-25, net=169.254.128.0/17, mask=255.255.128.0, use=haip:cluster_interconnect/62]
Public Interface 'eth0' configured from GPnP for use as a public interface.
  [name='eth0', type=1, ip=192.168.46.47, mac=00-50-56-9f-42-23, net=192.168.46.0/24, mask=255.255.255.0, use=public/1]
Picked latch-free SCN scheme 3
Using LOG_ARCHIVE_DEST_1 parameter default value as /u01/app/11.2/grid/dbs/arch
Autotune of undo retention is turned on.
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options.
Using parameter settings in server-side spfile +OCR/jyzx/asmparameterfile/registry.253.792846555
System parameters with non-default values:
  large_pool_size          = 12M
  instance_type            = "asm"
  remote_login_passwordfile= "EXCLUSIVE"
  asm_diskgroups           = "ARCH"
  asm_diskgroups           = "DATA"
  asm_power_limit          = 1
  diagnostic_dest          = "/u01/app/grid"
Cluster communication is configured to use the following interface(s) for this instance
  169.254.118.221
  169.254.169.59
cluster interconnect IPC version:Oracle UDP/IP (generic)
IPC Vendor 1 proto 2
Mon Mar 31 15:37:58 2014
PMON started with pid=2, OS id=5722
Mon Mar 31 15:37:58 2014
PSP0 started with pid=3, OS id=5726
Mon Mar 31 15:37:59 2014
VKTM started with pid=4, OS id=5730
VKTM running at (100ms) precision
Mon Mar 31 15:37:59 2014
GEN0 started with pid=5, OS id=5736
Mon Mar 31 15:37:59 2014
DIAG started with pid=6, OS id=5740
Mon Mar 31 15:37:59 2014
PING started with pid=7, OS id=5744
Mon Mar 31 15:37:59 2014
DIA0 started with pid=8, OS id=5748
Mon Mar 31 15:37:59 2014
LMON started with pid=9, OS id=5752
Mon Mar 31 15:38:00 2014
LMD0 started with pid=10, OS id=5756
Mon Mar 31 15:38:00 2014
LMS0 started with pid=11, OS id=5760
Mon Mar 31 15:38:00 2014
LMHB started with pid=12, OS id=5766
Mon Mar 31 15:38:00 2014
MMAN started with pid=13, OS id=5770
Mon Mar 31 15:38:00 2014
DBW0 started with pid=14, OS id=5774
* Load Monitor used for high load check
* New Low - High Load Threshold Range = [7680 - 10240]
Mon Mar 31 15:38:00 2014
LGWR started with pid=15, OS id=5778
Mon Mar 31 15:38:00 2014
CKPT started with pid=16, OS id=5782
Mon Mar 31 15:38:00 2014
SMON started with pid=17, OS id=5786
Mon Mar 31 15:38:00 2014
RBAL started with pid=18, OS id=5790
Mon Mar 31 15:38:00 2014
GMON started with pid=19, OS id=5794
Mon Mar 31 15:38:00 2014
MMON started with pid=20, OS id=5798
Mon Mar 31 15:38:00 2014
MMNL started with pid=21, OS id=5802
lmon registered with NM - instance number 1 (internal mem no 0)
Reconfiguration started (old inc 0, new inc 52)
ASM instance

Cyrill

xifenfei 发表于 2014-3-31 19:11
ORA-00204: error in reading (block 1, # blocks 1) of control file
ORA-00202: control file: '+DATA/gz ...

1. Thu Apr 03 09:22:10 2014
   
2. SQL> /* ASMCMD */alter diskgroup /*ASMCMD*/ "DATA" drop file '+data/gzpb/datafile/EPOINTBID_PB2011.408.843840915'
   
3. SUCCESS: /* ASMCMD */alter diskgroup /*ASMCMD*/ "DATA" drop file '+data/gzpb/datafile/EPOINTBID_PB2011.408.843840915'
   
4. SQL> /* ASMCMD */alter diskgroup /*ASMCMD*/ "DATA" drop file '+data/gzpb/datafile/epointbid_pb2011.dbf'
   
5. ORA-15032: not all alterations performed
   
6. ORA-15173: entry 'epointbid_pb2011.dbf' does not exist in directory 'datafile'
   
7. ERROR: /* ASMCMD */alter diskgroup /*ASMCMD*/ "DATA" drop file '+data/gzpb/datafile/epointbid_pb2011.dbf'
   
8. SQL> /* ASMCMD */alter diskgroup /*ASMCMD*/ "DATA" drop file '+data/gzpb/datafile/EPOINTBID_PB2011.396.843836657'
   
9. SUCCESS: /* ASMCMD */alter diskgroup /*ASMCMD*/ "DATA" drop file '+data/gzpb/datafile/EPOINTBID_PB2011.396.843836657'
   
10. SQL> /* ASMCMD */alter diskgroup /*ASMCMD*/ "DATA" drop file '+data/gzpb/datafile/epointbid_pb2011_02.dbf'
    
11. ORA-15032: not all alterations performed
    
12. ORA-15173: entry 'epointbid_pb2011_02.dbf' does not exist in directory 'datafile'
    
13. ERROR: /* ASMCMD */alter diskgroup /*ASMCMD*/ "DATA" drop file '+data/gzpb/datafile/epointbid_pb2011_02.dbf'
    
14. SQL> /* ASMCMD */alter diskgroup /*ASMCMD*/ "DATA" drop file '+data/gzpb/datafile/EPOINTBID_PB2011_HIS.398.843836711'
    
15. SUCCESS: /* ASMCMD */alter diskgroup /*ASMCMD*/ "DATA" drop file '+data/gzpb/datafile/EPOINTBID_PB2011_HIS.398.843836711'
    
16. SQL> /* ASMCMD */alter diskgroup /*ASMCMD*/ "DATA" drop file '+data/gzpb/datafile/epointbid_pb2011_his02.dbf'
    
17. ORA-15032: not all alterations performed
    
18. ORA-15173: entry 'epointbid_pb2011_his02.dbf' does not exist in directory 'datafile'
    
19. ERROR: /* ASMCMD */alter diskgroup /*ASMCMD*/ "DATA" drop file '+data/gzpb/datafile/epointbid_pb2011_his02.dbf'
    
20. SQL> /* ASMCMD */alter diskgroup /*ASMCMD*/ "DATA" drop file '+data/gzpb/datafile/F2011.393.843836729'
    
21. SUCCESS: /* ASMCMD */alter diskgroup /*ASMCMD*/ "DATA" drop file '+data/gzpb/datafile/F2011.393.843836729'
    
22. SQL> /* ASMCMD */alter diskgroup /*ASMCMD*/ "DATA" drop file '+data/gzpb/datafile/f2011_02.dbf'
    
23. ORA-15032: not all alterations performed
    
24. ORA-15173: entry 'f2011_02.dbf' does not exist in directory 'datafile'
    
25. ERROR: /* ASMCMD */alter diskgroup /*ASMCMD*/ "DATA" drop file '+data/gzpb/datafile/f2011_02.dbf'
    
26. SQL> /* ASMCMD */alter diskgroup /*ASMCMD*/ "DATA" drop file '+data/gzpb/datafile/EPOINTBID_PB2011.403.843836747'
    
27. SUCCESS: /* ASMCMD */alter diskgroup /*ASMCMD*/ "DATA" drop file '+data/gzpb/datafile/EPOINTBID_PB2011.403.843836747'
    
28. SQL> /* ASMCMD */alter diskgroup /*ASMCMD*/ "DATA" drop file '+data/gzpb/datafile/EPOINTBID_ZS.400.843836919'
    
29. SUCCESS: /* ASMCMD */alter diskgroup /*ASMCMD*/ "DATA" drop file '+data/gzpb/datafile/EPOINTBID_ZS.400.843836919'
    
30. SQL> /* ASMCMD */alter diskgroup /*ASMCMD*/ "DATA" drop file '+data/gzpb/datafile/epointbid_zs.dbf'
    
31. ORA-15032: not all alterations performed
    
32. ORA-15173: entry 'epointbid_zs.dbf' does not exist in directory 'datafile'
    
33. ERROR: /* ASMCMD */alter diskgroup /*ASMCMD*/ "DATA" drop file '+data/gzpb/datafile/epointbid_zs.dbf'
    
34. SQL> /* ASMCMD */alter diskgroup /*ASMCMD*/ "DATA" drop file '+data/gzpb/datafile/UNDOTBS1.404.843837309'
    
35. SUCCESS: /* ASMCMD */alter diskgroup /*ASMCMD*/ "DATA" drop file '+data/gzpb/datafile/UNDOTBS1.404.843837309'
    
36. SQL> /* ASMCMD */alter diskgroup /*ASMCMD*/ "DATA" drop file '+data/gzpb/datafile/EPOINTBID_PWQD.397.843837383'
    
37. SUCCESS: /* ASMCMD */alter diskgroup /*ASMCMD*/ "DATA" drop file '+data/gzpb/datafile/EPOINTBID_PWQD.397.843837383'
    
38. SQL> /* ASMCMD */alter diskgroup /*ASMCMD*/ "DATA" drop file '+data/gzpb/datafile/epointbid_pwqd.dbf'
    
39. ORA-15032: not all alterations performed
    
40. ORA-15173: entry 'epointbid_pwqd.dbf' does not exist in directory 'datafile'
    
41. ERROR: /* ASMCMD */alter diskgroup /*ASMCMD*/ "DATA" drop file '+data/gzpb/datafile/epointbid_pwqd.dbf'
    
42. SQL> /* ASMCMD */alter diskgroup /*ASMCMD*/ "DATA" drop file '+data/gzpb/datafile/UNDOTBS2.411.843837683'
    
43. SUCCESS: /* ASMCMD */alter diskgroup /*ASMCMD*/ "DATA" drop file '+data/gzpb/datafile/UNDOTBS2.411.843837683'
    
44. SQL> /* ASMCMD */alter diskgroup /*ASMCMD*/ "DATA" drop file '+data/gzpb/datafile/SYSAUX.399.843837765'
    
45. SUCCESS: /* ASMCMD */alter diskgroup /*ASMCMD*/ "DATA" drop file '+data/gzpb/datafile/SYSAUX.399.843837765'
    
46. SQL> /* ASMCMD */alter diskgroup /*ASMCMD*/ "DATA" drop file '+data/gzpb/datafile/SYSTEM.390.843837963'
    
47. Thu Apr 03 09:22:20 2014
    
48. SUCCESS: /* ASMCMD */alter diskgroup /*ASMCMD*/ "DATA" drop file '+data/gzpb/datafile/SYSTEM.390.843837963'
    
49. SQL> /* ASMCMD */alter diskgroup /*ASMCMD*/ "DATA" drop file '+data/gzpb/datafile/EPOINTBID_BZB5.520.843838629'
    
50. SUCCESS: /* ASMCMD */alter diskgroup /*ASMCMD*/ "DATA" drop file '+data/gzpb/datafile/EPOINTBID_BZB5.520.843838629'
    
51. SQL> /* ASMCMD */alter diskgroup /*ASMCMD*/ "DATA" drop file '+data/gzpb/datafile/epointbid_bzb5.dbf'
    
52. ORA-15032: not all alterations performed
    
53. ORA-15173: entry 'epointbid_bzb5.dbf' does not exist in directory 'datafile'
    
54. ERROR: /* ASMCMD */alter diskgroup /*ASMCMD*/ "DATA" drop file '+data/gzpb/datafile/epointbid_bzb5.dbf'
    
55. SQL> /* ASMCMD */alter diskgroup /*ASMCMD*/ "DATA" drop file '+data/gzpb/datafile/EPOINTBID_PB2011_HIS_2.409.843839033'
    
56. SUCCESS: /* ASMCMD */alter diskgroup /*ASMCMD*/ "DATA" drop file '+data/gzpb/datafile/EPOINTBID_PB2011_HIS_2.409.843839033'
    
57. SQL> /* ASMCMD */alter diskgroup /*ASMCMD*/ "DATA" drop file '+data/gzpb/datafile/epointbid_pb2011_his_2_02.dbf'
    
58. ORA-15032: not all alterations performed
    
59. ORA-15173: entry 'epointbid_pb2011_his_2_02.dbf' does not exist in directory 'datafile'
    
60. ERROR: /* ASMCMD */alter diskgroup /*ASMCMD*/ "DATA" drop file '+data/gzpb/datafile/epointbid_pb2011_his_2_02.dbf'
    
61. SQL> /* ASMCMD */alter diskgroup /*ASMCMD*/ "DATA" drop file '+data/gzpb/datafile/EPOINTBID_PWQD.384.843839089'
    
62. SUCCESS: /* ASMCMD */alter diskgroup /*ASMCMD*/ "DATA" drop file '+data/gzpb/datafile/EPOINTBID_PWQD.384.843839089'
    
63. SQL> /* ASMCMD */alter diskgroup /*ASMCMD*/ "DATA" drop file '+data/gzpb/datafile/epointbid_pwqd02.dbf'
    
64. ORA-15032: not all alterations performed
    
65. ORA-15173: entry 'epointbid_pwqd02.dbf' does not exist in directory 'datafile'
    
66. ERROR: /* ASMCMD */alter diskgroup /*ASMCMD*/ "DATA" drop file '+data/gzpb/datafile/epointbid_pwqd02.dbf'
    
67. SQL> /* ASMCMD */alter diskgroup /*ASMCMD*/ "DATA" drop file '+data/gzpb/datafile/USERS.406.843839321'
    
68. SUCCESS: /* ASMCMD */alter diskgroup /*ASMCMD*/ "DATA" drop file '+data/gzpb/datafile/USERS.406.843839321'
    
69. Thu Apr 03 09:24:01 2014
    
70. NOTE: client gzpb1:gzpb registered, osid 12035, mbr 0x1
    

复制代码

xifenfei

建议你直接在asmcmd里面使用rm命令删除试试看