We are going to have look at the most basic but most important part of Database. It is the first step of Database. We can call it initial stage of Database. Let’s have look at this image. It indicates some hidden simple and most meaningful message. Ladders are to meant to climb only it shows we have to go step by step towards our goal we can’t skip any single step to reach the top.
In some manners, we have to follow steps in Oracle Database to perform DBA task. There are no shortcuts. Being DBA we have to follow these steps with proper rules and regulations. Let’s have look at the process to start oracle instance by knowing the impact of each stage on a database.
DATABASE STARTING PROCEDURE:
Let’s have look at the stages of Database instance.
|Oracle Instance||Command Use to reach Stage||Action Perform
|NOMOUNT||SQL>STARTUP NOMOUNT;||Allocating SGA
Starting the Background Processes
Open trace file and alert log file
|MOUNT||SQL>STARTUP MOUNT;||Enabling and disabling redo log-archiving options.
Performing full database recovery.
Renaming data file, redo file
Alter Database Command from One state to another State:
Change From NOMOUNT to MOUNT State:
SQL>ALTER DATABASE MOUNT;
Change From MOUNT/NOMOUNT to OPEN State
SQL>ALTER DATABASE OPEN;
|RESTART DATABASE||SQL>STARTUP FORCE;||You cannot shut down the current instance with the SHUTDOWN NORMAL, SHUTDOWN IMMEDIATE, or SHUTDOWN TRANSACTIONAL commands.
You experience problems when starting an instance.
|STARTUP RESTRICT||SQL>STARTUP RESTRICT; OR SQL>ALTER SYSTEM ENABLE RESTRICTED SESSION;
SQL>ALTER SYSTEM DISABLE RESTRICTED SESSION;
|Only database administrators should have the RESTRICTED SESSION system privilege. Further, when the instance is in restricted mode, a database administrator cannot access the instance remotely through an Oracle Net listener, but can only access the instance locally from the machine that the instance is running on.|
|OPEN DATABASE IN READ ONLY MODE||SQL> ALTER DATABASE OPEN READ ONLY;||That will prevent any modification in Database
Thank you for giving your valuable time to read the above information.
If you want to be updated with all our articles send us the Invitation or Follow us:
Telegram Channel: https://t.me/helporacle
Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/
Joel Perez’s LinkedIn: Joel Perez’s Profile
LinkedIn Group: Oracle Cloud DBAAS
Facebook Page: OracleHelp
Wow awesome!! Truly you rock,