on 2020 Dec 02 1:34 PM
hi
When using incremental database backup files for data recovery, can I achieve full data recovery? The recovery tool I use is SAP standard tool BRRESTORE
thanksgiving
Request clarification before answering.
You can achieve it provided you have :
Last full backup files + the incremental backup files + Required archive logs (till the time you opt to recover),
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi ,Sumit Jaiswal
I checked file initSID.sap, which defines parameter backup_root_dir = D:\oracle\DEV\sapbackup, but does not define log_archive_dest and log_archive_format.
The files contained under path D:\oracle\DEV\sapbackup are shown in the figure below :
When I started the online backup, files bfffhkvo.fnd and folder bfffhkvo were generated. The files included in folder bfffhkvo are shown below:
Please check initDEV.ora (popularly called pfile) for log_archive_dest and log_archive_format.
(In case of DR, log_archive_dest is replaced by log_archive_dest_1).
you can check the same with sql - show parameter log_archive_dest
bfffhkvo.fnd should be your last incremental backup (to be used for restore & recovery.)
The incremental backup cannot be used alone to recover, please check for the last full backup too (it would have generated in the same path but would have been moved to safe place/tape).
User | Count |
---|---|
45 | |
9 | |
8 | |
6 | |
5 | |
5 | |
4 | |
4 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.