Skip to Main Content
Forums

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Starting Physically Standby Database in Mount Mode

Thunder2777Jun 17 2013 — edited Jun 21 2013

Hi All

I have configured Data Guard using Oracle 10g 10.2.0.4.0 (64 bits) on Windows 2008 Server (64 bits) Release 2 Enterprise.

Data guard configuration was OK as the message from "Enable Configuration DG1" was "SUCCESS" for both

Primary and Standby Database. I have also set both Databases and TNS to start Automatically whenever Windows Starts.

The Problem is as long as the Standby Server is running, there is No issue.

But when we Restarts the Backup Server, Physically Standby Database is Started and TNS is also Started,

but Archives  are not received until I physically do the following steps so that it can received the Archives.

  1. SQL> startup nomount;                                                                                                                
  2. SQL> alter database mount standby database;                                                                 
  3. SQL> alter database recover managed standby database disconnect from session;

Is there a way to start Physically Standby Database in Mount mode when windows started.

Regards

Thunder2777
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 19 2013
Added on Jun 17 2013
#data-guard, #performance-availability
8 comments
6,931 views