Startup Oracle Database at Open Stage

When Oracle opens the database, it accesses all of the datafiles associated with the database. Once it has accessed the database datafiles, Oracle makes sure that all of the database datafiles are consistent.Oracle opens the online datafiles and online redo log files. If a tablespace was offline when the database was previously shut down, the tablespace and its corresponding datafiles will still be offline when you  reopen the database.
To open the database, you can just use the startup command

SQL> startup mount

If the database is mounted, you can open it with the alter database open command

SQL> alter database open

Related Post :-

People who read this post also read :


Post a Comment


Twitter Delicious Facebook Digg Stumbleupon Favorites More