Re: Backup Question

Hi,

I think he is saying the database is running in NOARCHIVELOG mode.

The assumption of a hot backup for a database in ARCHIVELOG mode is that archivelogs are applied to it to rollforward the data past the point of the online logs (as taken at backup time). Therefore the online logs are useless to a recovery of a database backed up online. With a cold backup, oracle wants the logs to be there so it can easily check if everything is in sync.

Andrew May,
Quest Software.

John P. Higgins wrote:
>
> Forgive an ignorant question, but what does it mean when 'media recovery
> is disabled for the database '?
>
> Dave B wrote:
>
> > I am reading an Oracle book which says:
> >
> > "[Offline database] backups of transaction log files are useful only if
> > media recovery is disabled for the database ... if media recovery is
> > disabled, offline database backups must always include backups of the
> > database's transaction log."
> >
> > OK, I think I understand why transaction log files are not required for
> > media recovery backups ('cause the transactions in the log files were
> > already applied to the data files prior to shutdown, right??) BUT isn't
> > this always the case - even if media recovery is turned off??
Received on Fri Feb 12 1999 - 01:02:50 CST