Re: Cold Backups

howard wrote:
> Hi,
>
> I'm running 10g R2 on RHEL 3. I need to get my hands on a good
> coldbackup script or just instructions on how to do it.
>
> I want to be able to copy the vital directories to another location.
> What would those directories be?
>
> Thanks in advance for your help,
>
> Howard

Howard, I have to agree with the other posters here. Seriously, why would you want to use a cold backup with RMAN available? RMAN is an absolutely great utility.

I do want to point out one thing. One of the other posters mentioned how RMAN will backup your controlfile even if you don't tell it to, which is true. Something I've found is that you probably want a backup of the controlfile right at the very end of your RMAN backups as well.

Reason being that (at least in my limited experience), the RMAN backup sequence is usually:

backup the datafiles (a controlfile usually gets included here, I believe)
switch the current redologs to archivelogs backup the archivelogs (that now include whatever was in your redologs)

If you don't THEN do ANOTHER controlfile backup, I believe the end result is that the controlfile you backed up along with the datafiles in the beginning won't have a record of those last redologs that were switch to archivelogs AFTER your datafiles backup.

Just something to keep in mind. The end result would be that you lost the transactions in the redologs if you have to restore because RMAN doesn't backup redologs (at least in 8i/9i). Please correct me if I'm blatently wrong.

Charles R. Whealton
Charles Whealton @ pleasedontspam.com Received on Fri Jul 21 2006 - 19:51:32 CDT