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

On Jan 10, 12:37 pm, ton de w <ton_de_win..._at_yahoo.co.uk> wrote:
> On 10 Jan, 16:49, gazzag <gar..._at_jamms.org> wrote:
>
>
>
>
>
> > On 10 Jan, 15:39, ton de w <ton_de_win..._at_yahoo.co.uk> wrote:
>
> > > 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?- Hide quoted text -
>
> > Is the partition that your USER_DUMP_DEST directory sits on full?
>
> > HTH
>
> > -g- Hide quoted text -
>
> > - Show quoted text -
>
> good question - no
> [r..._at_carboninit.d]# df -k
> Filesystem           1K-blocks      Used Available Use% Mounted on
> /dev/sda3             63629636  15697444  44699916  26% /
> none                   1027572         0   1027572   0% /dev/shm
>
> quite right one disk and one partition is a bit strange - just
> temporary I hope!- Hide quoted text -
>
> - Show quoted text -

Can you actually write to that directory as the 'oracle' user?

David Fitzjarrell Received on Thu Jan 10 2008 - 13:50:38 CST