Re: RMAN restore

Posted by Roshan on Nov 17, 2016; 4:30pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/RMAN-restore-tp1563p1567.html

I took a fresh backup of the control file. I then restored it on the test instance and started mount. When I ran the restored, it managed to proceed.

I am now getting the error below in alert log file


ORA-01122: database file 4659 failed verification check
ORA-01110: data file 4659: '/ORADATA7/WINSRATDB/TSRATFAILURECDRJUN16_ROD.dbf'
ORA-01565: error in identifying file '/ORADATA7/WINSRATDB/TSRATFAILURECDRJUN16_ROD.dbf'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Thu Nov 17 16:18:08 2016
Errors in file /opt/app/oracle/diag/rdbms/winsdb/WINSDB2/trace/WINSDB2_m002_1569.trc:
ORA-51106: check failed to complete due to an error.  See error below
ORA-48223: Interrupt Requested - Fetch Aborted - Return Code [12751] [HM_INFO]
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-01122: database file 4778 failed verification check
ORA-01110: data file 4778: '/ORADATA8/WINSMEDDB/TSMEDCDR28SEP16.dbf'
ORA-01565: error in identifying file '/ORADATA8/WINSMEDDB/TSMEDCDR28SEP16.dbf'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3

my rman script is :

connect target /

connect auxiliary /
 
       
run {
ALLOCATE  CHANNEL CH1 TYPE 'SBT_TAPE';
ALLOCATE  CHANNEL CH2 TYPE 'SBT_TAPE';
ALLOCATE  CHANNEL CH3 TYPE 'SBT_TAPE';
ALLOCATE  CHANNEL CH4 TYPE 'SBT_TAPE';
ALLOCATE  CHANNEL CH5 TYPE 'SBT_TAPE';
ALLOCATE  CHANNEL CH6 TYPE 'SBT_TAPE';
ALLOCATE  CHANNEL CH7 TYPE 'SBT_TAPE';
 
 
SEND 'NSR_ENV=(NSR_SERVER=rhis-nwdd-1202, NSR_DATA_VOLUME_POOL=004,
          NSR_CLIENT=10.178.1.67)';
SET NEWNAME FOR DATABASE TO '/data/WINSDB/%U';

restore database;
#crosscheck backup;


}

Thanks,
ROshan