Oracle DBA practicals for beginers

	This Blog contains all the basic practicals that an aspiring Oracle DBA should perform before stepping out in the world of Oracle Database Administration.These practical topics are prepared based on my own learnings for the past 9 years as an Oracle DBA
1	significance of various rpms required
2	significance of various kernel parameters
3	significance of oracle user,groups
4	Set different environment variables
5	location of tnanames.ora depending upon TNS_ADMIN
6	Significance of /etc/oratab
7	enabling and disabling automatic database startup
8	understanding various options inside response file
9	software installation silently using runinstaller
10	significance of oraInventory
11	create database using DBCA in silent mode
12	creating database manually using create database command
13	significance of catalog and cataproc scripts
14	Fetch data from any dictionary view before running catalog or cataproc scripts
15	try and connect to Db without listener
16	setting password for listener
17	checking the services status of the listener using lsnrctl
18	connection of sys user without password file
19	easy connect method from a client machine
20	connection using tnsnames from any client machine
21	drop the dba os group and run sqlplus / as sysdba
22	connectivity with and without sqlnet.ora
23	starting database using pfile and spfile
24	changing parameters in spfile and pfile and understand various parameters
25	alter system,alter database,alter session
26	enabling disabling autoextension for tablespaces
27	providing segment and extent info while creating tablespace
28	adding space to database by increasing datafile size
29	adding space to database by adding datafile
30	setting the limit for maximum datafiles in databse
31	database startup stages
32	database shutting down options and significance
33	starting the db in various modes like upgrade,read only etc
34	changing temporay tablespace
35	change dbname,dbid,db unique name
36	change location of archive location
37	set various formats for archive log naming
38	create a role
39	create a role having password
40	creating a database link
41	creating a profile
42	creating a profile for the password settings;
43	creating and deleting an index
44	dba_,all_ and user_ type views
45	setting various nls parameters
46	expiring the user password after sometime
47	giving one users table privileges to another user-role
48	creat synonym public and normal
49	giving tablespace during user creation
50	granting all privileges on a table to an user
51	granting one role to another
52	granting profile to a user at the time of creation of the user
53	granting restricted session
54	granting two roles to a user
55	getting information about character sets and setting characterset
56	renaming the tablespace
57	kill session command
58	setting tablespace quota for any user
59	switching the undo_tablespace from one another
60	use of systimestamp,sysdate etc
61	viewing privileges of any user and changing them
62	grant various privegeles to user
63	revoke various privegeles from user
64	backup of database full,lv 0,lv1 incremental,lv1 commulative
65	backup of datafile
66	backup of archivelog
67	taking backup to any location of chaoice
68	rman show all command and all the rman parameters
69	backup of the controlfile to a particular location
70	delete input and its significance
71	crosschecking the backups using rman
72	expired and obselete backup
73	backup using export and various parameters of expdp
74	backup of controlfile in a sql script
75	backup of a particular tablespace using RMAN
76	backup of backupset
77	starting user managed backup using begin backup command
78	ending user managed backup using end backup command
79	rman list command
80	rman report command
81	RMAN compressed backup
82	rman delete command
83	understanding rman channel
84	rman show command
85	rman backup in nomount,mount,open mode..possible or not?
86	recover a spfile
87	recover a controlfile
88	recover a datafile
89	recover different files to different locations
90	remove the current temporary tablespace and understand the changes
91	recove if current redolog gets deleted/corrupted
92	recove if non current redolog gets deleted/corrupted
93	recover to a particular time
94	recover a whole database(complete disaster recovery) to same file system
95	recover a whole database(complete disaster recovery) to different file system
96	recover from export backup
97	importing a schema
98	importing a table
99	importing a user from one tablespace to another
100	recover till a required SCN
101	try only restore and open the database
102	RMAN run command for incomplete recovery until time
103	dropping a missing datafile
104	effect of resetlogs option
105	How to enable flashback in 11g
106	flashback database
107	flashback database by using restore point(have to down the db)
108	flashback logs information
109	Flashback Query
110	flashback table delete
111	flashback table drop
112	Flashback transaction
113	how RMAN recovery happens?
114	importing a role
115	recovery in case of loss of archive log file
116	creation of recovery catalog
117	maintenance of recovery catalog
118	auditing the database
119	AWR report generation using awrrpt.sql
120	changing the sna[shot taking time
121	playing with baseline
122	compiling database objects
123	creating a clone database using RMAN backup
124	creating a clone database without RMAN backup
125	patching a databse manually using opatch
126	applying one off
127	rollback the applied patch
128	create standby using backup
129	create standby using rman duplicate
130	creating standby using file copy
131	upgrading a database
132	downgrading a database
133	dropping a missing datafile
134	recyclebin usage
135	renaming a database
136	changing dbid of a database
137	steps to load data using sqlldr
138	transporting a tablespace
139	using logminer
140	understanding ADDM
141	understading ADR
142	data recovery advisor
143	database replay
144	dropping a database
145	flashback archive
146	segment advisor
147	SQL access advisor
148	SQL performance analyser
149	SQL plan baseline
150	SQL tuning advisor
151	SQL tuning set
152	table shrinking
153	total recall
154	databagurd broker
155	virtual column