Re: Backing up intro please

"Frank van Bortel" <fvanbortel_at_netscape.net> wrote in message news:cs5o22$ae1$1_at_news3.zwoll1.ov.home.nl...
> Joe wrote:

> What's your OS?

Windows XP

> Find out which files belong to your database; query
> datafiles, logs and controlfiles. Possibly tempfile,
> depending on the version of your oracle, and wither
> you use 'em or not.
> Shut down your instance; backup all files you found
> in the previous step, and the password file.

I don't like she sound of this "manual" way - too easy for me to miss something

> I assume you already have a backup of the oracle
> environment, or take it as a calculated risk not
> to backup, but reinstall.

Yes

> Or: fire up rman and backup database. rman
> allows for incremental backups; the above method
> is not.
>
> More details (lots of 'em...) on e.g. OTN
> (otn.oracle.com) or Dizwell (http://www.dizwell.com/html/backup.html)

OK thanks. I suppose what I'm really after some sort of step-by-step idiots guide to incremental backups and restore. Received on Thu Jan 13 2005 - 08:14:42 CST