Oracle Log Full system disk is full, causing the database to hang up and the Archivelog log is full, but the database is not open, unable to login, fortunately, can also go to Mount state. Workaround:
1. According to the error View appearance: CRS service down
Crs-0184:cannot communicate with the CRS daemon
Delete/var/tmp/.oracle Directory
To delete an Oracle ALTER LOG:
Cd/u01/app/oracle/rdbms/bol/bol1/alter
RM-RF *
Restarting the machine can start the Oracle service, but the Oracle's DB service cannot be started
The error when starting the DB service is as follows:
PRCR-1079: Unable to start resource ora.orcl.db Ora-03113:end-of-file on communication channel
Workaround:
Su-oracle
Sqlplus/as SYSDBA
Startup mount# #rac上面2台都要做
To see if the archive mode is:
Archive Log List
To view the flash-back partition size:
Show Parameter Db_recovery_file_dest_size
To view the Archlog log usage rate:
SELECT * from V$flash_recovery_area_usage; --View space occupancy if archived LOG exceeds 90%,oracle at any time with a risk of downtime
Increase the Flash back partition size:
Alter system set db_recovery_file_dest_size=xxg;# #rac operate one set
Start the database:
ALTER DATABASE Open # #rac above 2 machines to do
After that, you can connect to the database, but what needs to be done now is to clear the archive log of the database, because now only increases the db_recovery space, we need to clean up the unnecessary archive log, to obtain space.
Clear the Archive log script:
#!/bin/bash
Source/home/oracle/.bash_profile
#LOGFILE =/data/rman/rman_delete.log
#RMAN = $ORACLE _home/bin/rman
$ORACLE _home/bin/rman log=/home/oracle/del_arch$ (date +%y-%m-%d). Log <<eof
Connect target Sys/[email protected]
Crosscheck Archivelog All;
Delete noprompt expired archivelog all;
Delete noprompt Archivelog until time ' sysdate-3 ';
Exit
Eof
Run directly in the root directory. To solve this problem, record it, and you can use it later.
Oracle RAC 11g Log fills the system disk resulting in database down