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

Oracle 11g ora-03113 problem Resolution

1. When the database is closed:

Sql > startup nomount 'start the database to NOMOUNT state

2. Modify the size of the flashback space

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

3. Boot to mount status

Sql > alter database mount

4. Open the database

Sql > alter database open

5. Check the size of the archive log and delete unwanted historical archive files manually.

RMAN > DELETE ARCHIVELOG ALL COMPLETED BEFORE 'SYSDATE-7'

Description: SYSDATA-7, indicating that the current system time is 7 days ago, and the before keyword indicates the archived logs 7 days ago. If the flashback feature is used, the flashback data will also be deleted.

By the same token, you can delete all logs from 7 days ago to the present, but this command should be carefully considered. After this deletion, it is best to make a full backup of the database immediately.

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.