| Primary database [message #341960] |
Wed, 20 August 2008 22:29  |
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  |
 |
Michel Cadot
Messages: 68749
Registered: March 2007
Location: Saint-Maur, France, https...
|
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
