How DBA onboarding should get to know the online database

How do we quickly take over the online database system in the case of a new company as a DBA?

In addition to the business level needs to know the supported business of the database, technically we can understand our database from the host level and the database level.

(Of course someone with a well-developed document better)

Environment of the database host

1. the version of the operating system that the database host is running

Linux:cat/etc/redhat-releaseuname-alinux rac01 2.6.32-358.el6.x86_64 #1 SMP Fri Feb 00:31:26 UTC x86_64 x86_64 x86_64 Gnu/linux

2, the database host hardware information, resource situation

Cat/proc/cpuinfofree–mtopasprtconf

3, look at the monitoring system historical data, view CPU, memory History of the use of

Database Level

Backup

1, review backup scripts, backup policies, such as what time point of Backup, where to backup, policy

generic backups are performed in Crontab .

2, monitor the backup script output log, whether there is an error

Highly Available

1, the database is a single node or RAC, there is no DG

2, DG 's strategy, synchronization log monitoring

Management

1. Database Version

Sql> select * from V$version;

2. Platform Information

Sql> select * from Dba_registry_database;

3, query database name,DBID, etc.

Select dbid, Name, Open_mode, Database_role, platform_name from V$database;

4, single or RAC

Show parameter cluster_database;

5.Archive log path,DG synchronization configuration

Archive log list show parameter log_archive_dest;

6.control file path, log file path, parameter file

Sql> col name for a50sql> select * from V$controlfile; Select l.group#, Lf.type, Lf.member, L.bytes,l.thread#,l.members, L.status log_status, Lf.status LOGFILE_STATUS from      V$log L, v$logfile lf where l.group# = lf.group# ORDER by 1, 3; Show Parameter SPFile

7. Character Set

SELECT * from Database_properties;

8,SGA,PGA configuration Situation

Show parameter SGA Show parameter PGA

9. Other parameter Configuration

Process,session

table space name, size, data file path,ASM

one, get an AWR look

How DBA onboarding should get to the online database