Re: Backup and Recovery

If you are running in noarchivelog mode, backup and restore is possible; but recovery is not possible.

The best you can do is backup all the files with the instance shut down.

In the event of a failure, you can restore your backup.

But since you have no archived logs, you cannot then recover.

You lose all the transactions since that last backup. Are your users keeping track of all their input so they can re-enter it?

If this is understood and acceptable to your users, so be it. But most users think we are fully protecting them against this kind of loss.

lauracampos_at_yahoo.com wrote:

> My company wants me to create some backup and recovery procedures for
> our server. Our server has Oracle8 Enterprise Edition 8.0.5.0.0 for
> Windows NT 4.0. We will be backing up three instances to tape and are
> currently running in noarchivelog mode. I wanted to know if there is a
> backup and recovery procedures template that I could use as a guideline.
> If anyone has a template please email me at: camposlm_at_navair.navy.mil.
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
Received on Thu Jul 01 1999 - 20:59:16 CDT