Re: Why is on-line backup one tablespace a time?

From: Dino Hsu <dino1_nospam_at_ms1.hinet.net>
Date: Mon, 27 Aug 2001 08:50:41 +0800
Message-ID: <4m5jotc2v1rfe1ldspd369nphtmbfa2h6f@4ax.com>

On Mon, 27 Aug 2001 06:00:52 +1000, "Howard J. Rogers" <howardjr_at_www.com> wrote:

>snip
>
>Provided you retain all redo from the time the *first* tablespace went into
>hot backup mode, the fact that your backup copies are not from the same
>timeslot is irrelevant for the purposes of recovery.
>
>Regards
>HJR
>

Do you mean that the backup of datafiles + online redo logs will do for recovery even there are time-difference among the backed-up tablespaces? In terms of transaction management or SCNs, please explain why this is recoverable? On the other hand, as long as redo logs are not backed up, the database is still unrecoverable. How can redo logs be backuped up without the instance down? (In the control file case, 'alter database backup controlfile' will do on-line backups)

One practical question: do you do this in batch with a script or do it interactively? Thanks again.

Dino Received on Sun Aug 26 2001 - 19:50:41 CDT