Re: Backup and Recovery

In article <7lgbpe$l0e$1_at_nnrp1.deja.com>, 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.

I've so far seen one good response to this and a couple of "bad" ones...

Without archive logging you can't really "recover", only "restore". That means that everything since the cold backup was done is lost - forever.

Export is quite different from a hot or cold backup. For one thing, you have to manually create the database before beginning an import. Without the consistent=Y option (which is NOT the default), the data may be inconsistent.

Backups are a critical and core function of the DBA. Make *SURE* you know exactly what you are doing, what the recoverability requirements are, and all the other important factors. This isn't something you are going to get enough reliable information about in a newsgroup to do well. It might get you started thinking about it right though. For the ultimate guide, see Velpuri's Oracle Press book "Oracle Backup and Recovery Handbook".

• OraSaurus --
• Remove "not_" to reply... --