Skip to Main Content
Forums

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

getting error in RMAN restoring control file

user 777111Jan 30 2011 — edited Jan 30 2011
Hi All,

i am trying to restore control file from tape until 5th jan 2011. however i am getting the below error. can you please hlp?


RMAN> restore controlfile until time "to_date('05-JAN-2011 23:59:59','DD-MON-YYYY:hh24:mi:ss')";
Starting restore at 30-JAN-11
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=211 devtype=DISK
channel ORA_DISK_1: starting datafile backupset restore
channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: reading from backup piece /u04/oradata/BACKUP/CDSSV/CDSSV_controlfile_rklt5dp7_1_1.rbck
ORA-19870: error reading backup piece /u04/oradata/BACKUP/CDSSV/CDSSV_controlfile_rklt5dp7_1_1.rbck
ORA-19505: failed to identify file "/u04/oradata/BACKUP/CDSSV/CDSSV_controlfile_rklt5dp7_1_1.rbck"
ORA-27037: unable to obtain file status
IBM AIX RISC System/6000 Error: 2: No such file or directory
Additional information: 3
failover to previous backup
channel ORA_DISK_1: starting datafile backupset restore
channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: reading from backup piece /u04/oradata/BACKUP/CDSSV/CDSSV_inc0_rilt5djb_1_1.rbck
ORA-19870: error reading backup piece /u04/oradata/BACKUP/CDSSV/CDSSV_inc0_rilt5djb_1_1.rbck
ORA-19505: failed to identify file "/u04/oradata/BACKUP/CDSSV/CDSSV_inc0_rilt5djb_1_1.rbck"
ORA-27037: unable to obtain file status
IBM AIX RISC System/6000 Error: 2: No such file or directory
Additional information: 3
failover to previous backup
channel ORA_DISK_1: starting datafile backupset restore
channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: reading from backup piece /u04/oradata/BACKUP/CDSSV/CDSSV_controlfile_qils5r2g_1_1.rbck
ORA-19870: error reading backup piece /u04/oradata/BACKUP/CDSSV/CDSSV_controlfile_qils5r2g_1_1.rbck
ORA-19505: failed to identify file "/u04/oradata/BACKUP/CDSSV/CDSSV_controlfile_qils5r2g_1_1.rbck"
ORA-27037: unable to obtain file status
IBM AIX RISC System/6000 Error: 2: No such file or directory
Additional information: 3
failover to previous backup
channel ORA_DISK_1: starting datafile backupset restore
channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: reading from backup piece /u04/oradata/BACKUP/CDSSV/CDSSV_inc0_qgls5qss_1_1.rbck
ORA-19870: error reading backup piece /u04/oradata/BACKUP/CDSSV/CDSSV_inc0_qgls5qss_1_1.rbck
ORA-19505: failed to identify file "/u04/oradata/BACKUP/CDSSV/CDSSV_inc0_qgls5qss_1_1.rbck"
ORA-27037: unable to obtain file status
IBM AIX RISC System/6000 Error: 2: No such file or directory
Additional information: 3
failover to previous backup
channel ORA_DISK_1: starting datafile backupset restore
channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: reading from backup piece /u04/oradata/BACKUP/CDSSV/CDSSV_controlfile_p4lqug4j_1_1.rbck
ORA-19870: error reading backup piece /u04/oradata/BACKUP/CDSSV/backup_for_clone/CDSSV_controlfile_p4lqug4j_1_1.rbck
ORA-19505: failed to identify file "/u04/oradata/BACKUP/CDSSV/backup_for_clone/CDSSV_controlfile_p4lqug4j_1_1.rbck"
ORA-27037: unable to obtain file status
IBM AIX RISC System/6000 Error: 2: No such file or directory
Additional information: 3
failover to previous backup
channel ORA_DISK_1: starting datafile backupset restore
channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: reading from backup piece /u04/oradata/BACKUP/CDSSV/CDSSV_inc0_p2lqug37_1_1.rbck
ORA-19870: error reading backup piece /u04/oradata/BACKUP/CDSSV/backup_for_clone/CDSSV_inc0_p2lqug37_1_1.rbck
ORA-19505: failed to identify file "/u04/oradata/BACKUP/CDSSV/backup_for_clone/CDSSV_inc0_p2lqug37_1_1.rbck"
ORA-27037: unable to obtain file status
IBM AIX RISC System/6000 Error: 2: No such file or directory
Additional information: 3
failover to previous backup
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 01/30/2011 06:02:30
RMAN-06026: some targets not found - aborting restore
RMAN-06101: no channel to restore a backup or copy of the control file
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 27 2011
Added on Jan 30 2011
#performance-availability, #recovery-manager-rman
4 comments
1,923 views