Primary database [message #341960] |
Wed, 20 August 2008 22:29 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
nayas
Messages: 1 Registered: August 2008
|
Junior Member |
|
|
Hi everyone,
I have an urgent question, heh.
For the last month, we had a standby database with our prod database.
2 weeks ago, we canceled the standby to do some testing with RMAN. The standby doesn't exist anymore.
The prod database never gave out error according to logs not being sent to standby.
Tonight, I had to bounce the prod database. Now, the alert_log keep having error saying that the remote database must be a standby database.
My question is, can I modify the log_archive_dest_2 from my primary to nothing? As we speak, it's log_archive_dest_2 (SERVICE=STDBY LGWR ASYNC=20480 OPTIONAL REOPEN=15 MAX_FAILURE=10 NET_TIMEOUT=30) to nothing?
Or what can I do to prevent the primary to try to send his log to the standby?
Thank you
|
|
|
|
Re: Primary database [message #341973 is a reply to message #341960] |
Wed, 20 August 2008 23:41 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68653 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
You can clear log_archive_dest_2 or you can disable it setting log_archive_dest_state_2 to "defer".
Regards
Michel
|
|
|