> Expert > Backup and Restore Agents > Databases > Oracle > Oracle Backup Administrator Guide > Configuration for Oracle > Additional Configuration for Oracle

Viewing Oracle RMAN Backup Pieces

An Oracle RMAN backup set contains one or more backup pieces. You might need to restore a specific backup piece.

You can use this procedure to get the backup piece information, including the file name, for a restore job.

Procedure

  1. View the job history for the client to identify the job ID. On the command line, type the following command: 

     
    ./qlist jobhistory -c <client_name> -a Q_ORACLE -i <Oracle_DB_Instance> -s <subclient>

  2. List all the RMAN backup pieces for the backup job ID. On the command line, type the following command: 

     
    ./getbackupList -jobid <job_ID> -outfile <out_file> -dbjob

Example

[root@dbserve Base]# ./qlist jobhistory -c uxdboe5 -a Q_ORACLE -i RDMDB -s uxdbp_log
 JOBID    STATUS       STORAGE POLICY    SUBCLIENT    INSTANCE
 -----    ------       --------------    ---------    --------
 6394     Completed    sh                default      RDMDB
 5686     Completed    sh                default      RDMDB
 [root@dbserve Base]# ./getbackupList -jobid 6394 -outfile /tmp/oracle.out -dbjob
 getBackupList succeeded
 [root@dbserve Base]# cat /tmp/oracle.out
 DATA ----------------------------------- Archive Files List For Db Job ----------------------------------------------------------                                          --
 archFileName                  |    fileType  |    createTime     |    archFileId|    archGroupId |    jobId
 DATA ----------------------------------- Archive Files List For Db Job ----------------------------------------------------------                                          --
 42o3p5nh_1_1                  |    1         |    1362509187     |    23055     |    35          |    6394
 43o3p5nh_1_1                  |    1         |    1362509207     |    23056     |    35          |    6394
 44o3p5qi_1_1                  |    1         |    1362509279     |    23057     |    35          |    6394
 c-1814427393-20130305-00      |    1         |    1362509290     |    23058     |    35          |    6394
 LOGS ----------------------------------- Archive Files List For Db Job ----------------------------------------------------------                                          --
 archFileName                  |    fileType  |    createTime     |    archFileId|    archGroupId |    jobId
 LOGS ----------------------------------- Archive Files List For Db Job ----------------------------------------------------------                                          --
 46o3p5su_1_1                  |    4         |    1362509359     |    23059     |    35          |    6394
 47o3p5su_1_1                  |    4         |    1362509380     |    23060     |    35          |    6394
 48o3p5uc_1_1                  |    4         |    1362509399     |    23061     |    35          |    6394
 c-1814427393-20130305-01      |    4         |    1362509408     |    23062     |    35          |    6394

Loading...