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!

How to restore specific backup file from RMAN?

1002173Apr 10 2013 — edited Apr 19 2013
Hi,

I am just begginer with Oracle DB so I do not have a lot knowledge.

I created two backups at April the 8th and April the 10th.

I did following from RMAN.

shutdown immediate
startup mount
configure channel 1 device type disk format '/opt/oracle/backup/std_%U';
backup database
startup

output was:
including current control file in backupset
including current SPFILE in backupset



it created two files: std-0so6l0vn(2 GB) and std_0to6l106 (7 MB).
First question - first file is backup and what is the second file???

Today I created also backup and it also created two files: std_0uo6morg (2GB) and std_0vo6morv (7MB)

Now I want to return backup from 2 days ago (*std-0so6l0vn*) but can't;

I do the the following:
shutdown immediate
startup mount
restore database from '/opt/oracle/backup/std_0so6l0vn'


but getting error - only SPFILE or control file can be restored from autobackup.

How to restore my backup from two days ago? It looks to me so complicated and hardly understandable.

What command to execute from RMAN to succeed in restore?

Thank you
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 17 2013
Added on Apr 10 2013
18 comments
2,429 views