Re: Slow 'alter tablespace begin backup'

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Fri, 19 Dec 2003 08:44:30 -0000
Message-ID: <brudpn$m65$1$8302bc10@news.demon.co.uk>

Whoops, Sorry,

Absolutely right - the TX lock is relevant to

alter tablespace read only
not to begin backup.

It's only the tablespace checkpoint that applies to begin backup.

-- 
Regards

Jonathan Lewis
http://www.jlcomp.demon.co.uk

  The educated person is not the person
  who can answer the questions, but the
  person who can question the answers -- T. Schick Jr


One-day tutorials:
http://www.jlcomp.demon.co.uk/tutorial.html


Three-day seminar:
see http://www.jlcomp.demon.co.uk/seminar.html
____UK___November


The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html


"Igor Laletin" <ilaletin_at_usa.net> wrote in message
news:f9226414.0312181858.618e12f6_at_posting.google.com...


>

> 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 Fri Dec 19 2003 - 02:44:30 CST