How to Start Standby database in recovery mode after system Reboot in Windows

Follow
Description
This article explains Dbvisit recommended way to start your Standby Database incorrect mode after the system reboot. In windows Environment, the Oracle database is started as the read-only mode by default during the automatic startup. For Dbvisit the Standby database must be in recovery mode(mount state) to apply archive logs. You could try the below workaround to make sure the database is in the correct mode after the server reboot
 
Solution

 Steps

1. Change Oracle registry entry ORA_SID_AUTOSTART to FALSE. This will start Windows Oracle Service automatically on startup, but the Oracle instance will remain down

2. Create a new  Windows scheduler to run the Dbvisit start database command to start the Standby database in recovery mode.  It's best to start with some delay to make sure all the OS resources required for the database instance are started first.

dbvctl.exc -d <DDC> -o start

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Have more questions? Submit a request

Comments