SAPDBA: Backup Offline Redo Logs 

a

- Archive function

Save offline redo logs

b

- Parameter file

initC11.sap

c

- Archive device type

tape

d

- Number of redo logs

10000

e

- Archive volume(s)

  

f

- Query only

no

g

- Fill tape(s) permanently

no

h

- Special options

  

i

- Standard backup of offline redo logs

yes

j

- Use disk backup

no

q

- Return

  
     

s

- Start BRARCHIVE

  

– Save offline redo logs: Archives the offline redo log files that have not yet been backed up (default).

– Second copy of offline redo logs: Creates a second copy of the offline redo log files.

– Double save (parallel) offline redo logs: Archives the offline redo log files that have not yet been saved, to two tape devices in parallel.

– Save and delete offline redo logs: Archives the offline redo log files and then deletes these files.

– Second copy and delete offline redo logs: Creates a second copy of offline redo log files and then deletes these files from the archiving directory.

– Double save and delete offline redo logs: Archives the offline redo logs that have not yet been backed up, to two tape devices in parallel, and then deletes the files from the archiving directory.

– Delete saved offline redo logs: Deletes the offline redo log files that have already been archived (the oldest backed up offline redo log files is deleted first).

– Delete copied offline redo logs: Deletes offline redo log files that have already been archived twice.

– Copy and save offline redo logs: Creates a second copy of offline redo log files that have already been archived and then archives the offline redo log files that have been created in the meantime.

– Copy, delete and save offline redo logs: Creates a second copy of offline redo log files that have already been archived and then deletes them and archives the offline redo log files that have been created in the meantime.

– Initialize BRARCHIVE tape: Use this option to initialize a volume.

Check label before initialization no

The label of the volume to be used is not checked. You can initialize new non-SAP volumes or make a new label for previously initialized volumes. (Important: The expiration period is not checked.)

Check label before initialization yes

The label of the volume to be used is checked. You can only re-initialize SAP volumes that have expired. (This option is often used to rename volumes.)

Number of tapes 1

Specify the number of volumes that you want to initialize.

– Show BRARCHIVE tape header information: The information in the volume label is displayed.

– Stop BRARCHIVE run with fill option: Use this option to stop a BRARCHIVE backup run that was started with the option Continue until end of tape safely.

BRARCHIVE uses its log files (mainly the summary log) to identify offline redo log files that have already been archived and/or deleted. Offline redo log files are deleted only if they have been successfully archived.

To use a different initialization profile for BRARCHIVE , specify the name of the profile you want to use for the backup.

– local tape: Archiving to a local tape device (default: backup_dev_type = tape ).

– local tape juke box: Archiving to jukeboxes or autoloaders that can be addressed locally ( backup_dev_type = tape_box ).

– remote tape: Archiving to a remote system with the command specified in the backup profile ( backup_dev_type = pipe ).

– remote tape juke box: Archiving to jukeboxes or autoloader tape devices that can be addressed locally ( backup_dev_type = pipe _ box ).

– external backup tool (backint): File-by-file archiving using a backup program addressed by the BACKINT interface program ( backup_dev_type = util _ file ).
See Using External Backup Programs

Backup utility parameter file: If you want to make the backup using an external backup program, then you must specify the necessary parameters in a parameter file.

– local disk: Archiving to a locally installed or mounted disk ( backup_dev_type = disk , especially when using the Oracle Parallel Server).

– remote disk: Backup to a remote disk; this option is recommended if no disk is installed locally, since the transfer protocol is secure (ftp or rcp), and no verification is required, unlike an NSF mount (corresponds to backup_dev_type = stage ).

See also parameter init<DBSID>.sap backup_dev_type

Enter the number of redo log files that you want to process.

Archive function Save and delete offline redo logs, Number of redo logs 2: BRARCHIVE archives and deletes the two oldest offline redo log files that have not yet been backed up to tape.
Archive function Save and delete offline redo logs, Number of redo logs 10.000: BRARCHIVE archives and deletes all offline redo log files in the archiving directory.

BRARCHIVE determines how many offline redo log files fit onto a volume. If the files do not all fit onto one volume, then you will have to restart BRARCHIVE for the rest of the files.

– no: Archiving is started (default).

– with tape check: No archiving; you are told which tapes must be mounted for the archiving process, and a check is made on whether you have actually mounted these tapes.

– without tape check: No archiving; you are told which tapes must be mounted for the archiving process.

– no: An offline redo log file is archived as soon as it is created. This process is not stopped until the volume is full or the number of redo log files specified under number of redo logs has been backed up.

– <Number>: Number of offline redo log files that you want to archive together as a group; BRARCHIVE stops archiving until this number of offline redo log files is reached.
 Grouping Offline Redo Log Files, -f|-fill

For detailed information on the SAP utility BRARCHIVE, see SAP Backup Utilities and Initialization Profile init<DBSID>.sap.