Skip to Main Content

Oracle Database Discussions

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!

recover spfile from autobackup

918418Feb 18 2012 — edited Feb 20 2012
My db in archivelog mode, controlfile autobackup is on, then i have taken 1 bkp using rman, immediately deleted the spfile,then
startup nomount force;
set dbid=11111111
restore spfile from autobackup;
it shows error


channel ORA_DISK_1: looking for AUTOBACKUP on day: 20120229
channel ORA_DISK_1: looking for AUTOBACKUP on day: 20120228
channel ORA_DISK_1: looking for AUTOBACKUP on day: 20120227
channel ORA_DISK_1: looking for AUTOBACKUP on day: 20120226
channel ORA_DISK_1: looking for AUTOBACKUP on day: 20120225
channel ORA_DISK_1: looking for AUTOBACKUP on day: 20120224
channel ORA_DISK_1: looking for AUTOBACKUP on day: 20120223
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 02/29/2012 20:42:54
RMAN-06172: no AUTOBACKUP found or specified handle is not a valid copy or piece



i also use change the system date by forword it to 29th feb from 18th feb
also tried maxdays and maxseq, but error is same, can anybody help................
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 19 2012
Added on Feb 18 2012
12 comments
23,569 views