Re: hots/cold backup script for 9i on linux
Date: Thu, 10 Jan 2008 05:17:16 -0800 (PST)
On Jan 10, 3:07 pm, "fitzjarr..._at_cox.net" <fitzjarr..._at_cox.net> wrote:
> On Jan 10, 5:01 am, ton de w <ton_de_win..._at_yahoo.co.uk> wrote:
> > Hello,
> > Anyone care to reccommend a backup script for a cold backup (db shut
> > down) for 9i on Redhat?
> > Also a script for a hot backup (archivemode on).
> > TIA
> > Ton
> I'd recommend strongly you familiarize yourself with RMAN for the hot
> backup strategy.
> As for your cold backup you could:
> alter database backup controlfile to trace;
> then edit that script to provide the file names to back up. Add to
> that list your controlfiles from the init.ora and write your own cold
> backup script. Since you should be making a backup of your
> controlfile every time you add a new datafile you'll have a current
> file list to base a cold backup script upon.
> Others may have differing opinions.
Why not use RMAN for the cold backup as well? (And not avoid this error-prone hassle with the controlfile trace?) Received on Thu Jan 10 2008 - 07:17:16 CST