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

When opening the virtual machine to log in to the database in the morning, I suddenly reported an error: ORA-09817: Write to audit file failed

Failed to write? The disk is not full, is it? Of course, the no space left on device prompt is very obvious, df-h query, sure enough 100%:

Immediately search the oracle directory what can be deleted, find a patch file, delete decisively, free up nearly 200m of space, should be able to get up:

We finally meet again. Think back to the fact that you opened a file when you were doing the experiment. Make sure:

It is indeed open, the archived files are in the / oracle directory, the size is about 1G, close the archiving first and then delete the files.

[oracle@db01 oracle] $du-sh archive/1019M archive/

Close archiving steps:

1. Close the database and start to mount state

Shutdown immediate

Startup mount

2. Close archiving

Alter database noarchivelog

3. Boot to open status

Alter database open

4. View archive status

Archive log list

After deleting, df-h saw the remaining 1.5g, although not much, but basically meet the current study and use, and then do it again later.

[oracle@db01 oracle] $df-hFilesystem Size Used Avail Use% Mounted on/dev/sda1 12G 4.4G 6.9G 39% / tmpfs 2.0G 300M 1.7G 16% / dev/shm/dev/sdb1 20G 18G 1.5G 93% / oracle/dev/sdc1 20G 172m 19G 1% / soft

Finally, reset the db_recovery_file_dest_size and db_recovery_file_dest parameters:

Alter system reset db_recovery_file_dest_size scope=spfile;alter system reset db_recovery_file_dest scope=spfile

Restart the database check has returned to the default:

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.