Re: Hot and Cold backups

> > Hi,
> >
> > Here what is your archive mode? Is it noarchivelog? If it is noarchive
> > then you need to restore all the cold backup and that's all ...so you
> > lose one day worth of data.
> >
> > Now if it is archivelog then you need to restore and then recover
> > database by applying the archivelogs so you will NOT lose any data, if
> > you have preserved all your archive logs....
> >
>
>
> You will loose whatever transactions are in the (now dead/broken/lost)
> active redo logs.
> Having a backup of the online redo logs will not help as they contain
> transactions from yesterday.
> Just open resetlogs. You cannot recover past the last archivelog, or the
> last unarchived online log (not current) that may still be available on your
> disk.
>

one thing that has always confused me is the ALTER DATABASE CLEAR LOGFILE command. If it is for clearing corrupt logfiles, you will not be able to archive those log files. Wouldnt Oracle crash? Wouldnt you require a partial recovery followed by resetlogs after a logfile goes corrupt. Why do you need to have the command CLEAR LOGIFLE? If it is corrupt isnt the database screwed.

Can someone explain when to clear an archived and/or unarchived logs vs do a partial recovery with open resetlogs? Received on Tue Jul 12 2005 - 19:51:57 CDT