Oracle Database Administration - Answer all the following 1. Shutdown the databa

Question

Oracle Database Administration - Answer all the following

1.         Shutdown the database then start it again.

2.         Connect remotely to the database, then create 2 users: another DBA and a user. who will be an applications developer for the database.

3.         Determine the status of the listener. If the listener is off, start it. If it is on, turn it off.

4.         Determine the total amount of memory your database is currently using. How much space is your project actually taking? (hint: is there a way to determine how much memory a DB takes when it is first created?)

5.         By default, the Archive Redo logs are disabled. Enable ARCHIVELOG mode for       your database.

Explanation / Answer

1) shutdown and starting database.

shutdown can be done three ways, normal immediate, abort(hard)

SQL> shutdown

Starting database is done in three process : Startup,mount,open

SQL> startup nomount

SQL> startup mount

SQL> startup

2) Connect and create user

3) Determine the status of listener

4)Memory details

select b.tablespace_name, tbs_size SizeMb, a.free_space FreeMb

from

(select tablespace_name, round(sum(bytes)/1024/1024 ,2) as free_space

from dba_free_space

group by tablespace_name) a,

(select tablespace_name, sum(bytes)/1024/1024 as tbs_size

from dba_data_files

group by tablespace_name) b

where a.tablespace_name(+)=b.tablespace_name;

5)Enable archive redo log

Firstly verify database archive log

The log mode is No Archive Mode. Note that Archive destination is USE_DB_RECOVERY_FILE_DEST

SQL> alter system set log_archive_dest_1='LOCATION=/u02/app/oracle/oradata/orcl/arch' scope = both;

SQL> archive log list;

Now we shutdown the database and bring it backup in mount mode.

SQL> shutdown immediate

SQL> startup mount

Lastly all that is needed it set archive log mode and open the database.

SQL> alter database archivelog;

SQL> alter database open;

SQL> archive log list

Related Questions

Navigate

• Browse (All)
• Browse O
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.