Re: "host ocopy..." runs in the background, why?

I found it in SQLPLUS 3.3 - I have the same scripts running on a 8.0.5 and a 8.1.6 (test) DB , but I stayed with using svrmgr just to be safe. Perhaps if I get time I'll try running it from SQL*PLUS and see what happens.

I would prefer to use SQL*PLUS on its own as I need to incorporate both for my online backup scripts as svrmgr will not spool the .sql created files properly.

"Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in message news:980hn9$p5b$1_at_soap.pipex.net...
> what version of sqlplus/oracle does this drawback apply to. We use 8.1.6
 and
> I haven't noticed this problem. however I would hate to find it in a live
> emergency.
>
>
> --
> Niall Litchfield
> Oracle DBA
> Audit Commission UK
> "Glen A. Sromquist" <stromqgl_at_alpac.ca> wrote in message
> news:zEOo6.12259$pF4.2369708_at_news1.telusplanet.net...
> > I assume you are running it from SQL*PLUS, I had the same problem with
 my
> > online backup, it would put the tablespace back online before it was
> > finished copying the file.
> >
> > If you run the script from svrmgr instead of sqlplus this will not
 happen
> >
> > HTH
> >
> >
> >
> > "Peter Naslund" <pnaslund_at_algonet.se> wrote in message
> > news:5Gso6.16726$Qb7.2749913_at_newsb.telia.net...
> > > I have scheduled this backup script:
> > >
> > > alter tablespace SYSTEM begin backup;
> > > host ocopy73 D:\ORCL\SYS.ORA F:\ORCL\Backup\SYS.BCK
> > > alter tablespace SYSTEM end backup;
> > >
> > > The problem is that "host ocopy73..." starts copying in the
 background.
> > > "..end backup" is therefore reached instantly and results in a fuzzy
 backup
> > > file.
> > >
> > > Why is that?
> > >
> > > Thanks,
> > >
> > > Peter Naslund
> >
> >
>
>
Received on Mon Mar 05 2001 - 11:56:16 CST