Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: relation bet REDO LOG FILE and BEGIN BACKUP
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 DBAReceived on Tue Jul 11 2006 - 03:18:45 CDT