Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Slow 'alter tablespace begin backup'

Re: Slow 'alter tablespace begin backup'

From: Igor Laletin <ilaletin_at_usa.net>
Date: 18 Dec 2003 18:58:12 -0800
Message-ID: <f9226414.0312181858.618e12f6@posting.google.com>


"Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote in message news:<brt18i$koq$1$8302bc10_at_news.demon.co.uk>...
> There are two possible waits with setting a
> tablespace into backup mode. The first
> is that it can't be done until all current
> transactions on the database have completed
> (although new ones can start).

Are you sure about this? It would be very difficult to make hot backups if any long running transaction could block 'begin backup'.

I just tried in 8.1.7:
- in session1 started a transaction (deleted a record from a table) - in session2 'alter tablespace begin backup' and it worked straight away.

> --
> Regards
>
> Jonathan Lewis
> http://www.jlcomp.demon.co.uk

Regards,
Igor Received on Thu Dec 18 2003 - 20:58:12 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US