Hi,
When i tried restoring my controlfile from auto backup, it's throwing an error like this (11.2.0.3-RHEL6)
RMAN> restore controlfile from AUTOBACKUP;
Starting restore at 17-JUN-13
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=63 device type=DISK
channel ORA_DISK_1: looking for AUTOBACKUP on day: 20130617
channel ORA_DISK_1: looking for AUTOBACKUP on day: 20130616
channel ORA_DISK_1: looking for AUTOBACKUP on day: 20130615
channel ORA_DISK_1: looking for AUTOBACKUP on day: 20130614
channel ORA_DISK_1: looking for AUTOBACKUP on day: 20130613
channel ORA_DISK_1: looking for AUTOBACKUP on day: 20130612
channel ORA_DISK_1: looking for AUTOBACKUP on day: 20130611
channel ORA_DISK_1: no AUTOBACKUP in 7 days found
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 06/17/2013 04:38:55
RMAN-06172: no AUTOBACKUP found or specified handle is not a valid copy or piece
But i backed up the database few seconds back before issuing the restore command...
See the output of "list backup" command...(I'm not pasting everything but just interesting part)
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
46 Full 9.45M DISK 00:00:00 17-JUN-13
BP Key: 47 Status: AVAILABLE Compressed: NO Tag: TAG20130617T042656
Piece Name: /u01/app/oracle/oradata/orcl/backup/ctrl_c-2799503914-20130617-01
SPFILE Included: Modification time: 16-JUN-13
SPFILE db_unique_name: DB11203
Control File Included: Ckp SCN: 5487061 Ckp time: 17-JUN-13
Why Oracle is saying no auto backups of control file found?? Any bug or something?
Thanks in advance
CSM