Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: What are the common mistakes DBA do retarding backup & Recovery?

Re: What are the common mistakes DBA do retarding backup & Recovery?

From: Alex Gorbachev <ag_at_oracloid.com>
Date: Thu, 5 Jul 2007 19:32:15 -0400
Message-ID: <c2213f680707051632u96a408bg3fbae6bc0b9386b4@mail.gmail.com>


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-l
Received on Thu Jul 05 2007 - 18:32:15 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US