Use
You can also use external tools to determine the names of the volumes relevant for the Oracle backup. This might involve an external volume management system or simply a shell script. You can do this if you have deactivated BRBACKUP or BRARCHIVE
automatic volume management by calling them with the option -v. However, the expiration period of the volumes is checked anyway.Prerequisites
The external tool that you use for volume selection must make sure that only non-locked volumes are suggested for backup. Otherwise, BRBACKUP or BRARCHIVE terminate if they do not find enough free volumes. Make sure that initialized volumes are available for the backup.
Procedure
BRBACKUP or BRARCHIVE only use the volumes listed with option -v for one backup.
You can select the volume names yourself by defining them in the call with the option
brbackup -v C11B141,C11B142,C11B143
brarchive -ssd -v C11A141,C11A142
You can also give the volumes other names. One option would be to include the day of the backup in the volume names. BRBACKUP or BRARCHIVE can use the following sample script to assign the volume names to the day of the month on which the backup was started.
The name
DBSID
= ORACLE_SID (name of the database instance),X
= A for BRARCHIVE or X = B for BRBACKUPdd
= day of monthn
= next volume number within one backup.Here is the script:
day=
`date | cut -f 3 -d " "`