Re: Backup of Oracle databases

Jan Grønlien wrote:
>
> If you are going to let users have access to the database during
> backup, you have to use online backup to get a consistent copy.....
>
> 1. Make shure your database is running in ARCHIVELOG.
> 2. Switch the tablespaces that you want to bacup into online backup
> state "alter tablespace data begin backup"
> 3. Backup the datafiles belonging to the tablespace.
> 4. Switch the tablespace back to normal use "alter tablespace data end
> backup"
> 5. Repeat 1-4 for each tablespace........

IMPORTANT MISSING STEP 5.1 Archive the currently active redo log "alter system archive log current". Durieng the recovery you will need the redo log which was being written at the time that tle last "end backup" was issued.

> 6. Backup all your archived redologs (They are needed together with
> the datafiles, to make a consistent restore+recovery of the database).
> 7. Make an offline backup once a week/month or whatever.
Received on Wed Jun 19 1996 - 00:00:00 CEST