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