1. create a database with minimal parameters
    db_name=test
sga_target=800m
2. check the below instance parameters
   – DB started with spfile/pfile
   – Log buffer
   – Dbcache
   -large pool
   -java pool
   – shared pool
   -sga target
   -sga max size
   PGA related parameters :
– sort size
– hash
– merge bitmap
-create bitmap
– pga* (2)
– workarea size policy
3. Start the database with spfile
  – increase sga target and maxsize  by 200m
4. check for sys and sess modifyable parameters
5. check the location of alert log
6. Change the database to archive log mode and destination to /archive
– make sure the archived lofiles are written here
7. Take a bakup of controlfile in binary format and text format to /tmp location
-multiplex the controlfile to
/control1/control1.ctl
/control2/control2.ctl
/control3/control3.ctl
8. simulate dead lock error and how will you check the sql and the session that caused this error?
9. copy the spfile to /control1/spfile.ora and start the database using it.
10. remove the init<name>.ora and corrupt the spfile(edit it/remove the first line). how will you start you database?
———————–
11. Check how many log groups and members you have in your database?
– Check their sizes and their locations.
12. create a directory /log/, and move those logfiles into directories.
– multiplex the logfiles with size 100m as
Group-1: /log/loggroup1/log11.dbf,/log/loggroup1/log12.dbf,/log/loggroup1/log13.dbf
Group-2:/log/loggroup2/log21.dbf,/log/loggroup2/log22.dbf,/log/loggroup2/log23.dbf
Group-3:/log/loggroup3/log31.dbf,/log/loggroup3/log32.dbf,/log/loggroup3/log33.dbf
13. Drop you database.
14. Create a database with OFA architecture, manually
DATAFILE LOCATION :
– SYSTEM -> 500m ->/{dbname}/data/system.dbf
– SYSAUX -> 300m ->/{dbname}/data/sysaux.dbf
– UNDO -> 200m ->/{dbname}/data/undo.dbf
– TEMP -> 100m ->/{dbname}/data/temp.dbf
-USER_DATA -> 50M ->/{dbname}/data/user_data01.dbf
-USER_INDEX-> 10M ->/{dbname}/data/user_index01.dbf
PARAMETERS :
SGA -> 800m
PGA -> 200m
alert_log – > /{dbname}/alert/alert{dbname}.log
controlfiles -> /{dbname}/control/control1.ctl
/{dbname}/control/coltrol2.ctl
/{dbname}/control/coltrol3.ctl
Logfiles (size 50m)
-> /{dbname}/log/log11.log,/{dbname}/log/log12.log,/{dbname}/log/log13.log
/{dbname}/log/log21.log,/{dbname}/log/log22.log,/{dbname}/log/log23.log
/{dbname}/log/log31.log,/{dbname}/log/log32.log,/{dbname}/log/log33.log
ARHIVE DESTINATION : /{dname}/archivelog/