Shulou(Shulou.com)06/01 Report--

This article shows you what you need to know about new access to the oracle database, the content is concise and easy to understand, it will definitely brighten your eyes. I hope you can get something through the detailed introduction of this article.

When we come to a new database environment, the first things we need to know are as follows:

1. First, we should know the version and platform of the current Oracle database and related information.

This is very important, but also busy for a long time to know which version of your database, what system is running, that is not very sad, so I personally think this is the first step to understand. The following scripts can help you get the 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. Second, know which components are installed in your database.

Select * from dba_registry

3. Find out whether this environment is stand-alone or clustered?

There are many ways to judge this, and here I give a method to judge with the help of 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 DataGuard configured?

Select protection_mode, protection_level, remote_archive, database_role, dataguard_broker,guard_status

From v$database

5. Is the archiving mode used?

Conn / as sysdba

Archive log list

Select log_mode from v$database

6. Is the flashback database feature used?

Select flashback_on from v$database

If so, check the configuration of FRA further.

7. Do you use force logging and supplementary logs?

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 the control file

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 about instance

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

From v$instance

12. User and password related

Is the default password used?

Is profile used?

Is the password authentication function used?

How to authenticate the user?

Whether the password is case-sensitive, etc.

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 open or not

Select filename, status, bytes from v$block_change_tracking

14. What features (Feature) have been used?

DBMS_FEATURE_USAGE_REPORT

15. Planning of table spaces and data files

Everyone is familiar with this, so I won't write it.

16. Character set correlation

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

Is ASM used?

What is the current backup method and strategy of the system?

What is the configuration of network files?

19. Check the recent alert log for some useful information

20. Run a few performance analysis reports to see how the system is running recently

21. Run a RDA report and collect a complete system status report

The above is what you need to know when you are new to oracle database. Have you learned any knowledge or skills? If you want to learn more skills or enrich your knowledge reserve, you are welcome to follow the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.