Re: Hot Backup

In our last gripping episode kfrendo_at_bvb.gi (Kelly-Anne Frendo) wrote:
>
> From what I understand,
> it's BAD BAD BAD to back up online redo logs when doing a hot backup.
>
> I think it's okay when doing a cold backup though.
>
> However, you say you are switching log file and then backing up the
 control
> file. I don't understand if this is necessary. Don't you only have to
 back
> up the control file after structural changes are made to the
 database? Any
> suggestions to clarify this point in my head woule be greatly
 appreciated.
>
> Kel.
>
> --
> Posted from stan.gibnet.gi [195.166.192.3]
> via Mailgate.ORG Server - http://www.Mailgate.ORG
>

Since the control file also contains the current log sequence number and checkpoint information the control file is constantly changing. Also, depending upon the value for control_file_record_keep_time the data in the control file relative to redo/archive logs will change. Backup up the control file with a hot backup seems to be a pretty reasonable thing to do.

--
David Fitzjarrell
Oracle Certified DBA


Sent via Deja.com
http://www.deja.com/