Home » RDBMS Server » Backup & Recovery » How RMAN handles backup pieces sent to tape,when backup failed in halfway (Oracle 11.2.0.3.0,Linux)
How RMAN handles backup pieces sent to tape,when backup failed in halfway [message #617152] Wed, 25 June 2014 08:55 Go to next message
rtjk
Messages: 33
Registered: February 2005
Member
Our environment is oracle 11.2.0.3.0 on Linux and RMAN is configured to Tape(TDP) with a retention of 30 days.

To check "How RMAN handles failed backup pieces sent to tape", I simulated RMAN backup failure by killing RMAN sessions at the DB level.

Now my question is

1.In our case what will happen to failed backup pieces at tape?
2.If I have failed backups in between two successful backups, and under my retention policy window When RMAN is going to delete obsolete failed backups?
3.Is there a option to delete failed RMAN backups at the tape ?


Can someone shed light on this?

Thanks
Re: How RMAN handles backup pieces sent to tape,when backup failed in halfway [message #617155 is a reply to message #617152] Wed, 25 June 2014 09:49 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

1. I bet it depends on the MML, so for yours you have to make a test. At Oracle side, you can query V$BACKUP_PIECE/V$BACKUP_PIECE_DETAILS and with RMAN use LIST command but...
2. If a backup piece failed I think it is not in RMAN catalog but once again better make a test and tell us the result.
3. I think it is not in RMAN catalog and so you can't delete it from RMAN. You have to do it from your tape management tool but... make a test.

Re: How RMAN handles backup pieces sent to tape,when backup failed in halfway [message #617170 is a reply to message #617155] Wed, 25 June 2014 12:53 Go to previous messageGo to next message
rtjk
Messages: 33
Registered: February 2005
Member
Hi,

I checked in v$BACKUP_PIECE_DETAILS and the backup piece shows up.We don't use catalog database.
so I guess this failed backup pieces will be deleted only when it is obsolete. ?

 
SQL> select BS_KEY,BP_KEY,DEVICE_TYPE,HANDLE,MEDIA,MEDIA_POOL,TAG,STATUS,DELETED,RMAN_STATUS_RECID from V$BACKUP_PIECE_DETAILS where RECID=18641
  2  ;

 
   BS_KEY     BP_KEY DEVICE_TYPE   HANDLE        MEDIA   MEDIA_POOL TAG        S DEL RMAN_STATUS_RECID
--------------------------------------------------------------------------------------------------------------------------------------
     18641      18641  SBT_TAPE    lqpblhfq_1_1    57063      0    DBINCR0     A  NO             10484
                                                                                                                        
                                                                                                                                                                
SQL> l
  1*  select BS_KEY,BP_KEY,DEVICE_TYPE,HANDLE,MEDIA,MEDIA_POOL,TAG,STATUS,DELETED,RMAN_STATUS_RECID from V$BACKUP_PIECE_DETAILS where RECID=18642
SQL> /

    BS_KEY     BP_KEY DEVICE_TYPE       HANDLE       MEDIA    MEDIA_POOL TAG    S DEL RMAN_STATUS_RECID ----------------------------------------------------------------- ---------- ----- ---  ---------------
     18642      18642 SBT_TAPE          lppblhfq_1_1 56463      0     DBINCR0    A NO              10484
                                                                                                                                 






Also using list command , backup piece shows up.(removed "Name" intentionally)

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
18641   Incr 0  11.56G     SBT_TAPE    01:13:49     24-JUN-14
        BP Key: 18641   Status: AVAILABLE  Compressed: YES  Tag: DBINCR0
        Handle: lqpblhfq_1_1   Media: 57063
  List of Datafiles in backup set 18641
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  11   0  Incr 1754363780 24-JUN-14 
  30   0  Incr 1754363780 24-JUN-14 
  41   0  Incr 1754363780 24-JUN-14 

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
18642   Incr 0  13.27G     SBT_TAPE    01:17:17     24-JUN-14
        BP Key: 18642   Status: AVAILABLE  Compressed: YES  Tag: DBINCR0
        Handle: lppblhfq_1_1   Media: 56463
  List of Datafiles in backup set 18642
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  1    0  Incr 1754363779 24-JUN-14 
  2    0  Incr 1754363779 24-JUN-14 
  5    0  Incr 1754363779 24-JUN-14 
  6    0  Incr 1754363779 24-JUN-14 
  8    0  Incr 1754363779 24-JUN-14 
  21   0  Incr 1754363779 24-JUN-14 
  22   0  Incr 1754363779 24-JUN-14 
  37   0  Incr 1754363779 24-JUN-14 
  38   0  Incr 1754363779 24-JUN-14 
Re: How RMAN handles backup pieces sent to tape,when backup failed in halfway [message #617173 is a reply to message #617170] Wed, 25 June 2014 13:05 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
We don't use catalog database.


I meant RMAN catalog which is in the database control file.

From your first output, failed backup piece (channel t2) would contain files 27, 4, 34 and 7,
they are not in your above LIST command output, so I think the failed backup piece is indeed
not in your RMAN catalog. Same thing for the channel t1 backup piece that was aborted by RMAN
and would contain files 32, 39 and 24.

The other previous backup pieces are there as they are valid for a restore.

[Updated on: Wed, 25 June 2014 13:06]

Report message to a moderator

Previous Topic: Rman backup gives error message RMAN-00554
Next Topic: know the size of our database backup file
Goto Forum:
  


Current Time: Fri Mar 29 09:04:40 CDT 2024