Re: Suggestions please

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Mon, 19 Apr 2004 12:19:49 +0000 (UTC)
Message-ID: <c60g55$o8q$1@hercules.btinternet.com>

It seems to be a low-complexity option that gives a very short down-time.

    Take hot backup
    Ship outstanding archived logs
    Start recovery
    Stop primary
    Ship last bit of redo log
    Startup.

I don't think I'd even bother to fiddle about with a 'proper' standby for just 20 GB.
e.g. I'd probably do the hot backup by:

    alter tablespace begin backup
    ftp files in tablespace
    alter tablespace end backup

(generated from the db of course)

I might practise the steps a couple of times, before doing the production switch, though.

-- 
Regards

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

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

April 2004 Iceland  http://www.index.is/oracleday.php
June  2004      UK - Optimising Oracle Seminar
July 2004 USA West Coast, Optimising Oracle Seminar
August 2004 Charlotte NC, Optimising Oracle Seminar
September 2004 USA East Coast, Optimising Oracle Seminar
September2004 UK - Optimising Oracle Seminar

"Howard J. Rogers" <hjr_at_dizwell.com> wrote in message
news:4083b94e$0$4544$afc38c87_at_news.optusnet.com.au...


> Jonathan Lewis wrote:

>

> > How using standby database methods ?

> >

>

> I thought about that (well, I had the idea of using logical standby a la

> Data Guard). Still seems overkill.... but if it gets your vote, it's

> worth pursuing.

>

> Regards

> HJR

Received on Mon Apr 19 2004 - 07:19:49 CDT