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

The method of hanging up Oracle snooping and cleaning the full log of archived database

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

Share

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

Oracle data snooping failed the restart method:

-- Monitoring

Lsnrctl start-takes effect only with a slight delay after startup

Lsnrctl status

Lsnrctl stop

-- forcibly kill and monitor

Ps-ef | grep lsnrctl

Ps-ef | grep tnslsnr | grep-v "grep"

The number before kill-9

The Oracle database archive log is full. Delete the log:

Log in to the rman target sys/password command and execute it after entering the RMAN command line.

RMAN > crosscheckarchivelog all

RMAN > delete expired archivelog all; can delete all expired log documents and free up space

Or delete the archivelog before the specified time:

DELETEARCHIVELOG ALL COMPLETED BEFORE 'SYSDATE-7'; (specifies to delete the archive log 7 days ago)

Then do the test data, and the problem will be gone.

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