Integrating SAP R/3 and Data Protector

Troubleshooting

"<Session_ID>" -media(other UNIX systems)

on the SAP R/3 Database Server system.

The output of the command lists detailed information about the specified backup object, session IDs of the backup sessions containing this object, and a list of the media used.

For detailed syntax of the omnidb command, run:

/opt/omni/bin/omnidb -help (HP-UX and Solaris systems)

/usr/omni/bin/omnidb -help (other UNIX systems)

You can also do this using the SAP R/3 utilities:

Use backint, so that SAPDBA will also use this command to query:

/opt/omni/lbin/backint -f inquiry -u <ORACLE_SID> -i <input_file> (HP-UX and Solaris systems)

/usr/omni/bin/backint -f inquiry -u <ORACLE_SID> -i <input_file> (other UNIX systems)

where the specified <input_file> is queried.

If this fails, check if the backup session was performed successfully and if the query was started under the appropriate user account.

Backint anticipates a list of files of the following format:

<backup_ID_1> <pathName_1> [<targetDirectory_1>] <backup_ID_2> <pathName_2> [<targetDirectory_2>] <backup_ID_3> <pathName_3> [<targetDirectory_3>]

To retrieve the <backup_ID> numbers, enter the following command: echo "#NULL #NULL" backint –f inquiry –u<ORACLE_SID>

or, alternatively, you can just specify #NULL as <backup_ID_1> in the <input_file>. In this case, the latest backup session for the file is used for the restore.

3.Verify the restore using the Data Protector User Interface This test is possible if the objects have been backed up by backint. See “Restoring an SAP R/3 Database” on page 204.

If this fails, check if the backup session was performed successfully and if the query was started under the appropriate user account.

236

Chapter 2