Re: hots/cold backup script for 9i on linux
Date: Thu, 10 Jan 2008 07:39:07 -0800 (PST)
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 220.127.116.11.0 - Production on Thu Jan 10 16:34:09 2008
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
SQL> connect / as sysdba
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