rman target / Recovery Manager: Release 126.96.36.199.0 - Production on Wed Sep 18 20:47:38 2013 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved. connected to target database (not started) RMAN> startup nomount Oracle instance started Total System Global Area 8551575552 bytes Fixed Size 2245480 bytes Variable Size 503319704 bytes Database Buffers 8036286464 bytes Redo Buffers 9723904 bytes RMAN> set DBID=2387922???; executing command: SET DBID RMAN> restore controlfile from '/dba/share/MYDB/c-2387922???-20130910-00.ctl'; Starting restore at 18-SEP-13 using target database control file instead of recovery catalog allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=391 device type=DISK 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 09/18/2013 20:48:04 RMAN-06172: no AUTOBACKUP found or specified handle is not a valid copy or pieceWe searched MOS and forums. Most of the search , pointing it is old backup ( more then 7 day ), some doc say backup corrupted etc etc. Instead going for whole story that how reached to conclusion, let we tell you the finding.
We found the mount option for /dba/share/MYDB ( where we copied backup from source ) not correct
...that's why getting error. We changed it to
rw,bg,intr,hard,timeo=600,wsize=32768,rsize=32768,nfsvers=3,tcp,noacl 0 0
After this change we able to restore control file and rest of the backup successfully