From: The Tentative DBA.... Newsgroups: comp.databases.oracle.server Subject: Re: Hot Backup Date: Fri, 02 Feb 2001 16:55:17 GMT Organization: Deja.com Lines: 41 Message-ID: <95eopf$7bf$1@nnrp1.deja.com> References: <95el51$3k7$1@nnrp1.deja.com> NNTP-Posting-Host: 193.95.165.163 X-Article-Creation-Date: Fri Feb 02 16:55:17 2001 GMT X-Http-User-Agent: Mozilla/4.0 (compatible; MSIE 4.01; Windows NT) X-Http-Proxy: 1.1 x68.deja.com:80 (Squid/1.1.22) for client 193.95.165.163 X-MyDeja-Info: XMYDJUIDmick_rice Asish, Whether you need to back-up your archive logs or not depends on what your restore requirements are. If your only current backup strategy is to do daily hot backups of the database, it looks to me that you do also need to backup your logfiles to tape or to another disk at least. If your logfiles become corrupt or go missing and you have no cold backup of the database, you're completely stuffed. If some of your redo logs are corrupt/lost you'll obviously be able to restore along the sequence of logs until you hit the corrupt/missing file. Perhaps the best advice would be to vary your backup strategy by doing a full offline backup at weekends and hot backups each day during the interim. In this way you can reasonably hope to avoid building up huge collections of archived log files, Good Luck, Mick. In article <95el51$3k7$1@nnrp1.deja.com>, ashish25@my-deja.com wrote: > Hi, > I take a hotbackup daily and make a backup of the controlfile after > doing alter system switch logfile; > My question is I don't take a backup of redo logs.I have them > mirrored and everything.Should I take a backup of redo logs also. > If the current member of redo logs get corrupted how is the > recovery done. > Regards, > Ashish > > Sent via Deja.com > http://www.deja.com/ > -- If it isn't backed up, it's not worth shit ! Sent via Deja.com http://www.deja.com/