Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

SAP Oracle - online backup + archive logs.

Hi Colleagues,

I have to prepare Oracle 11.20.0.3 online backup + restore via brtools and I’m just wondering how to do this as fast as possible due to limited time. For example I thought that I will do it this way:

  1. BRTOOLS

Online database backup on the old server

  1. Preparation new environment ( I need some time for new environment preparation and system work 24h by day)

Restore online database backup on the new server

  1. BRTOOLS

Archive log backup on the old server

  1. BRTOOLS

Restore archive log on the new server

Question is, how to prepare restore procedure ? Between restore full online backup and restore archive logs will take several days. Can I use for restore brtools options:

At first – Complete database recovery (restore online backup)

Next pint – Restore and application of archivelog files (restore archive logs)

What do you thinking about it, this is correct way it I want to at first restore online backup and after few days restore archive log ? How shall I do this ?

Regards,

T.

Former Member
replied

HI Tomasz,

SAP note 1003028 should help for your case.

Also please refer to link below:

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/707dbe81-ef39-2b10-a0ac-ec50f3b4884d?overridelayout=t…


Best regards,
James

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question