cancel
Showing results for 
Search instead for 
Did you mean: 

Full recovery of SAP system data

0 Kudos
212

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

View Entire Topic
sumitjais
Active Contributor

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),

0 Kudos
hi, sumitjais

For the three kinds of files you mentioned, what type of files will the SAP save for them respectively?

Thanks

0 Kudos

I see the following types of files on my disk:

sumitjais
Active Contributor
0 Kudos
Hi Bruce Zhang, Brtools reads initSID.sap file for the parameters ( path, type of backup and format of files) while performing the backups. The location of the backup is determined by backup_root_dir. The backup formats (in general) are xxx.anf or xxx.and (if triggered for disk backup). In your first snip, there is no full or incremental backup file I see. You need to check the correct location. The parameters log_archive_dest and log_archive_format determine the location and format of archive logs in oracle. In your 2nd snip, /oracle/<DBSID>/oraarch correctly shows all the archive logs.
0 Kudos

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:

sumitjais
Active Contributor
0 Kudos

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).