Re: Backup stuff

From: <cmohan_at_iname.com>
Date: Tue, 12 May 1998 23:12:14 GMT
Message-ID: <6jal0d$evv$1@nnrp1.dejanews.com>

Redo log files are only used for instance recovery. While running noarchivelog,(you do cold backups) in case of a database crash, you can bring the database only up to the point in time you performed the back up. So redo log files are useless. If you are running in archivelog mode, backing up the redo logs is not required. The filled redo logs will be archived (either manually or by ARCH process) before they are reused. In this case, you may want to issue the 'alter system switch redo logfile', after you have backed up all the tablespaces.

So in either case (archivelog / noarchivelog), you donot have to backup the redo logfile!

Hope this helps,
CM

In article <35588CE0.E0868192_at_hotmail.com>, Pierre Feron <feronp_at_hotmail.com> wrote:
>
> Hello,
>
> 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 !!
>
> Thanks by advance !
>
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Tue May 12 1998 - 18:12:14 CDT