Re: hots/cold backup script for 9i on linux
Date: Thu, 10 Jan 2008 10:37:11 -0800 (PST)
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 18.104.22.168.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?
> -g- Hide quoted text -
> - Show quoted text -
good question - no
[root_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! Received on Thu Jan 10 2008 - 12:37:11 CST