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!

RMAN backup/restore how to do a self contained

user632098Apr 12 2013 — edited Apr 13 2013
I have following backup script:

allocate channel ch1 type $CHANNEL_TYPE;
backup as compressed backupset
incremental level 0
format '${RMBKUPDIR}dbfile_%U%_%t'
database;

# switch current archived log, so there is at least
# one archived log to backup in next command.
sql 'ALTER SYSTEM ARCHIVE LOG CURRENT';

# now backup archived logs
backup as compressed backupset
archivelog like '$ARCHDIR/%.arc' format '${RMBKUPDIR}arlog_%U%_%t'
delete input;

Which was completed let us say at 5:15 PM


I see my rman log that a control file backup was also done towards the end:
Finished backup at 2013-03-31 17:15:22

Starting Control File and SPFILE Autobackup at 2013-03-31 17:15:22
piece handle=c-38338326-20130331-07 comment=API Version 2.0,MMS Version 5.0.0.0
Finished Control File and SPFILE Autobackup at 2013-03-31 17:18:01
released channel: ch1


Now I am doing point in time restore:

1. I first retsore control file from c-38338326-20130331-07

2. I then specify set until time to 6:00PM (45 minutes after backup..)
and then do restore.

When rman restore completes, it errors that system and some other database files reuqires more recovery?
I cannot open database with restelogs option. Why?

I thought my backup is self contained in the sense that I did archive log backup towards the end of my script; so only those archived logs should be needed. But it is requesting additional archive logs; only when they are retsored and applied; I can open my database with resetlogs.

Should I have specied set until time to 5:18PM instead of 6:00PM. Would that have made a difference?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 11 2013
Added on Apr 12 2013
4 comments
504 views