We are on RHL with 188.8.131.52 DB version. Due to various unknown reasons we would like to recreate logical standby database and for that purpose I would like to cleanly remove/uninstall/drop LOGICAL STANDBY DATABASE from the DATA GUARD configuration we have.
The DG setup already has 1 PHYSICAL STANDBY DATABASE which is working fine. PRIM,PHYSICAL, and LOGICAL all are on different HOSTS. Could you please guide or suggest us exact MOS Doc id regarding this? I have found one MOS Doc id which is close enough but its steps include removing dg configuration completely which I don't want. Only Logical Standby database needs to be remove cleanly so that it can be installed again properly.
We are using GRID CONTROL and DATA GUARD BROKER.
Bundle of thanks in advance.
Thank you very much.
As I mentioned that I found one MOS Doc ID I meant to say the same doc exactly, but I forgot to mention it.
In this Doc ID, steps to remove logical standby is clear but it says to remove logical also follow above steps to remove physical and as I mentioned I do not want to remove complete DG-Broker configuration or physical standby.
OK I understand you question exactly. While it might be possible I don't believe there is a single document.
You might save time be just rebuilding the whole thing with these combination of MOS documents:
How to Safely Remove a Data Guard Broker Configuration (Doc ID 261336.1)
Step by Step Guide on How to Create Logical Standby (Doc ID 738643.1)
How to remove a Data Guard Configuration from Primary Database (Doc ID 733794.1)
Everyone I know in IS tries to find the most simple method to obtain their goal. The trick is not spending more time looking for it than the time you would save.
Thanks a lot.
What I did is:
- DROP DATABASE (from logical standby database)
- asmcmd > and removed remaining orphan files related to this logical database.
- DGMGRL> remove database logicladb; a
- Grid control> removed it from there
- removed the logical database entries from PRIMARY related to logical, e.g., log_archive_config.
Remaining steps> from the (Doc ID 733794.1) note id regarding LOGICAL STANDBY DATABASE (I think regarding MINING)