Rman backup and restore to different machine reported ORA-01110 ORA-01180 error
[oracle@server1 ORACLE] $rman target /
Recovery Manager: Release 10.2.0.5.0-Production on Thu Jul 31 13:51:40 2014
Copyright (c) 1982, 2007, Oracle. All rights reserved.
Connected to target database (not started)
RMAN > set dbid 1619708557
Executing command: SET DBID
RMAN > startup nomount
Oracle instance started
Total System Global Area 8388608000 bytes
Fixed Size 2109640 bytes
Variable Size 5117054776 bytes
Database Buffers 3221225472 bytes
Redo Buffers 48218112 bytes
RMAN > restore controlfile from'/ home/oracle/orabase/flash_recovery_area/ORACLE/autobackup/2014_07_31/o1_mf_s_854376584_9xmsr8fm_.bkp'
Starting restore at 31-JUL-14
Using target database control file instead of recovery catalog
Allocated channel: ORA_DISK_1
Channel ORA_DISK_1: sid=1084 devtype=DISK
Channel ORA_DISK_1: restoring control file
Channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
Output filename=/home/oracle/orabase/oradata/ORACLE/control01.ctl
Output filename=/home/oracle/orabase/oradata/ORACLE/control02.ctl
Output filename=/home/oracle/orabase/oradata/ORACLE/control03.ctl
Finished restore at 31-JUL-14
RMAN > alter database mount
Database mounted
Released channel: ORA_DISK_1
RMAN > restore database
Start restore from 31 to July to 14
Use channel ORA_DISK_1
Create data file fno = 1 name = / home/oracle/orabase/oradata/ORACLE/system01.dbf
MAN-00571: =
RMAN-00569: = ERROR MESSAGE STACK FOLLOWS =
RMAN-00571: =
RMAN-03002: the restore command failed (on 12:06:00 on 07Compact 31Universe 2014)
ORA-01180: unable to create data file 1
ORA-01110: data file 1:'/ home/oracle/orabase/oradata/ORACLE/system01.dbf'
RMAN >
RMAN > crosscheck backupset
Starting implicit crosscheck backup at 31-JUL-14
Allocated channel: ORA_DISK_1
Channel ORA_DISK_1: sid=1084 devtype=DISK
Crosschecked 10 objects
Finished implicit crosscheck backup at 31-JUL-14
Starting implicit crosscheck copy at 31-JUL-14
Using channel ORA_DISK_1
Finished implicit crosscheck copy at 31-JUL-14
Searching for all files in the recovery area
Cataloging files...
Cataloging done
List of Cataloged Files
=
File Name: / home/oracle/orabase/flash_recovery_area/ORACLE/archivelog/2014_07_31/o1_mf_1_116_9xm5yprp_.arc
File Name: / home/oracle/orabase/flash_recovery_area/ORACLE/autobackup/2014_07_31/o1_mf_s_854331141_9xlfd5gc_.bkp
Using channel ORA_DISK_1
Crosschecked backup piece: found to be 'EXPIRED'
Backup piece handle=/home/oracle/orabackup/rmandata/data/2014_07_29/fulldb_nvpeiou9_1_1.bak recid=3836 stamp=854156234
Crosschecked backup piece: found to be 'EXPIRED'
Backup piece handle=/home/oracle/orabackup/rmandata/data/2014_07_29/arch_o0peir6m_1_1.bak recid=3837 stamp=854158551
Crosschecked backup piece: found to be 'EXPIRED'
Backup piece handle=/home/oracle/orabackup/rmandata/data/2014_07_30/arch_o2peld7e_1_1.bak recid=3839 stamp=854242543
Crosschecked backup piece: found to be 'EXPIRED'
Backup piece handle=/home/oracle/orabackup/rmandata/data/2014_07_30/fulldb_o3peldbg_1_1.bak recid=3840 stamp=854242673
Crosschecked backup piece: found to be 'EXPIRED'
Backup piece handle=/home/oracle/orabackup/rmandata/data/2014_07_30/arch_o4pelfhd_1_1.bak recid=3841 stamp=854244910
Crosschecked backup piece: found to be 'EXPIRED'
Backup piece handle=/home/oracle/orabackup/rmandata/data/2014_07_31/arch_o6peo1hh_1_1.bak recid=3843 stamp=854328882
Crosschecked backup piece: found to be 'EXPIRED'
Backup piece handle=/home/oracle/orabackup/rmandata/data/2014_07_31/fulldb_o7peo1la_1_1.bak recid=3844 stamp=854329003
Crosschecked backup piece: found to be 'EXPIRED'
Backup piece handle=/home/oracle/orabackup/rmandata/data/2014_07_31/arch_o8peo3o2_1_1.bak recid=3845 stamp=854331139
Crosschecked backup piece: found to be 'AVAILABLE'
Backup piece handle=/home/oracle/orabase/flash_recovery_area/ORACLE/autobackup/2014_07_31/o1_mf_s_854331141_9xlfd5gc_.bkp recid=3846
Stamp=854373190
Crosschecked 9 objects
Unable to restore the database due to the expiration of the backup set, re-register the backup slice.
RMAN > catalog backuppiece'/ home/oracle/orabackup/rmandata/data/2014_07_31/arch_o6peo1hh_1_1.bak'
Cataloged backuppiece
Backup piece handle=/home/oracle/orabackup/rmandata/data/2014_07_31/arch_o6peo1hh_1_1.bak recid=3847 stamp=854373756
RMAN > catalog backuppiece'/ home/oracle/orabackup/rmandata/data/2014_07_31/fulldb_o7peo1la_1_1.bak'
Cataloged backuppiece
Backup piece handle=/home/oracle/orabackup/rmandata/data/2014_07_31/fulldb_o7peo1la_1_1.bak recid=3848 stamp=854373783
RMAN > catalog backuppiece'/ home/oracle/orabackup/rmandata/data/2014_07_31/arch_o8peo3o2_1_1.bak'
Cataloged backuppiece
Backup piece handle=/home/oracle/orabackup/rmandata/data/2014_07_31/arch_o8peo3o2_1_1.bak recid=3849 stamp=854373809
Check again after successful registration
RMAN > crosscheck backupset
Allocated channel: ORA_DISK_1
Channel ORA_DISK_1: sid=1087 devtype=DISK
Crosschecked backup piece: found to be 'EXPIRED'
Backup piece handle=/home/oracle/orabackup/rmandata/data/2014_07_29/fulldb_nvpeiou9_1_1.bak recid=3836 stamp=854156234
Crosschecked backup piece: found to be 'EXPIRED'
Backup piece handle=/home/oracle/orabackup/rmandata/data/2014_07_29/arch_o0peir6m_1_1.bak recid=3837 stamp=854158551
Crosschecked backup piece: found to be 'EXPIRED'
Backup piece handle=/home/oracle/orabackup/rmandata/data/2014_07_30/arch_o2peld7e_1_1.bak recid=3839 stamp=854242543
Crosschecked backup piece: found to be 'EXPIRED'
Backup piece handle=/home/oracle/orabackup/rmandata/data/2014_07_30/fulldb_o3peldbg_1_1.bak recid=3840 stamp=854242673
Crosschecked backup piece: found to be 'EXPIRED'
Backup piece handle=/home/oracle/orabackup/rmandata/data/2014_07_30/arch_o4pelfhd_1_1.bak recid=3841 stamp=854244910
Crosschecked backup piece: found to be 'AVAILABLE'
Backup piece handle=/home/oracle/orabackup/rmandata/data/2014_07_31/arch_o6peo1hh_1_1.bak recid=3847 stamp=854373756
Crosschecked backup piece: found to be 'AVAILABLE'
Backup piece handle=/home/oracle/orabackup/rmandata/data/2014_07_31/fulldb_o7peo1la_1_1.bak recid=3848 stamp=854373783
Crosschecked backup piece: found to be 'AVAILABLE'
Backup piece handle=/home/oracle/orabackup/rmandata/data/2014_07_31/arch_o8peo3o2_1_1.bak recid=3849 stamp=854373809
Crosschecked backup piece: found to be 'AVAILABLE'
Backup piece handle=/home/oracle/orabase/flash_recovery_area/ORACLE/autobackup/2014_07_31/o1_mf_s_854331141_9xlfd5gc_.bkp recid=3846
Stamp=854373190
Crosschecked 9 objects
Restore database
RMAN > restore database
Restores the database to the specified sequence.
RMAN > recover database until sequence 13908
After the recovery is complete, start the database.
RMAN > alter database open resetlogs
