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
-
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]
-
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