This topic could help the Basis consultants to understand responsibility on Database who about to take lead roles and Aspirants who want carrier in SAP Basis.

Aim here is to provide glimpse of concept mentioned- nothing to do with Technical steps / how to perform. Though the concepts are similar for all RDBMS , Oracle is the DB which I kept in view while explaining each topic .

Common DB activities which a Basis Consultant responsible for

1. Start / Stop DB
2. TableSpace addition
3. Archiving the table data
4. Perform Table Re-org
5. Create Indexes
6. Update Indexes
7. Performance Tuning
8. Install/ Update DB
9. Backup / Restore DB
10. Database migration

  1. Start/ Stop DB

You need data files to store Data, you need control files to find the DB details and you need parameter files to configure the DB Instance.

What is Instance ?

To open a MS file – you need windows environment , To open Pdf – you need pdf software. Similarly to open and to work on the date saved in Oracle files, you need an environment where you can operate on the data which is saved in data files.

So 1st you need to create DB instance – When you execute the command startup , it reads the parameter files ( pfile / SPfile ) and configure DB instance and Identify the location of Archive  logs / Control files  – Status is started ( No mount )

2nd – once control files location is identified the instance will try to read the control files and read the data in control file and validate the control files – Status is Mount

3rd – Once the data files are located , Instance will try to open and check the data files , if any recovery is required w.r.t control file. If all fine , it keeps the DB in opened status.

 

more information to be added