Re: Hot Backups

In article <maxusCvppLr.2sp_at_netcom.com>, James H. Jackson <maxus_at_netcom.com> wrote:
>Quick question for anyone in the know. I am putting together a backup
>script to backup my oracle tables while the database is up. I am
>following the backup script in the oracle for unix technical reference
>guide. My question is: If my system tablespace only contains system
>tables do I also need to include this in the hot backups or is the once
>a week cold backup enough. Likewise with my rollback segment tablespaces
>and temporary tablespaces?
>
>Thanks in advance,
>Luke
>--
> maxus_at_netcom.com

If you're using the achive logger and keeping all your archived redo logs, you could get away with once a week (although I would be nervous doing so).

If you are NOT using the archive logger, then absolutely no way; never; do this at your peril. Oracle constantly updates the redo log id's in all its tablespaces. get two backups with different redo ids and no redo logs and recovery is next to impossible and data will certainly be lost (I know from bitter experience)

Stephen Received on Thu Sep 08 1994 - 03:28:06 CEST