Loading...

Finding the Media for the Oracle Backup Piece Copy

You can use the GetMediaByOracleBackupPiece qScript to find the media that contains the backup identified by the backup piece.

Use this procedure when you know the backup piece name, but do not know the media that contains the backup. This can happen when the primary copy has been copied to different media. If you do not know the backup piece name, you can get the backup piece name by running the getbackupList command. For more information, see Viewing Oracle RMAN Backup Pieces.

Procedure

  1. On the Oracle Agent host,run the qlogin command to log on to the CommServe computer.

    You must be in the Software_Installation_Directory/Base path when you run the qlogin command on a LINUX machine.

  2. Run the script below, substitute the Storage_Policy_Name and Backup_Piece_Name.

    QOperation execscript -sn "GetMediaByOracleBackupPiece" -si "Storage_Policy_Name" -si "Backup_Piece_Name"

Example

Find the media that the backup was copied to. The backup piece is named "3301_DB11_6sq1vj3d_1_1" and uses the "SofTestCS_SP3" storage policy.

./qoperation execscript -sn "GetMediaByOracleBackupPiece" -si "SofTestCS_SP3" -si "3301_DB11_6sq1vj3d_1_1"

jobId        BackupPiece           BackupLevel      Storage Policy     Copy               LibraryName          Media

_____       ______________        _____________     _______________   _____              _______________      ________

3301       3301_DB11_6sq1vj3d_1_1    Full           SofTestCS_SP3   Oracle_RAC_SOFCopy   Oraclehype_Lib1     D:\R11.0MA_Location
3301       3301_DB11_6sq1vj3d_1_1    Full           SofTestCS_SP3   Oraclehype_VTLCopy   Oraclehype_VT1L_4D  v11v00WW
3301       3301_DB11_6sq1vj3d_1_1    Full           SofTestCS_SP3   Oraclehype_VTLCopy   Oraclehype_VT1L_4D  v11v01WW
3301       3301_DB11_6sq1vj3d_1_1    Full           SofTestCS_SP3   Oraclehype_VTLCopy   Oraclehype_VT1L_4D  v11v02WW
3301       3301_DB11_6sq1vj3d_1_1    Full           SofTestCS_SP3   Oraclehype_VTLCopy   Oraclehype_VT1L_4D  v11v03WW
3301       3301_DB11_6sq1vj3d_1_1    Full           SofTestCS_SP3   Oraclehype_VTLCopy   Oraclehype_VT1L_4D  v11v04WW
3301       3301_DB11_6sq1vj3d_1_1    Full           SofTestCS_SP3   Oraclehype_VTLCopy   Oraclehype_VT1L_4D  v11v05WW
3301       3301_DB11_6sq1vj3d_1_1    Full           SofTestCS_SP3   Oraclehype_VTLCopy   Oraclehype_VT1L_4D  v11v06WW
3301       3301_DB11_6sq1vj3d_1_1    Full           SofTestCS_SP3   Oraclehype_VTLCopy   Oraclehype_VT1L_4D v11v07WW
3301       3301_DB11_6sq1vj3d_1_1    Full           SofTestCS_SP3   Primary_CSLib        E:\Media_Agent_Library\Backup_DiskLib1
Qscript Execution Succeeded!

Last modified: 3/26/2018 6:50:42 PM