Rman restore 报错 ORA-19502 ORA-15081
飞总，我在rman下restore后，出现以下问题: channel ORA_DISK_1: starting datafile backup set restorechannel 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
是什么问题 ，如何解决？
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磁盘组dismounted，看下asm的日志 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的日志 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: Diskin mode 0x8 marked for de-assignment
NOTE: Diskin 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
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.
Private Interface 'eth2:1' configured from GPnP for use as a private interconnect.
Public Interface 'eth0' configured from GPnP for use as a public interface.
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 =
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
xifenfei 发表于 2014-3-31 19:11
ORA-00204: error in reading (block 1, # blocks 1) of control file
ORA-00202: control file: '+DATA/gz ...
Thu Apr 03 09:22:10 2014
SQL> /* ASMCMD */alter diskgroup /*ASMCMD*/ "DATA" drop file '+data/gzpb/datafile/EPOINTBID_PB2011.408.843840915'
SUCCESS: /* ASMCMD */alter diskgroup /*ASMCMD*/ "DATA" drop file '+data/gzpb/datafile/EPOINTBID_PB2011.408.843840915'
SQL> /* ASMCMD */alter diskgroup /*ASMCMD*/ "DATA" drop file '+data/gzpb/datafile/epointbid_pb2011.dbf'
ORA-15032: not all alterations performed
ORA-15173: entry 'epointbid_pb2011.dbf' does not exist in directory 'datafile'
ERROR: /* ASMCMD */alter diskgroup /*ASMCMD*/ "DATA" drop file '+data/gzpb/datafile/epointbid_pb2011.dbf'
SQL> /* ASMCMD */alter diskgroup /*ASMCMD*/ "DATA" drop file '+data/gzpb/datafile/EPOINTBID_PB2011.396.843836657'
SUCCESS: /* ASMCMD */alter diskgroup /*ASMCMD*/ "DATA" drop file '+data/gzpb/datafile/EPOINTBID_PB2011.396.843836657'
SQL> /* ASMCMD */alter diskgroup /*ASMCMD*/ "DATA" drop file '+data/gzpb/datafile/epointbid_pb2011_02.dbf'
ORA-15032: not all alterations performed
ORA-15173: entry 'epointbid_pb2011_02.dbf' does not exist in directory 'datafile'
ERROR: /* ASMCMD */alter diskgroup /*ASMCMD*/ "DATA" drop file '+data/gzpb/datafile/epointbid_pb2011_02.dbf'
SQL> /* ASMCMD */alter diskgroup /*ASMCMD*/ "DATA" drop file '+data/gzpb/datafile/EPOINTBID_PB2011_HIS.398.843836711'
SUCCESS: /* ASMCMD */alter diskgroup /*ASMCMD*/ "DATA" drop file '+data/gzpb/datafile/EPOINTBID_PB2011_HIS.398.843836711'
SQL> /* ASMCMD */alter diskgroup /*ASMCMD*/ "DATA" drop file '+data/gzpb/datafile/epointbid_pb2011_his02.dbf'
ORA-15032: not all alterations performed
ORA-15173: entry 'epointbid_pb2011_his02.dbf' does not exist in directory 'datafile'
ERROR: /* ASMCMD */alter diskgroup /*ASMCMD*/ "DATA" drop file '+data/gzpb/datafile/epointbid_pb2011_his02.dbf'
SQL> /* ASMCMD */alter diskgroup /*ASMCMD*/ "DATA" drop file '+data/gzpb/datafile/F2011.393.843836729'
SUCCESS: /* ASMCMD */alter diskgroup /*ASMCMD*/ "DATA" drop file '+data/gzpb/datafile/F2011.393.843836729'
SQL> /* ASMCMD */alter diskgroup /*ASMCMD*/ "DATA" drop file '+data/gzpb/datafile/f2011_02.dbf'
ORA-15032: not all alterations performed
ORA-15173: entry 'f2011_02.dbf' does not exist in directory 'datafile'
ERROR: /* ASMCMD */alter diskgroup /*ASMCMD*/ "DATA" drop file '+data/gzpb/datafile/f2011_02.dbf'
SQL> /* ASMCMD */alter diskgroup /*ASMCMD*/ "DATA" drop file '+data/gzpb/datafile/EPOINTBID_PB2011.403.843836747'
SUCCESS: /* ASMCMD */alter diskgroup /*ASMCMD*/ "DATA" drop file '+data/gzpb/datafile/EPOINTBID_PB2011.403.843836747'
SQL> /* ASMCMD */alter diskgroup /*ASMCMD*/ "DATA" drop file '+data/gzpb/datafile/EPOINTBID_ZS.400.843836919'
SUCCESS: /* ASMCMD */alter diskgroup /*ASMCMD*/ "DATA" drop file '+data/gzpb/datafile/EPOINTBID_ZS.400.843836919'
SQL> /* ASMCMD */alter diskgroup /*ASMCMD*/ "DATA" drop file '+data/gzpb/datafile/epointbid_zs.dbf'
ORA-15032: not all alterations performed
ORA-15173: entry 'epointbid_zs.dbf' does not exist in directory 'datafile'
ERROR: /* ASMCMD */alter diskgroup /*ASMCMD*/ "DATA" drop file '+data/gzpb/datafile/epointbid_zs.dbf'
SQL> /* ASMCMD */alter diskgroup /*ASMCMD*/ "DATA" drop file '+data/gzpb/datafile/UNDOTBS1.404.843837309'
SUCCESS: /* ASMCMD */alter diskgroup /*ASMCMD*/ "DATA" drop file '+data/gzpb/datafile/UNDOTBS1.404.843837309'
SQL> /* ASMCMD */alter diskgroup /*ASMCMD*/ "DATA" drop file '+data/gzpb/datafile/EPOINTBID_PWQD.397.843837383'
SUCCESS: /* ASMCMD */alter diskgroup /*ASMCMD*/ "DATA" drop file '+data/gzpb/datafile/EPOINTBID_PWQD.397.843837383'
SQL> /* ASMCMD */alter diskgroup /*ASMCMD*/ "DATA" drop file '+data/gzpb/datafile/epointbid_pwqd.dbf'
ORA-15032: not all alterations performed
ORA-15173: entry 'epointbid_pwqd.dbf' does not exist in directory 'datafile'
ERROR: /* ASMCMD */alter diskgroup /*ASMCMD*/ "DATA" drop file '+data/gzpb/datafile/epointbid_pwqd.dbf'
SQL> /* ASMCMD */alter diskgroup /*ASMCMD*/ "DATA" drop file '+data/gzpb/datafile/UNDOTBS2.411.843837683'
SUCCESS: /* ASMCMD */alter diskgroup /*ASMCMD*/ "DATA" drop file '+data/gzpb/datafile/UNDOTBS2.411.843837683'
SQL> /* ASMCMD */alter diskgroup /*ASMCMD*/ "DATA" drop file '+data/gzpb/datafile/SYSAUX.399.843837765'
SUCCESS: /* ASMCMD */alter diskgroup /*ASMCMD*/ "DATA" drop file '+data/gzpb/datafile/SYSAUX.399.843837765'
SQL> /* ASMCMD */alter diskgroup /*ASMCMD*/ "DATA" drop file '+data/gzpb/datafile/SYSTEM.390.843837963'
Thu Apr 03 09:22:20 2014
SUCCESS: /* ASMCMD */alter diskgroup /*ASMCMD*/ "DATA" drop file '+data/gzpb/datafile/SYSTEM.390.843837963'
SQL> /* ASMCMD */alter diskgroup /*ASMCMD*/ "DATA" drop file '+data/gzpb/datafile/EPOINTBID_BZB5.520.843838629'
SUCCESS: /* ASMCMD */alter diskgroup /*ASMCMD*/ "DATA" drop file '+data/gzpb/datafile/EPOINTBID_BZB5.520.843838629'
SQL> /* ASMCMD */alter diskgroup /*ASMCMD*/ "DATA" drop file '+data/gzpb/datafile/epointbid_bzb5.dbf'
ORA-15032: not all alterations performed
ORA-15173: entry 'epointbid_bzb5.dbf' does not exist in directory 'datafile'
ERROR: /* ASMCMD */alter diskgroup /*ASMCMD*/ "DATA" drop file '+data/gzpb/datafile/epointbid_bzb5.dbf'
SQL> /* ASMCMD */alter diskgroup /*ASMCMD*/ "DATA" drop file '+data/gzpb/datafile/EPOINTBID_PB2011_HIS_2.409.843839033'
SUCCESS: /* ASMCMD */alter diskgroup /*ASMCMD*/ "DATA" drop file '+data/gzpb/datafile/EPOINTBID_PB2011_HIS_2.409.843839033'
SQL> /* ASMCMD */alter diskgroup /*ASMCMD*/ "DATA" drop file '+data/gzpb/datafile/epointbid_pb2011_his_2_02.dbf'
ORA-15032: not all alterations performed
ORA-15173: entry 'epointbid_pb2011_his_2_02.dbf' does not exist in directory 'datafile'
ERROR: /* ASMCMD */alter diskgroup /*ASMCMD*/ "DATA" drop file '+data/gzpb/datafile/epointbid_pb2011_his_2_02.dbf'
SQL> /* ASMCMD */alter diskgroup /*ASMCMD*/ "DATA" drop file '+data/gzpb/datafile/EPOINTBID_PWQD.384.843839089'
SUCCESS: /* ASMCMD */alter diskgroup /*ASMCMD*/ "DATA" drop file '+data/gzpb/datafile/EPOINTBID_PWQD.384.843839089'
SQL> /* ASMCMD */alter diskgroup /*ASMCMD*/ "DATA" drop file '+data/gzpb/datafile/epointbid_pwqd02.dbf'
ORA-15032: not all alterations performed
ORA-15173: entry 'epointbid_pwqd02.dbf' does not exist in directory 'datafile'
ERROR: /* ASMCMD */alter diskgroup /*ASMCMD*/ "DATA" drop file '+data/gzpb/datafile/epointbid_pwqd02.dbf'
SQL> /* ASMCMD */alter diskgroup /*ASMCMD*/ "DATA" drop file '+data/gzpb/datafile/USERS.406.843839321'
SUCCESS: /* ASMCMD */alter diskgroup /*ASMCMD*/ "DATA" drop file '+data/gzpb/datafile/USERS.406.843839321'
Thu Apr 03 09:24:01 2014
NOTE: client gzpb1:gzpb registered, osid 12035, mbr 0x1
建议你直接在asmcmd里面使用rm命令删除试试看
页:
[1]