Re: Catalog RMAN backups on Tape?

From: Marcin Przepiorowski <pioro1_at_gmail.com>
Date: Sat, 30 Jan 2010 18:50:22 +0000
Message-ID: <3f5690af1001301050x21d8c3fdmf351becfb8be3179_at_mail.gmail.com>

Hi,

Sorry for coming back to old post but I made some additional research. There is a possibility to catalog backup pieces using RMAN and not only using dbms_backup_restore.

1. identify a list of backup sets on tapes using Media Manager commands ex. for EMC Networker (Legato) you can use - ./sbin/mminfo -q "client=piorovm" -r "ssid,name,totalsize,savetime,volume"

 ssid      name                                 total  date   volume
4267926146 RMAN:3bl4n6ru_1_1                  9961944 01/29/2010
piorovm.localdomain.001
4234372063 RMAN:3dl4n76v_1_1                805331112 01/29/2010
piorovm.localdomain.001
4217594914 RMAN:3el4n792_1_1               1389143616 01/29/2010
piorovm.localdomain.001
4200817814 RMAN:3fl4n7cl_1_1                477378960 01/29/2010

piorovm.localdomain.001

2. catalog backup piece using RMAN and name from output above

RMAN> catalog device type 'sbt_tape' backuppiece '3fl4n7cl_1_1'; released channel: ORA_SBT_TAPE_1
allocated channel: ORA_SBT_TAPE_1
channel ORA_SBT_TAPE_1: SID=149 device type=SBT_TAPE channel ORA_SBT_TAPE_1: NMO v5.0.0.0
cataloged backup piece
backup piece handle=3fl4n7cl_1_1 RECID=107 STAMP=709599788

3. RMAN> list backup;

List of Backup Sets

---

BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ ---------------

81      Full    Unknown    SBT_TAPE    00:00:00     29-JAN-10
        BP Key: 107   Status: AVAILABLE  Compressed: NO  Tag: TAG20100129T224333
        Handle: 3fl4n7cl_1_1   Media:

  List of Datafiles in backup set 81
  File LV Type Ckp SCN Ckp Time Name

• -- ---- ---------- --------- ---- 3 Full 8788185 29-JAN-10 +DATA/pioro/datafile/undotbs1.261.695313067

Of course for other Media Manager command in point number 1 are different but you can find command for Netbackup in Allen mail.

ps.
I will write a blog post about it soon.

regards,
Marcin Przepiorowski
http://oracleprof.blogspot.com/

On Tue, Jan 26, 2010 at 4:42 PM, Allen, Brandon <Brandon.Allen_at_oneneck.com> wrote:
> 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_at_yahoo.com]
>
> 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.
>

--
http://www.freelists.org/webpage/oracle-l

Received on Sat Jan 30 2010 - 12:50:22 CST