Re: Simple backup of an Oracle 8 server.

Ulrik,
The first question to ask is how much data do you need to back up? That will probably determine how you do the backup. If it's only a few hundred MB, can you close the database and do a 'cold' (operating system) backup? This is the safest and most reliable. If not, then you basically have to do a 'warm' (online) backup. If the only access is read only, this shouldn't be a problem and you could even do it in parallel if you wanted to put some time and effort in (or you could buy one of the many tools available).
If it's mirrored, some people break the mirror and do a cold backup on the 'off-line' mirror, and then re-silver (resync the mirror). I would recommend having a search through Oracle's web site for the Tip & Code archives - plenty of contributors have written scripts which will churn through and do some sort of backup, just make sure you check they work on your OS and Oracle release.

Good luck....
Richard

Ulrik Lunddahl wrote:

> Hey All!
>
> I want to make a backup of our Oracle server, my oracle skills is not the
> best.
>
> My idea is to make an export of the whole database at night, where there is
> no write trafic on the system, the only user at night is the web server and
> it only reading from the database.
>
> We can accept to be set 24 hours back if anything goes wrong.
>
> Is this a good idea, or should i figure something else, and mutch more
> complicated out.
>
> What do i need in addition to the full database export to get the database
> up and running on another server.
>
> --
> Kind regards
>
> Ulrik Lunddahl
> PROconsult Data A/S
> e-mail: ul_at_proconsult.dk
Received on Mon Aug 09 1999 - 09:07:28 CDT