ORA-01110 ORA-01180 error reported when rman backup is restored to an exception
[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,200 7, 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-jul14
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-jul14
RMAN> alter database mount;
Database mounted
Released channel: ORA_DISK_1
--------------------------------------------------------------------------------
RMAN: Configure an archive log deletion policy
Basic Oracle tutorial-copying a database through RMAN
Reference for RMAN backup policy formulation
RMAN backup learning notes
Oracle Database Backup encryption RMAN Encryption
Installing Oracle 12C in Linux-6-64
Install Oracle 11gR2 (x64) in CentOS 6.4)
Steps for installing Oracle 11gR2 in vmwarevm
Install Oracle 11g XE R2 In Debian
--------------------------------------------------------------------------------
RMAN> restore database;
Start restore from March 7 to April 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: restore command (on 12:06:00) failed
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-jul14
Allocated channel: ORA_DISK_1
Channel ORA_DISK_1: sid = 1084 devtype = DISK
Crosschecked 10 objects
Finished implicit crosscheck backup at 31-jul14
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_1__9xm5yupa _. 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_20171.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
Because the backup set has expired, the database cannot be restored. register the backup disk again.
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_4241.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_20171.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_20171.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;
Restore the database to the specified sequence.
RMAN> recover database until sequence 13908
After the restoration, start the database.
RMAN> alter database open resetlogs