channel ORA_AUX_DISK_1: restoring datafile 00014 to /u05/PRDSUP/db/apps_st/data/a_txn_data04.dbf
channel ORA_AUX_DISK_1: restoring datafile 00015 to /u06/PRDSUP/db/apps_st/data/a_txn_ind06.dbf
channel ORA_AUX_DISK_1: restoring datafile 00018 to /u05/PRDSUP/db/apps_st/data/sysaux02.dbf
channel ORA_AUX_DISK_1: restoring datafile 00025 to /u07/PRDSUP/db/apps_st/data/vtxlink01.dbf
channel ORA_AUX_DISK_1: restoring datafile 00046 to /u08/PRDSUP/db/apps_st/data/sysaux09.dbf
channel ORA_AUX_DISK_1: reading from backup piece /stage_local/hotbackup/PROD/90rlc318_1_1
channel ORA_AUX_DISK_5: piece handle=/stage_local/hotbackup/PROD/93rlc318_1_1 tag=PRODBKP2DISK
channel ORA_AUX_DISK_5: restored backup piece 1
channel ORA_AUX_DISK_5: restore complete, elapsed time: 01:45:30
channel ORA_AUX_DISK_5: starting datafile backup set restore
channel ORA_AUX_DISK_5: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_5: restoring datafile 00026 to /u07/PRDSUP/db/apps_st/data/vertex01.dbf
channel ORA_AUX_DISK_5: restoring datafile 00042 to /u05/PRDSUP/db/apps_st/data/a_txn_data09.dbf
channel ORA_AUX_DISK_5: restoring datafile 00056 to /u08/PRDSUP/db/apps_st/data/a_txn_ind09.dbf
channel ORA_AUX_DISK_5: restoring datafile 00066 to /u08/PRDSUP/db/apps_st/data/undo03.dbf
channel ORA_AUX_DISK_5: restoring datafile 00396 to /u05/PRDSUP/db/apps_st/data/a_summ01.dbf
channel ORA_AUX_DISK_5: reading from backup piece /stage_local/hotbackup/PROD/98rlcb9p_1_1
channel ORA_AUX_DISK_4: piece handle=/stage_local/hotbackup/PROD/9crlcgkr_1_1 tag=PRODBKP2DISK
channel ORA_AUX_DISK_4: restored backup piece 1
channel ORA_AUX_DISK_4: restore complete, elapsed time: 00:24:17
channel ORA_AUX_DISK_4: starting datafile backup set restore
channel ORA_AUX_DISK_4: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_4: restoring datafile 00008 to /u05/PRDSUP/db/apps_st/data/a_queue02.dbf
channel ORA_AUX_DISK_4: restoring datafile 00049 to /u08/PRDSUP/db/apps_st/data/a_archive02.dbf
channel ORA_AUX_DISK_4: restoring datafile 00055 to /u08/PRDSUP/db/apps_st/data/sysaux10.dbf
channel ORA_AUX_DISK_4: restoring datafile 00399 to /u05/PRDSUP/db/apps_st/data/a_queue01.dbf
channel ORA_AUX_DISK_4: reading from backup piece /stage_local/hotbackup/PROD/99rlcbob_1_1
channel ORA_AUX_DISK_4: piece handle=/stage_local/hotbackup/PROD/99rlcbob_1_1 tag=PRODBKP2DISK
channel ORA_AUX_DISK_4: restored backup piece 1
channel ORA_AUX_DISK_4: restore complete, elapsed time: 00:48:06
channel ORA_AUX_DISK_5: piece handle=/stage_local/hotbackup/PROD/98rlcb9p_1_1 tag=PRODBKP2DISK
channel ORA_AUX_DISK_5: restored backup piece 1
channel ORA_AUX_DISK_5: restore complete, elapsed time: 01:07:52
channel ORA_AUX_DISK_2: piece handle=/stage_local/hotbackup/PROD/96rlcas1_1_1 tag=PRODBKP2DISK
channel ORA_AUX_DISK_2: restored backup piece 1
channel ORA_AUX_DISK_2: restore complete, elapsed time: 01:41:55
channel ORA_AUX_DISK_3: piece handle=/stage_local/hotbackup/PROD/91rlc318_1_1 tag=PRODBKP2DISK
channel ORA_AUX_DISK_3: restored backup piece 1
channel ORA_AUX_DISK_3: restore complete, elapsed time: 01:44:30
channel ORA_AUX_DISK_1: ORA-19870: error while restoring backup piece /stage_local/hotbackup/PROD/90rlc318_1_1
ORA-19502: write error on file "/u08/PRDSUP/db/apps_st/data/sysaux09.dbf", block number 3770944 (block size=8192)
ORA-27072: File I/O error
Additional information: 4
Additional information: 3770944
Additional information: 24576
failover to previous backup
Oracle instance started
Total System Global Area 8551575552 bytes
Fixed Size 2245480 bytes
Variable Size 4294970520 bytes
Database Buffers 4227858432 bytes
Redo Buffers 26501120 bytes
Hi ,
My RMAN Restore failed.Can you please suggest what to look and how proceed for this error.
contents of Memory Script:
{
sql clone "alter system set db_name =
''PRDSUP'' comment=
''Reset to original value by RMAN'' scope=spfile";
sql clone "alter system reset db_unique_name scope=spfile";
shutdown clone immediate;
}
executing Memory Script
Errors in memory script
RMAN-03015: error occurred in stored script Memory Script
RMAN-06136: ORACLE error from auxiliary database: ORA-01507: database not mounted
ORA-06512: at "SYS.X$DBMS_RCVMAN", line 13466
ORA-06512: at line 1
RMAN-05556: not all datafiles have backups that can be recovered to SCN 8315816613659
RMAN-03015: error occurred in stored script Memory Script
RMAN-06026: some targets not found - aborting restore
RMAN-06023: no backup or copy of datafile 25 found to restore
RMAN-06023: no backup or copy of datafile 18 found to restore
RMAN-06023: no backup or copy of datafile 15 found to restore
RMAN-06023: no backup or copy of datafile 14 found to restore
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 11/21/2016 01:05:45
RMAN-05501: aborting duplication of target database
Recovery Manager complete.