Re: Hot Standby questions on nesting Alter tablespace begin backup's

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 Received on Sat Mar 09 2002 - 06:06:02 CST