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

Example Analysis of RAC Database restart

2025-02-23 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

Shulou(Shulou.com)05/31 Report--

This article will explain in detail the example analysis of RAC database restart. The editor thinks it is very practical, so I share it with you as a reference. I hope you can get something after reading this article.

1) su-grid-- enter the user

2) lsnrctl stop-disable monitoring

Srvctl stop listener-n rac02

Srvctl stop listener-n rac01

Srvctl start listener-n rac01

Srvctl start listener-n rac02

3) deactivate the database

Srvctl stop db-d vbsrun-o immediate

3) crs_stat-t-- View the current status of RAC (currently normal)

[grid@rac01] $crs_stat-t

Name Type Target State Host

Ora.ARCH.dg ora....up.type ONLINE ONLINE rac01

Ora.DATA.dg ora....up.type ONLINE ONLINE rac01

Ora....ER.lsnr ora....er.type ONLINE ONLINE rac01

Ora....N1.lsnr ora....er.type ONLINE ONLINE rac02

Ora....N2.lsnr ora....er.type ONLINE ONLINE rac01

Ora....N3.lsnr ora....er.type ONLINE ONLINE rac01

Ora.OCR.dg ora....up.type ONLINE ONLINE rac01

Ora.asm ora.asm.type ONLINE ONLINE rac01

Ora.cvu ora.cvu.type ONLINE ONLINE rac01

Ora.gsd ora.gsd.type OFFLINE OFFLINE

Ora....network ora....rk.type ONLINE ONLINE rac01

Ora.oc4j ora.oc4j.type ONLINE ONLINE rac01

Ora.ons ora.ons.type ONLINE ONLINE rac01

Ora....SM1.asm application ONLINE ONLINE rac01

Ora....01.lsnr application ONLINE ONLINE rac01

Ora.rac01.gsd application OFFLINE OFFLINE

Ora.rac01.ons application ONLINE ONLINE rac01

Ora.rac01.vip ora....t1.type ONLINE ONLINE rac01

Ora....SM2.asm application ONLINE ONLINE rac02

Ora....02.lsnr application ONLINE ONLINE rac02

Ora.rac02.gsd application OFFLINE OFFLINE

Ora.rac02.ons application ONLINE ONLINE rac02

Ora.rac02.vip ora....t1.type ONLINE ONLINE rac02

Ora....ry.acfs ora....fs.type ONLINE ONLINE rac01

Ora.scan1.vip ora....ip.type ONLINE ONLINE rac02

Ora.scan2.vip ora....ip.type ONLINE ONLINE rac01

Ora.scan3.vip ora....ip.type ONLINE ONLINE rac01

Ora.vbsrun.db ora....se.type ONLINE ONLINE rac01

4) disable RAC (please execute in rac01 and rac02 respectively) root users

/ u01/app/11.2.0/grid/bin/crsctl stop cluster-all

5) restart the host after waiting for the rac status to be offline

Reboot

6) after rebooting the host, please enable the cluster node on rac01.

/ u01/app/11.2.0/grid/bin/crsctl start cluster-all

7) State detection

Check statu

[root@rac02] # / u01/app/11.2.0/grid/bin/crs_stat-t-v

8) restart the data separately

Startup

This is the end of the article on "sample Analysis of RAC Database restart". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, please share it for more people to see.

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