Re: Backup of Oracle databases

On Tue, 18 Jun 1996 17:32:05 GMT, simon_at_openplus.co.uk (Simon Fawkes) wrote:
>I need some information about backing up Oracle databases. I want to
>perform a file level backup of an oracle database whilst the database
>is running. Whilst this backup is being performed there will be no
>updates. Is there anyway of locking the database so no updates can be
>performed but reads are still allowed. If there is is this a safe way
>of performing the backup.
>
>TIA
>
>Simon Fawkes
>

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........
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.

During th backup period, the database can be safely used for updates/selects and so on.

hilsen jan Received on Tue Jun 18 1996 - 00:00:00 CEST