Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Online Backup Doubt
Hi Ronald,
I've gone thru ur script. Understand that it executes the copy (dd) statement in OS shell environment, not within oracle. Guess it should be the way to do it.
Thanks
Augustine
Ronald Rood <devnull_at_ronr.nl> wrote in message news:<a0k3kj$7mh$1_at_cyan.nl.gxn.net>...
> kunjaathi_at_hotmail.com wrote:
>
> >Subject: Online Backup Doubt
> >From: kunjaathi_at_hotmail.com
> >Date: Fri, 30 Nov 2001 20:14:10 -0800
> >
> >2) I've this statement in my unix script(Solaris)
> >
> >Alter tablespace AJAPP begin backup;
> >host`cp /u01/datafiles/db/aj.dbf /bkp/datafiles/aj/aj.dbf`
> >Alter tablespace AJAPP end backup;
> >
>
> Augusitne,
> why don't you just download ora_backup.sh ? It does online backup for oracle 7, 8 and 9 and I tested it on Solaris and AIX. It's on http://ronr.nl/unix-dba in the scripts section. ora_backup.sh -tHOT -sYOUR_SID -d(/some/directory or device) -m
>
> Ronald.
> -----------------------------
> http://ronr.nl/unix-dba
> Ben je een ervaren oracle dba en wil je dat ergens anders laten zien, mail me dan.
Received on Sat Dec 29 2001 - 22:05:14 CST