> On 8 May, 16:01, sybrandb <sybra
@gmail.com> wrote:
> > On May 8, 4:51 pm, Neil Cudd <neil.c@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?
On May 8, 9:14 am, Neil Cudd <neil.c
@blueyonder.co.uk> wrote:
> On 8 May, 16:01, sybrandb <sybra
@gmail.com> wrote:
> > On May 8, 4:51 pm, Neil Cudd <neil.c@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
Standby databases need a standby control file. The key to doing it
without RMAN would be to generate that controlfile. Somehow. (Maybe
you could just use the "...for standby format" command by itself, and
use that instead of the regular one with a restored, not recovered,
hot backup. Doing strange unsupported things seems contrary to the DR
or HA paradigms).
See metalink Note:374069.1 and note the commands in figure 1A.
(Note:31406.1 shows the old way of doing it before O7.3. I have no
clue if such a thing would work now, though it should since we still
have the "using backup controlfile" recover clause. If it did work,
I'm guessing you probably couldn't use the newer activate standby
commands, wrong type of controlfile.)
jg
--
@home.com is bogus.
12 percent of corporate fraud cases are detected by outside auditors.
Twenty-five percent of fraud cases are discovered "by accident."
http://www.signonsandiego.com/uniontrib/20070505/news_1b5options.html
-----------------------------------------------Reply-----------------------------------------------
On May 8, 10:23 am, joel garry <joel-ga
@home.com> wrote:
> Standby databases need a standby control file. The key to doing it
> without RMAN would be to generate that controlfile.
Duh, I forgot about ALTER DATABASE CREATE STANDBY CONTROLFILE AS
jg
--
@home.com is bogus.
Those darn navy pilot/stockbroker/teacher/comic fan/computer users!
http://www.signonsandiego.com/uniontrib/20070504/news_b1b4wfii.html
-----------------------------------------------Reply-----------------------------------------------
On 8 May 2007 09:14:22 -0700, Neil Cudd <neil.c
@blueyonder.co.uk>
wrote:
>this may seem a sill y question - but what if you are not backing up
>using RMAN ?
>Thanks,
>Neil.
It would be silly NOT to use RMAN. Apart from that, there is no reason
why you can't use RMAN for this single occasion.
--
Sybrand Bakker
Senior Oracle DBA
Add to del.icio.us |
Digg this |
Stumble it |
Powered by Megasolutions Inc
