Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Hot Standby questions on nesting Alter tablespace begin backup's
Svend Jensen <Master_at_OracleCare.Com> wrote in message news:<3C89FAAA.8050209_at_OracleCare.Com>...
> Bob wrote:
>
> > Is it permissible to nest the following:
> >
> > alter tablespace <table 1> begin backup
> > alter tablespace <table 2> begin backup
> > ...
> > alter tablespace <table 2> end backup
> > alter tablespace <table 1> end backup
> >
> > What I do in the middle is not lengthy, I'm doing a
> > disk mirror suspend. I need to have a complete but
> > consistent set of tablespaces, control files, and
> > logs so that I can recover from this set in the
> > event of a disaster.
> >
> > TIA
> >
> > Bob
> >
> > PS Sorry if this hits the news group twice: stuttering pinky finger
> >
>
> You can set all tablespace in begin backup mode, then suspend the
> database, break the mirror, set tablespace back in normal mode.
> The command is ALTER SYSTEM SUSPEND, and ALTER SYSTEM RESUME.
> Check the doc on suspend/os-system backup.
>
> /Svend Jensen
Thanks all,
Bob Received on Tue Mar 12 2002 - 01:12:55 CST