RE: Catalog RMAN backups on Tape?
- From: "Allen, Brandon" <Brandon.Allen@xxxxxxxxxxx>
- To: Robert Freeman <robertgfreeman@xxxxxxxxx>, "troach@xxxxxxxxx" <troach@xxxxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 26 Jan 2010 09:42:46 -0700
Here’s an example of the Netbackup command (bplist):
unx01.baanprd /opt/oracle ->bplist -t 4 -k <YOUR_policy_name> -l -s 1/25/2010
-e 1/26/2010 -R /
-rw------- oracle oracle 12582912 Jan 25 21:21 /c-18889999-20100125-09
-rw------- oracle oracle 2359296 Jan 25 21:18
/baanprd_al_52855_1_709244222
-rw------- oracle oracle 3383296K Jan 25 21:15
/baanprd_db_52852_1_709243545
And, here is the related command (bpclimagelist) that you use to check the
retention settings in Netbackup:
unx01.baanprd /opt/oracle ->bpclimagelist -t ANY -policy <YOUR_policy_name> -ct
4 -s 1/25/2010 -e 1/26/2010
Backed Up Expires Files KB C Sched Type Policy
---------------- ---------- -------- ----------- - ------------ ------------
01/25/2010 21:20 02/08/2010 5 12320 N User Backup
TAR_DP-Oracle-BAANPRD-hot
01/25/2010 21:17 02/08/2010 5 2336 N User Backup
TAR_DP-Oracle-BAANPRD-hot
01/25/2010 21:07 02/08/2010 5 3383328 N User Backup
TAR_DP-Oracle-BAANPRD-hot
Note that these commands are pretty picky so you have to get them just right
(e.g. policy name is case-sensitive, must have client and server configured
correctly, or set them correctly with command-line parameters) or they’ll just
return “EXIT STATUS 227: no entity was found”.
Also, the bpclimagelist command is the client version of bpimagelist, and I
think it’s only referred to as bpimagelist in the documentation.
Regards,
Brandon
From: Robert Freeman [mailto:robertgfreeman@xxxxxxxxx]
The key with dbms_backup_restore is that you need to know the piece names you
are dealing with. I know there is a way with Netbackup to get these names
________________________________
Privileged/Confidential Information may be contained in this message or
attachments hereto. Please advise immediately if you or your employer do not
consent to Internet email for messages of this kind. Opinions, conclusions and
other information in this message that do not relate to the official business
of this company shall be understood as neither given nor endorsed by it.
Other related posts:
