Re: Hot backup question
Date: Fri, 24 Sep 2010 17:56:57 -0600
Message-ID: <4C9D3AC9.1000504_at_optimaldba.com>
Data is still being written to the datafiles while the tablespace is in hotbackup mode. The main change is that the redo written for any table/index in a tablespace in hot backup mode is not just the redo vector, but the whole block. This prevents split blocks causing unrecoverability. The impact is primarily seen in increased i/o (both in redo and the backup process) competing for system resources.
On 09/24/2010 04:49 PM, Blanchard, William G wrote:
>
> Having spent all of my time using RMAN for backup/recovery, I find
> myself at a disadvantage when it comes to hot/cold backups. My
> questions is, what is the impact on users during a hot backup? My
> guess is that either the DB Writer doesn't write to the tablespace
> while it's in backup mode but resumes writing when the tablespace is
> taken out of hot backup mode. Can anyone clear up my confusion?
>
> Thank you,
>
> WGB
>
> _____________
>
> The information contained in this message is proprietary and/or
> confidential. If you are not the intended recipient, please: (i)
> delete the message and all copies; (ii) do not disclose, distribute or
> use the message in any manner; and (iii) notify the sender
> immediately. In addition, please be aware that any message addressed
> to our domain is subject to archiving and review by persons other than
> the intended recipient. Thank you.
> _____________
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Sep 24 2010 - 18:56:57 CDT