Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have backed up database located on Host1 and restored/recovered it on Host2. After a while, I backed up DB on Host1 again.

Now I want DBs on Host1 and Host2 be the same using last backup.

How can I achieve this? Without deleting database on Host2?

share|improve this question
up vote 3 down vote accepted

You should be able to just do a restore/recover over top of the existing Host2. If you are trying to avoid a complete recovery, then I suspect the answer is you can't, but there are two notable exceptions.

  1. If you never opened the database on Host2 and you have all the archive logs between the first backup and the second, then you can recover Host2 using them.

  2. If you have opened Host2, you still might be able to do this if you have flashback database enabled and can flash back to the point before you opened it.

share|improve this answer
During first variant.. I need what? all archivelogs and newly backuped conrolfile? Or I just register newly backuped archivelogs with old control file and recover ? Am I wrong? – kupa Sep 17 '11 at 13:26
Assuming these are os files a simple restore would work, but if your using ASM you will need to take care of the original files as new ones will be created. The original ones will just take up space and make removing them a little harder later on. – GrumpyMonkey Sep 17 '11 at 14:27

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.