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: 9i dataguard - do I need to restart the primary DB ?

Re: 9i dataguard - do I need to restart the primary DB ?

From: EdStevens <quetico_man_at_yahoo.com>
Date: 8 May 2007 09:24:11 -0700
Message-ID: <1178641451.171791.288260@e65g2000hsc.googlegroups.com>


On May 8, 11:14 am, Neil Cudd <neil.c..._at_blueyonder.co.uk> wrote:
> On 8 May, 16:01, sybrandb <sybra..._at_gmail.com> wrote:
>
>
>
> > On May 8, 4:51 pm, Neil Cudd <neil.c..._at_blueyonder.co.uk> wrote:
>
> > > Hi there.
>
> > > Oracle 9207 ent.ed on AIX 5L
> > > Is there any way of setting up dataguard with a remote standby server
> > > without restarting the promary instance ?
>
> > > We don't have the necessary downslot but want to set up a standby
> > > database.
>
> > > Many thanks for any help,
> > > Neil.
>
> > If you follow the documentation, you'll see you don't need to restart
> > the primary instance.
> > Make a hot backup using RMAN
> > Make a backup of your controlfile for standby
> > set up your standby database
> > duplicate your database for standby using RMAN
> > Except for sitting down during a prolonged period of time waiting,
> > this is all there is to it.
>
> > --
> > Sybrand Bakker
> > Senior Oracle DBA
>
> this may seem a sill y question - but what if you are not backing up
> using RMAN ?
> Thanks,
> Neil.

Then you've got bigger problems. Why would anyone NOT use rman? *ESPECIALLY* when in a DataGuard configuration? Received on Tue May 08 2007 - 11:24:11 CDT

Original text of this message

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