DBA to understand the new environment,

Oct 30 posted in Oracle (RSS), 78 views.

Here, talk to those broad areas, such as understanding of the overall IT environment, the overall situation, assuming that you already know these, the next to face is that they had a vivid database. Here summarizes some general ideas to face the the first of a whole database, and thus quickly understand the environment you face outline.

This is not textbook, but a number of ideas and experiences, for this problem, each person's understanding of the perspective is not the same. Welcome to continue to supplement the sound.

1, one should first understand the current version of Oracle databases and platforms, and related information

This is very important, busy as a long time also know which version of your database, running in what system, it would mean is very sad, so I personally think that this is the first step you need to know. The following these scripts can help you get the relevant information you need.

select * from v$version;

select * from dba_registry_database;

select dbid, name, open_mode, database_role, platform_name from v$instance;

select dbms_utility.port_string from dual;

set serveroutput on

declare

ver VARCHAR2(100);

compat VARCHAR2(100);

begin

dbms_utility.db_version(ver, compat);

dbms_output.put_line('Version: ' || ver ||' Compatible: ' || compat);

end;

/

2, then you have to understand what components of the database Zhongzhuang

select * from dba_registry;

3, clear the environment is a stand-alone or cluster?

There are many ways to judge this, I am here to give a help dbms_utility to determine the method.

set serveroutput on

declare

inst_tab dbms_utility.instance_table;

inst_cnt NUMBER;

begin

if dbms_utility.is_cluster_database then

dbms_utility.active_instances(inst_tab, inst_cnt);

dbms_output.put_line('-' || inst_tab.FIRST);

dbms_output.put_line(TO_CHAR(inst_cnt));

else

dbms_output.put_line('Not A Clustered Database');

end if;

end;

/

4, is configured with the DataGuard?

select protection_mode, protection_level, remote_archive, database_role, dataguard_broker,guard_status

from v$database;

5, it hired a archive mode?

conn /as sysdba

archive log list;

select log_mode from v $ database;

6, it hired a flashback database feature?

select flashback_on from v$database;

If so, further view of the configuration FRA

7, it hired a force logging and additional logging?

select force_logging,supplemental_log_data_min, supplemental_log_data_pk, supplemental_log_data_ui,

supplemental_log_data_fk, supplemental_log_data_all

from v$database;

8, to understand the composition of the control files

select * from v$controlfile;

9, to understand the composition of the log file

select l.group#, lf.type, lf.member, l.bytes, l.status LOG_STATUS, lf.status LOGFILE_STATUS

from v$log l, v$logfile lf

where l.group# = lf.group#

order by 1,3;

10, to understand the composition and location of the parameter file

show parameter spfile

create spfile from pfile...

create pfile from spfile;

create spfile from memory;

create pfile from memory;

11, about instance related information

select instance_name, host_name, status, archiver, database_status, instance_role, active_state

from v$instance;

12, user and password-related

Whether to use the default password?

Whether to use a profile?

It hired a password verification function?

User authentication method?

The password is case-sensitive and so on.

select name, value from gv$parameter where name = 'resource_limit';

select profile, resource_name, limit from dba_profiles order by 1,2;

select username, profile from dba_users where account_status = 'OPEN' order by 1;

select d.username, u.account_status

from dba_users_with_defpwd d, dba_users u

where d.username = u.username and account_status = 'OPEN'

order by 2,1;

13, is opened BLOCK CHANGE TRACKING

select filename, status, bytes from v$block_change_tracking;

14, begun using those features (Feature)?

DBMS_FEATURE_USAGE_REPORT

15, table spaces and data files of the planning

That we are all familiar with, do not write

16, character set-related

select * from database_properties;

17, the system the existence of invalid object

select owner, object_type, COUNT(*)

from dba_objects

where status = 'INVALID'

group by owner, object_type;

18, further

Are you using ASM?

The current system of backup methods and strategies that?

Network file configuration is how?

19, look at the recent alert log to get some useful information

20, run a few performance analysis report to see how the recent state of the system running

21, ran an RDA report, collection of complete system status report

Well, with these some basic information (not completely), you are basically on your new contact with this system have a rough understanding of access to, you then slowly in-depth analysis, and then formulate a set of realistic The operation and maintenance of norms, slowly pig bar.