Re: Backup

thanks, for the quick replay.
But first of all, we know about the general problem of not being able to do a
cold backup while the service is running therefore the database is also backed up using exp80 with full option.
So it is not as bad as it first sounded. The question though is, since our customer uses Seagate backup exec, is this tool able to do a proper backup
while the db is running as it says? Of course there is always the possibility of setting up a job which shuts down the orcl service using the svrmgr30 before performing a cold backup. Or do we need a special agent for backup exec which brings the tablespaces in backup mode?.

Christian

Sybrand Bakker <postbus_at_sybrandb.demon.nl> schrieb in im Newsbeitrag: 958808881.22474.0.pluto.d4ee154e_at_news.demon.nl...
> 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