Re: backing up??

From: Demon <george_at_onest.demon.co.uk>
Date: Thu, 26 Aug 1999 22:37:15 +0100
Message-ID: <935703370.28108.0.nnrp-03.c2de0af6@news.demon.co.uk>

There are 2 main types of backups
1) a physical backup of the database files the simplest is to shut down the database (shutdown normal or immediate is preferable) and then backup the datafiles, redo logs, control files, init.ora file ( this is a cold backup)

if you're running NT, also stop the Oracle start, and OracleService NT services otherwise I think you wont get a good backup of your database control files.

2) a logical backup (ie a database export.

You would be advised to take both physical and logical backups on a regular basis and to periodically do a test recovery from your backups.

jesper jorgensen wrote in message <37C536ED.EE17E502_at_blueberry.co.uk>...
>hi,
>
>can anyone advice on what the simplest method of backing up/exporting
>is??
>
>thanks
>
>jesper
>
>
Received on Thu Aug 26 1999 - 16:37:15 CDT