Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Backup RMAN on disk and tape at the same time
Jerome,
>>*only in the first case* will this backup to tape be known to RMAN Maybe we are disagreeing on semantics, but I agree RMAN doesn't about any backup moved from the original location...put it back though, in=20 the right place and RMAN *remembers* it, like it never left...agreed? So it is a matter of "who" and "how" it is got from tape. Other than the DBA's on this list :o) most DBA's trust their SA to restore files from tape...then the DBA begins to RESTORE.
>>RMAN backupsets to disk...then removed >>require to mark these backupsets as 'UNAVAILABLE' >>wouldn't be in sync with reality otherwise.
No sure about "required"...a simple "maintenance channel"=20 and some "crosscheck"ing would *find* the backupsets as=20 missing and update the controlfile and catalog accordingly.
I would bet 9 out of 10 DBA's that "RMAN Backup to Disk" never "RMAN Delete" those backups...they user "$> rm" in their RMAN shell scripts do I.
However, I did delete all my own backups from tape when using=20 Tivoli TSM/TDPO. The SA refused to delete/expire/purge Oracle=20 backups going directly to tape (they would expire anything=20 from filesystem backup...go figure?).
I had to figure out in my own scripts and RMAN commands what=20 backup to keep/retain...my RMAN and controlfile were in sync as you explained.
Back in early days I asked an author of a well know RMAN book=20 about deleting RMAN backup from Tape/MML". His response=20 "why do you want to do that...just have the MML expire your backup(sets)".
My point, most DBAs don't spend enough time on backups... ...even fewer spend any time on correctly deleting backupsets... ...you are one of the few.
Chris
-----Original Message-----
From: Vitalis [mailto:vitalisman_at_gmail.com]=20
Sent: Friday, April 22, 2005 1:06 PM
To: Marquez, Chris
Cc: lucdemanche_at_gmail.com; oracle-l_at_freelists.org
Subject: Re: Backup RMAN on disk and tape at the same time
On 4/22/05, Marquez, Chris <CMarquez_at_aarp.org> wrote:
>=20
>=20
The "resulting backup" in my original sentence refered to the backups to tape in both cases. And *only in the first case* will this backup to tape be known to RMAN (as your next sentences rightly explained.) Moreover RMAN backupsets to disk backed up with TSM and then removed would require to mark these backupsets as 'UNAVAILABLE' since the control file/RMAN catalog wouldn't be in sync with reality otherwise. With "BACKUP BACKUPSET..." the corresponding steps are somewhat automated thanks to the option "... DELETE ALL".
Jerome
> just that one will be known (to be) on tape
> and the other will be known (to be) on disk (that has been copied to=20
> tape...I realize RMAN knows nothing of this copy to tape)
>=20
> Just becomes a matter of how "who" and "how" to it off/back from tape.
>=20
>=20
>=20
>=20
>=20
>=20
> > my backupset to tape.
> >
> > backup backupset completed after 'sysdate-1';
> >
> > It's fine ...
> >
> > Luc
> >
> > On 4/21/05, Vitalis <vitalisman_at_gmail.com> wrote:
> > > On 4/21/05, Luc Demanche <lucdemanche_at_gmail.com> wrote:
> > > > Hi,
> > > >
> > > > Oracle 9.2.0.4 and Tivoli.
> > > >
> > > > My RMAN backups are running fine since few months. We just=20
> > > > bought=3D20 the agent for Tivoli.
> > > >
> > > > I would like to know is someone tried to create there RMAN=3D20=20
> > > > backupsets either on disk and tape in the same time?
> > > >
> > > > Thank you
> > > >
> > > > Luc
> > > > --=3D3D3D20
> > > > Luc Demanche
> > > > Oracle DBA
> > > > (514) 867-9977
> > > > --
> > > > http://www.freelists.org/webpage/oracle-l
> > > >
> > >=3D3D20
> > > Hi Luc,
> > >=3D3D20
> > > Do you mean: simultaneously write each backup piece to disk and to
> > >=3D20 tape? Some sort of backup duplexing to 2 different media =
types?
> > >No, =3D20 that's not possible. =3D3D20 Regards, Jerome
> > >=3D3D20
> >
> > --=3D3D20
> > Luc Demanche
> > Oracle DBA
> > (514) 867-9977
> > --
> > http://www.freelists.org/webpage/oracle-l
> > --
> > http://www.freelists.org/webpage/oracle-l
> >
>
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Apr 22 2005 - 14:30:51 CDT