Re: Backup stuff

From: Venkat <vreddy_at_ix.netcom.com>
Date: Tue, 12 May 1998 15:46:23 -0400
Message-ID: <6ja8uv$4ul@dfw-ixnews10.ix.netcom.com>

Oracle suggests that redo logs should not be backed up as part of a hot backup and that restored redo logs might cause data corruption in some cases. Switching logs and then backing up the archived logs is the preferred way. If you lose the online logs the worst case scenario would be doing an incomplete recovery (open resetlogs) which means that you'd lose the data in the online logs

HTH
Venkat

>I've been told that the redologs files should not been backuped, and a
>preferable solution is to do some 'alter system switch log file' to
>force those redologs to be archived.
>
>What do you think of that and what happens if I do not backup the redo
>logs and if I lost them !!
Received on Tue May 12 1998 - 14:46:23 CDT