Re: No data is salvable from inside the block
- From: David Sharples <davidsharples@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Tue, 14 Dec 2004 10:18:42 +0000
No I mean a backup, if you dont backup after each nologging operation
then you will lose data and en up with corrupt blocks, could be a hot
or cold backup - whatever.
You have no archivelog mode with force logging if you want.
My suggestion is to go for archivelog mode with force logging doing
hot backups then you dont have to worry about it again
On Tue, 14 Dec 2004 11:14:29 +0100, Francesco.Borgoglio@xxxxxxxxxx
<Francesco.Borgoglio@xxxxxxxxxx> wrote:
>
>
> When you talk about taking a backup after everything i do,
> you mean a cold backup?
> I would like to understand,
> to have consistent db restore, with no corrupted blocks,
> i must choose between a complete archivelog mode
> (with the force logging as you suggest and consequent hot backup)
> and a noarchivelog mode
> (and consequent cold backup or export i suppose).
> Do i have no other choice, it seems to me...
> Thank you very much.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
