Skip to Main Content

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!

restore database using old backup piece

11g.DBASep 6 2012 — edited Sep 6 2012
Hi,
I want to restore my database through 2 days old backup piece.her the details and error


RMAN> restore database from 'C:\Oracle\recovery_area\orcl\BACKUPSET\2012_09_04\O
1_MF_NNND0_TAG20120904T133454_84CFKB4D_.BKP';

Starting restore at 06-SEP-12
using channel ORA_DISK_1

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 09/06/2012 14:45:16
RMAN-06509: only SPFILE or control file can be restored from AUTOBACKUP

Thanx in advance
This post has been answered by saurabh on Sep 6 2012
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 4 2012
Added on Sep 6 2012
12 comments
17,059 views