Re: Oracle Ver 7 backup/recover question

In article <1994Jul18.165537.11418_at_nb.rockwell.com>, frank_at_osreq151.rockwell.com(Frank Stevi) writes:
> We have just installed Oracle Ver 7 on an HP 9000. We are taking online backups of
> our Oracle tablespaces. Can an incomplete recovery (to time or to cancel) be done using
> our online backups? Also, our online backups currently include all tablespaces in the
> database except for the rollback segment tablespace. Should rollback tablespace be
> included in the online backup scenario?
>
> Thanks....

I am assuming that the procedures on an HP are similar to those on a VAX or a Sun machine.

Online backups can be used to recover a database to a particular point in time. Note that you MUST make sure that you are doing the backup correctly. If there is not a lot of activity going on in the database during the backup, the easiest thing to do is:

0. Archiving MUST be turned on for the database.

1. Set BEGIN BACKUP for all tablespaces (including the rollback segment tablespace)
2. Backup the database files using the operating system
3. Set END BACKUP for all tablespaces
4. Switch the log file (ALTER SYSTED SWITCH LOGFILE)
5. Spool a listing of the datafiles to the archive location
6. Backup the control file to the archive location
7. ALTER DATABASE BACKUP CONTROLFILE TO TRACE.
8. Copy the alert.log to the archive location
9. Backup the archive location to tape. This location now includes any redo log files generated during the backup, as well listings that will be helpful during a recover

-- 
Bob Swisshelm                | swisshelm_at_Lilly.com     | 317 276 5472
Eli Lilly and Company        | Lilly Corporate Center  | Indianapolis, IN 46285