Re: Backup methods

From: Howard J. Rogers <dba_at_hjrdba.com>
Date: Sat, 30 Mar 2002 06:22:57 +1100
Message-ID: <a82f0s$n1d$1@lust.ihug.co.nz>

Hi Tom,

Visit my site mentioned below. Have a look at Tips/Backup and Recovery page. Then have a look at the Books page, where my teaching notes for Backup and Recovery are downloadable. Might help get you started.

Regards
HJR

--
------------------------------------------
Resources for Oracle : www.hjrdba.com
============================


"Tom Brown" <tom_at_eazyriders.com> wrote in message
news:2_Yo8.6377$tI6.45100144_at_news-text.cableinet.net...


> Hi,

>

> Being quite new to oracle on a DBA front I'm after some advice. How should

i


> be keeping a backup of the database? At the moment i do a nightly export

of


> the database on a per user basis. These are written and zipped into a

> directory. It cycles 'round so at any one time i have the last 3 days

> exports. I have only had to recover one user in the past due to data

> corruption and this export has proved very effective. I do have the

> instances in archive log mode but to be fair i have no idea how to apply

> archive logs to a recovered database to bring it back to a point i time. I

> just rely on the export and then if a problem arises nuke the user,

recreate


> it and import from the export... Is this a very bad thing to be doing? I

> suspect that although 'it works so why fix it' I'm doing something

> fundamentally against what is thought to be the correct approach to back

and


> recovery.

>

> any comments appreciated....

>

> Tom

>

> BTW this is not a database linked in anyway to financial transaction if

that


> makes any difference to the approach taken.

>

>

Received on Fri Mar 29 2002 - 13:22:57 CST