GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

  GeekInterview.com  >  Interview Questions  >  Oracle  >  Backup and Recovery

 Print  |  
Question:  
What are the steps involved in Database Startup ?

Answer:
Start an instance, Mount the Database and Open the Database.


December 12, 2005 12:20:58 #4
 simplegal   Member Since: December 2005    Total Comments: 3 
RE: What are the steps involved in Database Start...
 

1. Log in as oracle (or any user in group dba)

2. Set your ORACLE_SID to the instance you want to start. Verify that your ORACLE_HOME is set to the correct database version

3. Start SQL*Plus and connect as sysdba

4. Start the database.

During database startup, you can specify the state it will open to. The default is open(startup), but you can specify STARTUP NOMOUNT or STARTUP MOUNT depending on which task to perform.
     

 

Back To Question