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

This article will explain in detail how to write oracle 11g archivelog in detail. The editor thinks it is very practical, so I share it for you as a reference. I hope you can get something after reading this article.

Oeacle 11g archivelog is full, causing the database to fail to open

1 for databases that do not need to be archived

Asmcmd

Cd DATA/WEB/DATAFILE

Rm-rf archive log file

Sqlplus / as sysdba

Shutdown immediate & ps-ef | grep instance name (kill pmon)

Sqlplus / as sysdba

Startup mount

Alter database noarchivelog

Shutdown immediate

Startup

Alter system set log_archive_log_start=false scope=spfile

2 for databases that need to be archived

Su-oracle

Export $ORACLE_SID= instance

Ramn target /

RMAN > crosscheck archivelog all

RMAN > delete expired archivelog all

Quit

Sqlplus / as sysdba

SQL > show parameter db_recovery_file_dest_size

If the file size needs to be expanded on the date

SQL > alter system set db_recovery_file_dest_size=4G

This is the end of the article on "what to do when oracle 11g archivelog is full". 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.