What Oracle DBA must understand in the new environment

Here, we will not talk about those major aspects, such as understanding the overall situation of the entire IT environment. If you already know this, you need to face these living databases. here we have summarized some general ideas to face a database first, so as to quickly understand the environment overview you are facing.

This is not a textbook, but a few experiences and experiences. For this kind of problem, everyone's understanding is different. You are welcome to continue to improve your understanding.

1. First, you must understand the version and platform of the current Oracle database.

This is very important. After a long time, I still know which version of your database is and on which system it runs. It is not very sad, so I personally think this is the first step to understand. The following scripts help you obtain the required information.

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. Next, you need to know which components are installed in your database.

select * from dba_registry;

3. Do you know whether the environment is a single machine or a cluster?

There are many methods to determine this. Here I will provide a method to determine it using dbms_utility.

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 the volume uard configured?

select protection_mode, protection_level, remote_archive, database_role, dataguard_broker,guard_status from v$database;

5. Is the archive mode used?

conn /as sysdba archive log list;

Select log_mode from v $ database;

6. Have you used the flashback database feature?

select flashback_on from v$database;

If yes, check the FRA configuration.

7. Are force logging and supplemental logs used?

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. Understand the composition of Control Files

select * from v$controlfile;

9. Understand the composition of log files

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. 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. Learn more about the instance

select instance_name, host_name, status, archiver, database_status, instance_role, active_state from v$instance;

12. User and password Problems

Is the default password used?

Is profile used?

Is password verification function used?

How does one verify user identity?

Whether the password is case sensitive or not.

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. Whether block change tracking is enabled

select filename, status, bytes from v$block_change_tracking;

14. What features are used )?

DBMS_FEATURE_USAGE_REPORT

15. Planning of tablespaces and data files

Everyone is familiar with this and will not write it.

16. Character Set

select * from database_properties;

17. Whether the invalid object exists in the system

select owner, object_type, COUNT(*) from dba_objects where status = 'INVALID' group by owner, object_type;

18. Further steps

Is ASM used?

What is the current system backup method and policy?

What is the network file configuration?

19. Check the recent alert logs to obtain useful information.

20. run several performance analysis reports to see how the system is running recently.

21. Run an RDA report to collect the complete system status report.

Well, with this basic information (incomplete), you have a general understanding of the system you are new to. Next, you can analyze it in depth, then we will formulate a set of O & M specifications that meet the actual conditions, so we can gradually raise pigs.

1. Oracle DBA responsibilities and daily work analysis
2. DBA tool: Enterprise monitor simplifies MySQL Management
3. DBA's SQL Server 2005 backup and maintenance plan