sikyala
asked on
how do i completely remove physical standby database
I created a physical standby database in grid control. i didn't change the default value for standby target name. When i tried to verify the standby configuration it complained that the failover would probably not work because it didn't recognize the name. I wasn't able to edit the standby configuration because it said it was still in process. So I deleted it from the grid. However, everything it created still exists. I tried killing the processes. but they are still there. I set the dg_broker_start to false and removed the files indg_broker_config_file1 and dg_broker_config_file2 in the directory for those parameters. I tried changing my oracle sid to log in and shut down the processes. But it says it is not an identifier. I don't know how to remove all of this and start from scratch. What should I do? I can't do anything in the grid because the standby is no longer listed.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Good luck!
:p