ORA-01033 Oracle initialization or shutdow in progress

The 10 Gb archive log of Oracle Database is stored in flash_recovery_area by default, and 1 GB is selected during the default installation.

When the archiving log exceeds 1 GB, the space is insufficient, so the archive log file cannot be archived. At that time, the Oracle database cannot identify whether the space is released because the archive log file is manually deleted. The database cannot be started.

Solution:

1. Mount the database

SQL> startup Mount (note that an error is reported at this time, but the system parameters can be changed)

2. Change System Parameters

SQL> alter system set db_recovery_file_dest_size = 2G scope = both;

The value of db_recovery_file_dest_size is determined based on the remaining disk space and actual needs.

3. Open the database

SQL> alter database open

4. Delete invalid archive logs

5. Restart Oracle listener and oracleservice