Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

Automatically enable the standby log application when the windows operating system restarts

2025-01-16 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

Shulou(Shulou.com)06/01 Report--

You must start DG_BROKER_START first

ALTER SYSTEM SET DG_BROKER_START=TRUE SCOPE=BOTH

Create a batch file:

Set ORACLE_HOME=D:\ app\ Administrator\ product\ 11.2.0\ dbhome_2

Set ORACLE_SID=HYDEE

Set PATH=%PATH%;%ORACLE_HOME%\ bin;%ORACLE_HOME%\ opatch

Dgmgrl / "startup"

Sqlplus sys/ password @ 192.168.10.223/hydee AS SYSDBA @ D:\ oracle-scripts\ start_apply_log.txt

The content of start_apply_log.txt is:

Alter database recover managed standby database using current logfile disconnect

Then create a scheduled task when the system starts:

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Database

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report