Starting up database instance
SQL> STARTUP NOMOUNT
This state is used for creating new database or creating new control file. At this state, Oracle allocates SGA and starts background processes.
SQL> STARTUP MOUNT
This state is used for performing specific maintenance operations like renaming data files, enabling/disabling archive log mode, adding/dropping/renaming redo log files, recovering database etc. Control file is read at this stage but the data files are not open.
SQL> STARTUP OPEN or simply SQL>STARTUP
Database is available for normal operations.
NB: Oracle 11g requires at least 1 GB of RAM and 5 GB disk space to install.
For an operational production database, more RAM and disk space are required.
This state is used for creating new database or creating new control file. At this state, Oracle allocates SGA and starts background processes.
SQL> STARTUP MOUNT
This state is used for performing specific maintenance operations like renaming data files, enabling/disabling archive log mode, adding/dropping/renaming redo log files, recovering database etc. Control file is read at this stage but the data files are not open.
SQL> STARTUP OPEN or simply SQL>STARTUP
Database is available for normal operations.
NB: Oracle 11g requires at least 1 GB of RAM and 5 GB disk space to install.
For an operational production database, more RAM and disk space are required.
No comments:
Post a Comment