ora-03113 Problem Solving

Oracle 11g ora-03113 Problem Solving

1. When the database is closed:

Sql>startup nomount ' Start the database to Nomount state

2. Change the size of the flash back space

Sql> alter system set db_recovery_file_dest_size=30g; ' Change the space to 30G

3. Boot to Mount State

Sql>alter database mount;

4. Open the Database

Sql>alter database open;

5, check the archive log size, manually delete the unwanted historical archive files

Rman> DELETE ARCHIVELOG all completed before ' SYSDATE-7 ';

Description: SYSDATA-7, indicates that the current system time 7 days ago, the Before keyword represents the archive log 7 days ago, and if the flashback function is used, the flashback data is also deleted.
In the same way, you can delete all logs from 7 days ago to the present, but this command should be considered clearly, after this deletion, it is best to make full backup database immediately

This article is from the "Xianyunyehe" blog, make sure to keep this source http://228110.blog.51cto.com/218110/1591060

Ora-03113 Problem Resolution