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.
- 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.
- 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"
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