Loading...

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

Last modified: 1/15/2019 4:27:16 PM