| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| 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,
>> another DBA has to administer the database >>he might crosscheck and then delete these "expired" backups I agree 100%..."rm"ing *needed* backups that have been put to tape open the door for RMAN (crosscheck) issues.
>>Pheww, they must have Terabytes RMAN catalogs :-)
Who uses catalogs anymore, even Oracle puts little emphasis on them
anymore.
I do use them in a large/many db shop though, but I have needed to
RESTORE and RECOVER a database suing a RMAN catalog.
I have always been able to use the current or additional controlfile
backup "copy" (to disk) that I have.
>>Do you mean they refused to expire the TDPO backups in TSM?
>>If so that's absolutely normal!
Is it normal for the SA to expire my EXPort *.dmp on /myOracle/BackupDir
taken with a filesystem backup?
This is just as much an Oracle backup as my RMAN backup.
Why should my SA's retention beliefs only apply to TDPO backups.
My SA expiries Oracle files from tape all the time!
>> It seems you were using 8i..it is easier with RMAN 9i,=20 Have handled deletes for both versions, 8i much more challenging...non-existent.
>>That's not a SA task!
Sure it is. Just ask them.
Old shop SA on Legato used to expire all the Oracle backups from the EBU
days to the early 8.0 RMAN days.
Please tell me of any shop where you are not also the SA and don not
have root and you are *required* to expire Oracle files taken in the
filesystem backups...never happens.
Not saying you shouldn't with the use of a MML Agent, but lets not
pretend that the is the rule and not the exception between SA's, DBA's
and all (other) forms backup's to tape.
>>Nowadays this statement would be utterly foolish.
I guess...I think I see things as black and white to, but done really don't care if my controlfile still remembers a backup from two years ago, that has long since been "rm'ed from the OS/tape. Guess I don't share your desire to only know about "existing" backups. If I don't have a current backup during RESTORE time, having a controlfile or RMAN catalog that is clean of old non-existent backups is not really much comfort.
Again, good point about the removing of needed backups sent to tape.
Chris
-----Original Message-----
From: Vitalis [mailto:vitalisman_at_gmail.com]=20
Sent: Friday, April 22, 2005 3:47 PM
To: Marquez, Chris
Cc: oracle-l_at_freelists.org
Subject: Re: Backup RMAN on disk and tape at the same time
Hi again Chris,
On 4/22/05, Marquez, Chris <CMarquez_at_aarp.org> wrote:
> Jerome,
>=20
Yes we were disagreeing about the formulation I guess since our explanations seem to be the same =3D)
> So it is a matter of "who" and "how" it is got from tape. Other than=20
> the DBA's on this list :o) most DBA's trust their SA to restore files=20
> from tape...then the DBA begins to RESTORE.
>=20> >>require to mark these backupsets as 'UNAVAILABLE'
> >>RMAN backupsets to disk...then removed
>=20
The backup sets would be marked as "expired", but the flag "expired" in RMAN is NOT intended to be used for such temporarily missing backups. It can be risky because if another DBA has to administer the database without knowing this fact, and if he uses RMAN commands and flags the way they were intended to be used, he might crosscheck and then delete these "expired" backups (well, in fact, let's hope he will ask the rest of the staff before doing so :-) The correct way to tell RMAN that these backups are temporarily missing is to mark them as "UNAVAILABLE" and to mark them as "AVAILABLE" again after restoring them from tapes.
> I would bet 9 out of 10 DBA's that "RMAN Backup to Disk" never "RMAN=20
> Delete" those backups...they user "$> rm" in their RMAN shell scripts=20
> do I.
Pheww, they must have Terabytes RMAN catalogs :-)
> However, I did delete all my own backups from tape when using Tivoli=20
> TSM/TDPO. The SA refused to delete/expire/purge Oracle backups going =20
> directly to tape (they would expire anything from filesystem=20
> backup...go figure?).
Do you mean they refused to expire the TDPO backups in TSM? If so that's absolutely normal!
> I had to figure out in my own scripts and RMAN commands what backup to
> keep/retain...my RMAN and controlfile were in sync as you explained.
It seems you were using 8i. Of course you have to deal with the policy retention (it is easier with RMAN 9i, but with 8i some scripts under $ORACLE_HOME/rdbms/demo could help us with that). That's not a SA task!
> Back in early days I asked an author of a well know RMAN book about=20
> deleting RMAN backup from Tape/MML". His response "why do you want to=20
> do that...just have the MML expire your backup(sets)".
Nowadays this statement would be utterly foolish.
Cheers,
Jerome
>=20
>=20
>=20
>=20
>=20
>=20
>=20
> > tape...I realize RMAN knows nothing of this copy to tape)
> >
> > Just becomes a matter of how "who" and "how" to it off/back from=20
> > tape.
>=20> > restore commands at the RMAN prompt (even if it will require for=20
> >
> > Chris
> >
> > -----Original Message-----
> > From: Vitalis [mailto:vitalisman_at_gmail.com]
> > Sent: Friday, April 22, 2005 10:39 AM
> > 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
> >
> > Hi Chris,
> >
> > The main advantage of "backup backupset ..." (to tape) vs. TSM=20
> > backup of the backupsets is that the resulting backup will be known=20
> > in the control file/RMAN catalog. The administration of the backups=20
> > will be much
> > easier: one will be able to restore/recover files with simple=20
> > > get "backup of backupset" yourself using RMAN...guess I answered=20
> > > my own question...maybe?
> > >
> > > Chris
> > >
> > > -----Original Message-----
> > > From: oracle-l-bounce_at_freelists.org=20
> > > [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Luc Demanche
> > > Sent: Thursday, April 21, 2005 6:14 PM
> > > To: Vitalis
> > > Cc: oracle-l_at_freelists.org
> > > Subject: Re: Backup RMAN on disk and tape at the same time
> > >
> > > Vitalis,
> > >
> > > I guess I found something.
> > > I'm doing my regular backup on disk, and after I'm doing a backup=20
> > > of
>=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.
>=20
>=20> > >
> > > >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 - 16:31:28 CDT
 |
 |