SAP Oracle - online backup + archive logs.
I have to prepare Oracle 22.214.171.124 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:
Online database backup on the old server
- 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
Archive log backup on the old server
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 ?
James Zhang replied
SAP note 1003028 should help for your case.
Also please refer to link below: