EdStevens schrieb:
> Platform: AIX 5.3 Oracle EE 9.2.0.6
>
> I knew I'd get bit ...
>
> Database acipmdv on server Dev1
> Database acipmdv on server Dev2
>
> My task was to remove the db from dev2. I knew the previous dba had
> done something recently to have the db on Dev2 acting as a standby
> database for Dev1. Have never had my hands on such a beast.
>
> Before beginning work I did a 'show parameter' (on Dev1) and spooled
> it, so I have captured all of the init parms. There I found
>
> log_archive_dest_3 = service=(descriptio .......) etc., pointing to
> acipmdv on Dev2.
>
> couldn't see any other parms that seemed to deal with the standby
> database.
>
>
> First I logged on to the db on Dev1 and did
>
> alter system set log_archive_dest_3='' scope=both
>
> then bounced the db. It got an ora-03113 on open. A check of the alert
> log showed
>
> 29357 Errors in file
> /db01/app/oracle/admin/acipmdv/bdump/acipmdv_lgwr_499858.
> rc:
> 29358 ORA-16072: a minimum of one standby database destination is
> required
> 29359 LGWR: terminating instance due to error 16072
> 29360 Instance terminated by LGWR, pid = 499858
This might sound a stupid question but was there a particular
reason not to simply use
$ dgmgrl
> disable resource '...' on site '...'
> exit
$
?
Lots of Greetings!
Volker
Received on Wed Apr 19 2006 - 13:35:47 CDT
