Oracle initialization or shutdown in progress solution steps: shutdowninprogress

Oracle initialization or shutdown in progress solution steps: shutdowninprogress
Today, as usual, I started my computer and started the plsql tool to connect to the database, but I couldn't connect it. I reported the message "oracle initialization or shutdown in progress, from the service list of the operating system, it is found that both the listener and the oracle service are started, but the connection fails, and this error is always reported. No matter, try restarting the listener and service, but the result is still not good, or the above message is reported. Therefore, you can use sysdba to connect to oracle from the command line. Then, you can use select status from v $ instance to check the startup status. The mounted mode is used. No wonder you cannot connect to the database, because the database is not open yet, manually try to open the database: alter database open; the result is an error: "ORA-16014: log 3 serial number 286 not archived, no available destination "; it is estimated that the space in the flash back area is insufficient, and logs cannot be archived. The command operation is as follows:

-- 1. Check the size of the Space set for db_recovery_file_dest_size. SQL> show parameter db_recovery NAME TYPE VALUE ----------------------------------------------------------------------------- Db_recovery_file_dest string D: \ oracle \ product \ 10.2.0/flash _ Recovery_area Db_recovery_file_dest_size big integer 2G   -- 2. Check the usage of the flash recovery area: SQL> select * from v $ flash_recovery_area_usage;   -- 3. Calculate the space occupied by the flash recovery area: SQL> select sum (percent_space_used) * 3/100 from v $ flash_recovery_area_usage;   -- 4. Increase the value of db_recovery_file_dest_size. SQL> alter system set db_recovery_file_dest_size = 3G scope = both; The system has been changed. SQL> alter database open; The database has been changed.   -- 5. You can also delete unnecessary backups in the flash recovery area in rman to release the flash recovery area space: Delete obsolete; Crosscheck backupset; Delete expired backupset;

Db_recovery_file_dest_size: Set the directory size for storing archived log files, that is, the size of flash_recovery_area in the flash back area.