Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

Professional Opinions
Ask a Question
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

troubleshooting Question

Restoring oracle on a new host

Avatar of soorej1
soorej1 asked on
Oracle Database
15 Comments1 Solution605 ViewsLast Modified:
Goal: Do a full recovery (to the last transaction committed) from hostA to hostB.

Following files are available:
1. Last night backup including the spfile and control file
2. Archive logs
3. Current Redo logs from hostA
4. Current control file from hostA

Other Notes: No catalog in RMAN, only control file based recovery

What I have achieved:
I am able to restore the database on hostB using the last night backup and the backed up spfile and ctl file. But then I am losing all the data committed after the last night backup. So the goal here is to apply all the new archivelogs and redo logs after last night backup.

Would it require to restore the database on hostB using latest control file from hostA?
How to roll forward to the last committed SCN using redo/archive logs?

Oh last point! I am an entry level DBA, with basic Oracle knowledge

Avatar of Devinder Singh Virdi
Devinder Singh VirdiFlag of United States of America imageLead Oracle DBA Team

Our community of experts have been thoroughly vetted for their expertise and industry experience.

This problem has been solved!
Unlock 1 Answer and 15 Comments.
See Answers