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

Home -> Community -> Usenet -> c.d.o.server -> Re: relation bet REDO LOG FILE and BEGIN BACKUP

Re: relation bet REDO LOG FILE and BEGIN BACKUP

From: sybrandb <sybrandb_at_yahoo.com>
Date: 11 Jul 2006 01:18:45 -0700
Message-ID: <1152605925.870552.276390@m79g2000cwm.googlegroups.com>

peter wrote:
> Hello DBAs,
>
> when we issue
> alter tablespace <tb_name> begin backup;
> what extra information go in redo log, why archive is fast and if there
> is shutdown abort why backup at that time is not useful........
>
> Because in books it was mentioned that archive is fast because all
> information of tablespace would go in redo log but even in simple way,
> everything goes in redo log so what extra..........

According to the documentation, begin backup forces Oracle *for every change* to write the complete block to redolog, instead of changed bytes only.

-- 
Sybrand Bakker
Senior Oracle DBA
Received on Tue Jul 11 2006 - 03:18:45 CDT

Original text of this message

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