ORA-24324: service handle not initialized ORA-24323: value not allowed ORA-01090: shutdown in progress – connection is not permitted Cause: for this is that the Background processes are hanging/not stared correctly during the previous startup of this database. Hence the smeaphores and shared memory segements are not getting detached properly now during shutdown. Solution 1. Verify […]

The following examples use Oracle Database 10g and make use of a Recovery Catalog and the Flash Recovery Area (FRA). 1. Restore controlfile from autobackup. RMAN> restore controlfile from autobackup; 2. Restore controlfile from a specific backup piece. RMAN> restore controlfile from ‘/backup_dir/piece_name’; 3. Restore controlfile from most recent available controlfile backup. RMAN> restore controlfile; […]