Re: hots/cold backup script for 9i on linux

On 10 Jan, 13:39, "fitzjarr..._at_cox.net" <fitzjarr..._at_cox.net> wrote:
> On Jan 10, 7:17 am, vitalis..._at_gmail.com wrote:
>
>
>
>
>
> > 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.
>
> > Sure. ;o)
> > Why not use RMAN for the cold backup as well? (And not avoid this
> > error-prone hassle with the controlfile trace?)- Hide quoted text -
>
> > - Show quoted text -
>
> I presumed the OP would, upon familarising himself/herself with RMAN,
> discover this and thus use RMAN as a better alternative for both
> backup strategies.  Especially when editing a controlfile trace.might
> be daunting to someone with his/her lack of experience.
>
> David Fitzjarrell- Hide quoted text -
>
> - Show quoted text -

Thanks David and Vitalis for your input. I would like to be familiar with RMAN - and good advice to do so. But I really need to do a cold backup today and a hot backup today. RMAN for hot and cold seems good to me.
in the meantime I have ried and failed to do a alter database backup controlfile to trace <sigh>
[oracle_at_carbon oracle]$ sqlplus /nolog

SQL*Plus: Release 9.2.0.4.0 - Production on Thu Jan 10 16:34:09 2008

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

SQL> connect / as sysdba
Connected.
SQL> alter database backup controlfile to trace;

which just hangs
Have I missed out an obvious step? Received on Thu Jan 10 2008 - 09:39:07 CST