Home » Server Options » Data Guard » Remove the standby Database (Linux 2.4.2)
Remove the standby Database [message #309936] Sun, 30 March 2008 02:55 Go to next message
Nick_01
Messages: 36
Registered: March 2008
Member
To Remove one standby database from the dataguard setup that has a primary database with 3 standby database..

I seek the expert's advice before taking up this task..

1.stop the archive log shipping for all standby databases:
alter system set log_archive_dest_state_n=defer scope=both;
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;(In Standby DB)
shutdown immediate

2.remove the log_archive_dest_n='service= ' in init.ora related to the standby database

3.remove the tnsnames in primary.

4.restart the primary database,copy the missing archive logs to the other two standby databases and mount the standby database and alter database recover managed standby database disconnect from session; then enable the log shipping.

Re: Remove the standby Database [message #309982 is a reply to message #309936] Sun, 30 March 2008 19:33 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
You shouldn't have to shutdown the primary. You should only have to change the parameters LOG_ARCHIVE_DEST_n and LOG_ARCHIVE_CONFIG (if set) for the corresponding database.
Re: Remove the standby Database [message #310314 is a reply to message #309982] Mon, 31 March 2008 22:01 Go to previous message
Nick_01
Messages: 36
Registered: March 2008
Member
Thank you for the support.
Previous Topic: Need to clone
Next Topic: Gaps have occured in the archive logs on my Standby DB (using Dataguard)
Goto Forum:
  


Current Time: Fri Mar 29 01:33:52 CDT 2024