Shut down the database to make operating system offline backups of all physical structures and to have modified static initialization parameters take effect when restarted. SHUTDOWN [NORMAL | TRANSACTIONAL | IMMEDIATE | ABORT ] SHUTDOWN NORMAL Normal is the default shutdown mode.Normal database shutdown proceeds with the following conditions: • No new connections can be [...]
Archive for the ‘Oracle DBA’ Category
24 Oct
Starting and Altering Database
Starting Up a Database There are different states in which database can start up. The following scenarios describe different stages of starting up an instance starting with shutdown. SHUTDOWN NOMOUNT MOUNT OPEN Starting the Instance (NOMOUNT) An instance is started in the NOMOUNT stage only during database creation or the re-creationof control files.Starting [...]
