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:17:26 CST
