Re: Backup

This means you are conducting a hot backup while the database is not in hot backup mode *AND* you are not running in archivelog! You will not be able to recover the database if something happens, while the database is in an inconsistent state (as not all backups are from the same point in time)
For a recoverable system you need
1 archivelog mode
2 either a cold backup (database down)
3 or a hot backup (bring individual tablespaces in backup mode). For this type of backup archivelog mode is mandatory. Please refer to the Oracle docs for further details.

Hth,

Sybrand Bakker, Oracle DBA

Uni Mannheim <cuske_at_rumms.uni-mannheim.de> schreef in berichtnieuws 8g5dp3$pu6$1_at_trumpet.uni-mannheim.de...
> Hello,
>
> We are using an Oracle 8.05 Server on NT Server, which is backed up every
> night. The backup tool (backup exec, Seagate) does also do a backup of the
> database files.
> In the logfile for the backup though it says that the main
> Oracle files have been active, but have still been backed up.
> Since the database is not operating in archive mode, I was wondering,
> whether the database files
> really are backed up and can be used after system-failure or if
> Backup exec just cannot tell and the databse needs to be shut down.
>
> Thanks in advance
> Christian
>
>
Received on Sat May 20 2000 - 00:00:00 CDT