hai all ,
i faced issue
channel CH13: starting datafile backup set restore
channel CH13: specifying datafile(s) to restore from backup set
channel CH13: restoring datafile 00179 to /oradata22/PROD/data/a_txn_data68.dbf
channel CH13: reading from backup piece PRFND_DB_bk_11110_1_863158629
channel CH13: ORA-19870: error while restoring backup piece PRFND_DB_bk_11110_1_863158629
ORA-19504: failed to create file "/oradata22/PROD/data/a_txn_data68.dbf"
ORA-27040: file create error, unable to create file
SVR4 Error: 2: No such file or directory
Additional information: 1
channel CH13: starting datafile backup set restore
channel CH13: specifying datafile(s) to restore from backup set
channel CH13: restoring datafile 00102 to /oracle/PROD/db/apps_st/data/a_txn_data30.dbf
channel CH13: restoring datafile 00145 to /oradata26/PROD/index/a_txn_ind31.dbf
channel CH13: reading from backup piece PRFND_DB_bk_11114_1_863168494
channel CH13: ORA-19870: error while restoring backup piece PRFND_DB_bk_11114_1_863168494
ORA-19504: failed to create file "/oradata26/PROD/index/a_txn_ind31.dbf"
ORA-27040: file create error, unable to create file
SVR4 Error: 2: No such file or directory
Additional information: 1
but another datafile success to restore
run {
ALLOCATE CHANNEL CH11 TYPE 'SBT_TAPE';
ALLOCATE CHANNEL CH12 TYPE 'SBT_TAPE';
ALLOCATE CHANNEL CH13 TYPE 'SBT_TAPE';
ALLOCATE CHANNEL CH14 TYPE 'SBT_TAPE';
SEND 'NB_ORA_SERV=smjkt-bkup01, NB_ORA_CLIENT=SMJKT-PRFNFP01';
SET UNTIL TIME "TO_DATE('2014-18-11:05:45:00','yyyy-dd-mm:hh24:mi:ss')";
SET NEWNAME FOR DATAFILE 1 TO '/oracle/PROD/db/apps_st/data/system01.dbf';
SET NEWNAME FOR DATAFILE 2 TO '/oracle/PROD/db/apps_st/data/system02.dbf';
SET NEWNAME FOR DATAFILE 3 TO '/oracle/PROD/db/apps_st/data/system03.dbf';
SET NEWNAME FOR DATAFILE 4 TO '/oracle/PROD/db/apps_st/data/system04.dbf';
SET NEWNAME FOR DATAFILE 5 TO '/oracle/PROD/db/apps_st/data/system05.dbf';
SET NEWNAME FOR DATAFILE 6 TO '/oracle/PROD/db/apps_st/data/system06.dbf';
SET NEWNAME FOR DATAFILE 7 TO '/oracle/PROD/db/apps_st/data/system07.dbf';
SET NEWNAME FOR DATAFILE 8 TO '/oracle/PROD/db/apps_st/data/system08.dbf';
SET NEWNAME FOR DATAFILE 9 TO '/oracle/PROD/db/apps_st/data/system09.dbf';
SET NEWNAME FOR DATAFILE 10 TO '/oracle/PROD/db/apps_st/data/system10.dbf';
SET NEWNAME FOR DATAFILE 11 TO '/oracle/PROD/db/apps_st/data/system11.dbf';
SET NEWNAME FOR DATAFILE 12 TO '/oradb_undo/PROD/undo/UNDOTS1_02.dbf';
SET NEWNAME FOR DATAFILE 13 TO '/oracle/PROD/db/apps_st/data/a_archive01.dbf';
SET NEWNAME FOR DATAFILE 14 TO '/oracle/PROD/db/apps_st/data/a_int01.dbf';
SET NEWNAME FOR DATAFILE 15 TO '/oracle/PROD/db/apps_st/data/a_media01.dbf';
SET NEWNAME FOR DATAFILE 16 TO '/oracle/PROD/db/apps_st/data/a_nolog01.dbf';
SET NEWNAME FOR DATAFILE 17 TO '/oracle/PROD/db/apps_st/data/a_queue01.dbf';
SET NEWNAME FOR DATAFILE 18 TO '/oracle/PROD/db/apps_st/data/a_queue02.dbf';
SET NEWNAME FOR DATAFILE 19 TO '/oracle/PROD/db/apps_st/data/a_ref01.dbf';
SET NEWNAME FOR DATAFILE 20 TO '/oracle/PROD/db/apps_st/data/a_ref02.dbf';
SET NEWNAME FOR DATAFILE 21 TO '/oracle/PROD/db/apps_st/data/a_summ01.dbf';
SET NEWNAME FOR DATAFILE 22 TO '/oracle/PROD/db/apps_st/data/a_txn_data01.dbf';
SET NEWNAME FOR DATAFILE 23 TO '/oracle/PROD/db/apps_st/data/a_txn_data02.dbf';
SET NEWNAME FOR DATAFILE 24 TO '/oracle/PROD/db/apps_st/data/a_txn_data03.dbf';
SET NEWNAME FOR DATAFILE 25 TO '/oracle/PROD/db/apps_st/data/a_txn_ind01.dbf';
restore database ;
switch datafile all;
release channel CH11;
release channel CH12;
release channel CH13;
release channel CH14;
}
this is example my rman query.
any suggestion ?
Imron S