Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: What are the common mistakes DBA do retarding backup & Recovery?
Actually, I would encourage to use RMAN in conjuction with split
mirror backups. Splitted volumes can be registered as image copies
with RMAN and backed up to tape or disk storage + validated for
integrity at the same time.
With rman you would get one additional level of verification and
always up to date repository of your backups.
On 7/5/07, John Kanagaraj <john.kanagaraj_at_gmail.com> wrote:
> > 3. Afraid of using RMAN or Making benefits of RMAN
>
> I would like to challenge Pt 3 in the OP's list.
>
> It is NOT an issue if RMAN is NOT being used. There are databases that
> are hundreds of Gigs in size that are backed up from split mirror
> disks (Mirror database disks, place whole database in backup mode,
> split the mirror, take the database out of backup mode, switch the
> redologs, mount the mirror filesystems under a separate tree, transfer
> the new archivelog to the mirror's archivelog directory, backup the
> mirrors, and you are done). Although there is a cost (extra $$ for the
> mirror disks) there are some advantages:
>
> 1. You have a backup of the database online in the mirror (until at
> least the time you are ready to merge the mirrors back) - this has
> saved my behind in one specific case on a highly visible system. No
> mucking around with RMAN's MML and tapes or even a disk stage - just a
> straight copy of datafiles back into the original area)
> 2. You take the backup I/O away from Production datafiles (RMAN
> contends with the live datafiles)
>
> Backing up an Oracle database without regular scheduled restores (from
> tapes if possible) as well as NOT backing up the Application tiers
> along with the database are high in my list of common mistakes. Again,
> for SOX compliant organizations, this is usually an IT Control so many
> orgs have become better at this (one of the positive effects of SOX)
>
> --
> John Kanagaraj <><
> DB Soft Inc
> Phone: 408-970-7002 (W)
>
> ** The opinions and facts contained in this message are entirely mine
> and do not reflect those of my employer or customers **
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
-- Alex Gorbachev, Oracle DBA Brewer, The Pythian Group http://www.pythian.com/blogs/author/alex http://blog.oracloid.com BAAG party - www.BattleAgainstAnyGuess.com -- http://www.freelists.org/webpage/oracle-lReceived on Thu Jul 05 2007 - 18:32:15 CDT
![]() |
![]() |