Re: DBA vs SysAdmin

li siyan wrote:
>
> Jensen Langford - Sun UK - Contractor (jensen.langford_at_uk.sun.com) wrote:
>
> : that when this backup runs, the database is in a consistent state thus
> : enabling a valid file set. This is normally achieved by shutting the
> : database down prior to the backup. If the database is running when the
> : backup is taken, it is unlikely a recovery will be possible.
>
> Directly copy the database files to a tape? Is it a valid backup? Is there
> any guarantee that this will work? And if this really works, what does
> transaction log used for?
>
> Siyan

I assuming your talking about backing up with the database in ArchiveLog mode? Backing up the database files to tape is perfectly valid (assuming you drive dosen't die mid-backup and stop Log Writer)... Received on Thu Mar 27 1997 - 00:00:00 CET