Re: removal of standby database

From: EdStevens <quetico_man_at_yahoo.com>
Date: 20 Apr 2006 06:14:06 -0700
Message-ID: <1145538846.803862.158140@e56g2000cwe.googlegroups.com>

Volker,

Thanks for the reply. I checked out the paper referenced by Joel, then queried the setup and got the following results. Looks like everything is already disabled. (This was done on the primary server.)

DGMGRL> show configuration
Configuration 'acipmdv' is
  Primary Site is 'acipmdv'
  Standby Site is 'acipmdv_stby'
Current status for "acipmdv":
DISABLED DGMGRL> show site acipmdv
Site 'acipmdv' is
  Hostname is 'cdnbwpmd'
  Instance name is 'acipmdv'
bwpmd)(PORT=1521)))(CONNECT_DATA=(SID=acipmdv)(SERVER=DEDICATED)))'   Standby is maintained as 'physical'
  Site has 1 resource
    Resource is 'acipmdv'
Current status for "acipmdv":
DISABLED DGMGRL> show site acipmdv_stby
Site 'acipmdv_stby' is
  Hostname is 'cdnbwpmp'
  Instance name is 'acipmdv'
bwpmp)(PORT=1521)))(CONNECT_DATA=(SID=acipmdv)(SERVER=DEDICATED)))'   Standby is maintained as 'physical'
  Site has 1 resource
    Resource is 'acipmdv_stby'
Current status for "acipmdv_stby":
DISABLED DGMGRL> show resource acipmdv
Resource 'acipmdv' on site 'acipmdv'
  depends on 'acipmdv'
Current status for "acipmdv":
DISABLED DGMGRL> show resource acipmdv_stby
Resource 'acipmdv_stby' on site 'acipmdv_stby'   depends on 'acipmdv_stby'
Current status for "acipmdv_stby":
DISABLED DGMGRL> exit Received on Thu Apr 20 2006 - 08:14:06 CDT