Skip to Main Content
  • Questions

  • How to restore backup with one controlfile and last logfile

Breadcrumb

Question and Answer

Tom Kyte

Thanks for the question, Peter.

Asked: September 29, 2008 - 5:08 pm UTC

Last updated: October 01, 2008 - 4:14 pm UTC

Version: 9i

Viewed 1000+ times

You Asked

Hello Tom,

I have trouble to restore backup (probably manual hot-online one) I have received from other DBA guy. I believe it is not broken and I have:
- all datafiles
- one copy of CTL file ( binary and also tracefile in text )
- only one logfile (I believe one which contains all changes during backup time)

I did following to restore/recover that backup:

1) adjusted spfile to point new DBNAME
2) startup nomount
3) CREATE CONTROLFILE SET DATABASE "<dbname>" RESETLOGS NOARCHIVELOG....
4) RECOVER DATABASE USING BACKUP CONTROLFILE; --> I used that one logfile I had in backup
5) ALTER DATABASE OPEN RESETLOGS; --> fails with "ORA-01113: file 1 needs media recovery"

I think I did something wrong because I did not used binary control file from backup. I know I can use that control file with 'alter database rename file <..> to <..>. But then problem is that I have just one log file and control file from backup refers 8 log files. This is why I go into "CREATE CONTROLFILE SET DATABASE" option instead.

So question is, what is appropriate way to recover when backup consists from:
- all datafiles
- one copy of CTL file ( binary and also tracefile in text )
- only one logfile (I believe one which contains all changes during backup time)

Thanks in advance.

and Tom said...

you need to apply the redo log that you have, you didn't do that.

Your scenario is:

Losing All Members of a Multiplexed Control File When a Backup Is Available

http://docs.oracle.com/cd/B10501_01/server.920/a96572/osrestore.htm#26899

Rating

  (1 rating)

Is this answer out of date? If it is, please let us know via a Comment

Comments

now solved..

Peter, October 02, 2008 - 3:21 pm UTC

Many thanks for advice. To be precise, I used
RECOVER DATABASE USING BACKUP CONTROLFILE

with manual CANCEL after processing of the log file..,
and correct clause for incomplete recovery (because I had just one LOG file containing changes during database BACKUP mode) should be:
RECOVER DATABASE USING BACKUP CONTROLFILE UNTIL CANCEL

with CANCEL after processing one log file.

more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's channel and Chris's channel from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.

More to Explore

Backup/Recovery

Check out the complete guide to all of the Backup & Recovery techniques in the Oracle Database.