A DBA Must Keep Record of following information

During the stress of a recovery situation, it is important that you have all necessary information at your disposal. This is especially true if for some reason you need to contact Oracle Support because you run into a problem that you do not understand. You should have the following documentation about the database & hardware configuration:

You should keep this information both in electronic and hard copy form. For example, if you save this information in a text file on the network or in an email message, then if the entire system goes down, you may not have this data available.

The name of the node that host the database:

SELECT DBID, DATABASE_NAME FROM V$DATABASE;

63198034        SHAAN.WORLD

SELECT * FROM GLOBAL_NAME;

SHAAN.WORLD

The version and Patch Release of the Oracle Database:
9.2.0.7.0
The Version and Patch Release of the Networking Software:
TCP/IP
The database/instance/host information:
SELECT INSTANCE_NAME FROM V$INSTANCE;

SHAAN

SELECT UTL_INADDR.GET_HOST_ADDRESS FROM DUAL;

192.168.13.31

SELECT UTL_INADDR.GET_HOST_NAME FROM DUAL;

DBSERVER14

SELECT LOG_MODE FROM V$DATABASE;

ARCHIVELOG

The database properties and status information:

SELECT DEST_NAME,STATUS,DESTINATION from V$ARCHIVE_DEST;

LOG_ARCHIVE_DEST_1      VALID            E:\oracle\Archive

LOG_ARCHIVE_DEST_2      INACTIVE

LOG_ARCHIVE_DEST_3      INACTIVE

LOG_ARCHIVE_DEST_4      INACTIVE

SELECT * FROM DATABASE_PROPERTIES;

The database file & storage information:

Datafile Storage:

SELECT FILE_ID, FILE_NAME, TABLESPACE_NAME, BYTES, bytes/(1024*1024*1024) “in GB” FROM DBA_DATA_FILES;

Tempfile Storage:

SELECT FILE_ID, FILE_NAME, TABLESPACE_NAME, BYTES, bytes/(1024*1024*1024) “in GB”  FROM DBA_TEMP_FILES

SELECT * FROM V$LOGFILE;

SELECT * FROM V$LOG;

SELECT * FROM V$CONTROLFILE;

Datafile Storage in GB:

SELECT SUM(BYTES)/(1024*1024*1024) “SIZE IN GB” FROM DBA_DATA_FILES;

93.9389038085938 GB

or

select name, bytes from (select name, bytes from v$datafile

union all select name, bytes from v$tempfile

union all select if.member “name”, l.bytes from v$logfile if, v$log l

where if.group#=l.group#) used, (select sum(bytes) as poo from dba_free_space) free;

Freespace in Tablespace

SELECT TABLESPACE_NAME, BYTES, BYTES/(1024*1024*1024) “Free in GB” FROM SM$TS_FREE;

Tablespace used/free space in MB

select t.tablespace, t.totalspace as ” Totalspace(MB)”, round((t.totalspace-fs.freespace),2) as “Used Space(MB)”, fs.freespace as “Freespace(MB)”, round(((t.totalspace-fs.freespace)/t.totalspace)*100,2) as “% Used”, round((fs.freespace/t.totalspace)*100,2) as “% Free” from (select round(sum(d.bytes)/(1024*1024)) as totalspace, d.tablespace_name tablespace from dba_data_files d group by d.tablespace_name) t, (select round(sum(f.bytes)/(1024*1024)) as freespace, f.tablespace_name tablespace from dba_free_space f group by f.tablespace_name) fs where t.tablespace=fs.tablespace order by t.tablespace;

Apart from database information a DBA also keeping record of hardware & software configuration of server
The make and model of the production machine:
Dell Power EDGE R310 (Dell Power EDGE 1800)
The Version and Patch of the Operating system:
Windows 2003 service pack 2
The Disk Capacity of the Host:
1 TB
The number of Disk and Disk Controllers:
1 Controller 2 Hard Disk.
The Disk type, Capacity & Free space
RAID1
Disk 1: 1TB
Disk2: 1 TB
The Media Management Vendor (if you use a third party Vendor)
NIL
The Type & Number of Media Management Device:
NIL
The Method and Frequency of database Backup:
RMAN full Commulative & Incremental Backup
Import/Export
The Method of Restore & Recovery:
RMAN
Import/Export
The datafiles Mount Point:
1

Share this post: on Twitter on Facebook on Google+