Home » Server Options » Data Guard » Primary database ( AIX v5.3 5L 64 bits)
Primary database [message #341960] Wed, 20 August 2008 22:29 Go to next message
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 #341971 is a reply to message #341960] Wed, 20 August 2008 23:21 Go to previous messageGo to next message
Messages: 24963
Registered: January 2009
Location: SoCal
Senior Member
I suggest you would be wiser to (re)create the standby DB; as opposed to cease trying to ship the archived redo logfiles.
Re: Primary database [message #341973 is a reply to message #341960] Wed, 20 August 2008 23:41 Go to previous message
Michel Cadot
Messages: 63917
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".

Previous Topic: Import a schema (tables, Views, Stored Procedures) on logical standby
Next Topic: Oracle Data base Backup Server
Goto Forum:

Current Time: Mon Oct 24 17:35:07 CDT 2016

Total time taken to generate the page: 0.10398 seconds