Re: Online backup: Backup online redologs?

From: Christian Hartmann <c.hartmann_at_tmp-office.de>
Date: Tue, 27 Mar 2001 16:23:38 GMT
Message-ID: <3ac0bdf3.26814567@news.ewetel.net>

On Tue, 27 Mar 2001 10:16:48 -0500, Vikas Agnihotri <onlyforposting_at_yahoo.com> worte:

>1. Backup each tablespace by putting it in backup mode
>2. Backup the archived redologs (and optionally delete them to save
>space)
>3. Backup the controlfile using ALTER DATABASE BACKUP CONTROLFILE
>
>Why is there no mention of the online redologs? During BEGIN BACKUP,
>arent the changed blocks written to the online redologs (in addition
>to the datafiles themselves)? So, if my entire backup is over before
>the online logs cycle, my online backup will be missing the changes
>generated during the backup since they are present only in the online
>redologs, right? What am I missing?
>
>And if the online redologs should indeed be backed up, shouldnt there
>be a BEGIN BACKUP for them as well since they are in a state of flux?

Well just do a "switch logfile" after backuped the datafiles of any tablespace. Thus, you don't need to backup the online redo-logs. Just the archive redo-logs.

Bye,

Christian Hartmann Received on Tue Mar 27 2001 - 10:23:38 CST