| Remove the standby Database [message #309936] |
Sun, 30 March 2008 02:55  |
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.
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
