custom_sort_file <file_path>
Specify this parameter only when the sort_backup_type or the sort_restore_type parameters are set to custom.
When custom is specified, set the custom_sort_file parameter to a valid file. The file_path value must be a full path name to a custom sort file that an end user created, and it must have public permissions. The following is an example argument to the custom_sort_file parameter:
UNIX or Linux:
/usr/openv/dbext/ext/db_ext/sap/scripts/sap_custom_sort_file
Windows:
install_path\NetBackup\dbext\SAP\Samples\sap_custom_sort_file
Note:
Not applicable in MaxDB database environments or in any Oracle database environments that use RMAN.
The custom sort file must include two fields. The first field groups a set of files into a particular job. The second field is a file path name that maps the SAP backup file list to a group ID.
The following is an example of a custom sort file for Windows:
1 c:\oracle\sap\sapdata1\btabd_1\btabd.data1 1 c:\oracle\sap\sapdata2\btabi_1\btabi.data1 1 c:\oracle\sap\sapdata2\clud_1\clud.data1 1 c:\oracle\sap\sapdata1\ddicd_1\ddicd.data1 1 c:\oracle\sap\sapdata5\ddici_1\ddici.data1 1 c:\oracle\sap\sapdata4\el30cd_1\EL30cd.data1 1 c:\oracle\sap\sapdata1\el30ci_1\el30ci.data1 1 c:\oracle\sap\sapdata6\es30cd_1\es30cd.data1 1 c:\oracle\sap\sapdata2\poold_1\poold.data1 1 c:\oracle\sap\sapdata1\pooli_1\pooli.data1 1 c:\oracle\sap\sapdata4\protd_1\protd.data1
2 c:\oracle\sap\sapdata1\roll_1\roll.data1 2 c:\oracle\sap\sapdata2\sourced_1\sourced.data1 2 c:\oracle\sap\sapdata3\stabd_1\stabd.data1 2 c:\oracle\sap\sapdata2\stabi_2\stabi.data2 2 c:\oracle\sap\sapdata1\temp_1\temp.data1 2 c:\oracle\sap\sapdata4\user1d_1\user1d.data1 2 c:\oracle\sap\sapdata2\user1i_1\user1i.data1 2 c:\oracle\sap\sapdata1\system_1\system.data1 2 c:\oracle\sap\saplog1\log_g1_m1\log1_m1.dbf 2 c:\oracle\sap\saplog1\log_g2_m1\log2_m1.dbf 2 c:\oracle\sap\saplog1\log_g3_m1\log3_m1.dbf 2 c:\oracle\sap\saplog1\log_g4_m1\log4_m1.dbf 2 c:\oracle\sap\dbs\cntrlSAP.dbf
The following is an example of a custom sort file for UNIX or Linux:
1 /oracle/sap/sapdata1/btabd_1/btabd.data1 1 /oracle/sap/sapdata2/btabi_1/btabi.data1 1 /oracle/sap/sapdata2/clud_1/clud.data1 1 /oracle/sap/sapdata1/ddicd_1/ddicd.data1 1 /oracle/sap/sapdata5/ddici_1/ddici.data1 1 /oracle/sap/sapdata4/el30cd_1/EL30cd.data1 1 /oracle/sap/sapdata1/el30ci_1/el30ci.data1 1 /oracle/sap/sapdata6/es30cd_1/es30cd.data1 1 /oracle/sap/sapdata2/poold_1/poold.data1 1 /oracle/sap/sapdata1/pooli_1/pooli.data1 1 /oracle/sap/sapdata4/protd_1/protd.data1
1 /dev/rdsk/c0t4d0s6
2 /oracle/sap/sapdata1/roll_1/roll.data1 2 /oracle/sap/sapdata2/sourced_1/sourced.data1 2 /oracle/sap/sapdata3/stabd_1/stabd.data1 2 /oracle/sap/sapdata2/stabi_2/stabi.data2 2 /oracle/sap/sapdata1/temp_1/temp.data1 2 /oracle/sap/sapdata4/user1d_1/user1d.data1 2 /oracle/sap/sapdata2/user1i_1/user1i.data1 2 /oracle/sap/sapdata1/system_1/system.data1 2 /oracle/sap/saplog1/log_g1_m1/log1_m1.dbf 2 /oracle/sap/saplog1/log_g2_m1/log2_m1.dbf 2 /oracle/sap/saplog1/log_g3_m1/log3_m1.dbf 2 /oracle/sap/saplog1/log_g4_m1/log4_m1.dbf 2 /oracle/sap/dbs/cntrlSAP.dbf
Based on the custom sort file, if SAP tools submit the entire file list to backint for backup, two jobs are created. The first job includes all the files that have a "1" in the first field. The second job includes all the files that have a "2" in the first field.
The following is a list of jobs and associated files:
Backup job and restore job 1
Windows:
c:\oracle\sap\sapdata1\btabd_1\btabd.data1 c:\oracle\sap\sapdata2\btabi_1\btabi.data1 c:\oracle\sap\sapdata2\clud_1\clud.data1 c:\oracle\sap\sapdata1\ddicd_1\ddicd.data1 c:\oracle\sap\sapdata5\ddici_1\ddici.data1 c:\oracle\sap\sapdata4\el30cd_1\EL30cd.data1 c:\oracle\sap\sapdata1\el30ci_1\el30ci.data1 c:\oracle\sap\sapdata6\es30cd_1\es30cd.data1 c:\oracle\sap\sapdata2\poold_1\poold.data1 c:\oracle\sap\sapdata1\pooli_1\pooli.data1 c:\oracle\sap\sapdata4\protd_1\protd.data1 c:\dev\rdsk\c0t4d0s6
UNIX or Linux:
/oracle/sap/sapdata1/btabd_1/btabd.data1 /oracle/sap/sapdata2/btabi_1/btabi.data1 /oracle/sap/sapdata2/clud_1/clud.data1 /oracle/sap/sapdata1/ddicd_1/ddicd.data1 /oracle/sap/sapdata5/ddici_1/ddici.data1 /oracle/sap/sapdata4/el30cd_1/EL30cd.data1 /oracle/sap/sapdata1/el30ci_1/el30ci.data1 /oracle/sap/sapdata6/es30cd_1/es30cd.data1 /oracle/sap/sapdata2/poold_1/poold.data1 /oracle/sap/sapdata1/pooli_1/pooli.data1 /oracle/sap/sapdata4/protd_1/protd.data1/dev/rdsk/c0t4d0s6
Backup job and restore job 2:
Windows:
c:\oracle\sap\sapdata1\roll_1\roll.data1 c:\oracle\sap\sapdata2\sourced_1\sourced.data1 c:\oracle\sap\sapdata3\stabd_1\stabd.data1 c:\oracle\sap\sapdata2\stabi_2\stabi.data2 c:\oracle\sap\sapdata1\temp_1\temp.data1 c:\oracle\sap\sapdata4\user1d_1\user1d.data1 c:\oracle\sap\sapdata2\user1i_1\user1i.data1 c:\oracle\sap\sapdata1\system_1\system.data1 c:\oracle\sap\saplog1\log_g1_m1\log1_m1.dbf c:\oracle\sap\saplog1\log_g2_m1\log2_m1.dbf c:\oracle\sap\saplog1\log_g3_m1\log3_m1.dbf c:\oracle\sap\saplog1\log_g4_m1\log4_m1.dbf c:\oracle\sap\dbs\cntrlSAP.dbf
UNIX or Linux:
/oracle/sap/sapdata1/roll_1/roll.data1 /oracle/sap/sapdata2/sourced_1/sourced.data1 /oracle/sap/sapdata3/stabd_1/stabd.data1 /oracle/sap/sapdata2/stabi_2/stabi.data2 /oracle/sap/sapdata1/temp_1/temp.data1 /oracle/sap/sapdata4/user1d_1/user1d.data1 /oracle/sap/sapdata2/user1i_1/user1i.data1 /oracle/sap/sapdata1/system_1/system.data1 /oracle/sap/saplog1/log_g1_m1/log1_m1.dbf /oracle/sap/saplog1/log_g2_m1/log2_m1.dbf /oracle/sap/saplog1/log_g3_m1/log3_m1.dbf /oracle/sap/saplog1/log_g4_m1/log4_m1.dbf /oracle/sap/dbs/cntrlSAP.dbf